Alchemy issue The type does not suit the corresponding item

[CloudStrife^]

Hello,
I have an issue with Alchemy. When I try to use Astral, Immortal and Lucky stones I got this error message:
The type does not suit the corresponding item.
I tried stones 11 Degree and 2 Degree. Same error.
Other stones like Str work fine.
Do you have any ideas on this issue?
Thank you

[mudik]

I remember I had the same Problem ago 1-2 years. You played with the params, delete the item the alchemy item and copy it and past it from a clean db or any dB when you are sure it’s a good dB without bugs. Good luck

[CloudStrife^]

Originally Posted by mudik

I remember I had the same Problem ago 1-2 years. You played with the params, delete the item the alchemy item and copy it and past it from a clean db or any dB when you are sure it’s a good dB without bugs. Good luck

Thank you for your answer.
Yes, I made some changes regarding alchemy rates and items stacks.
Maybe something went wrong with those changes. I will try to restore to previous versions. Do you know exactly what tables may be involved to this issue?
Thank you.

[mudik]

Originally Posted by CloudStrife^

Thank you for your answer.
Yes, I made some changes regarding alchemy rates and items stacks.
Maybe something went wrong with those changes. I will try to restore to previous versions. Do you know exactly what tables may be involved to this issue?
Thank you.

I think it’s RefObjItem the params, you did wrong calculation and this is why it’s not work on items. Sorry my English is not the best can’t help you with 100% correct information

[CloudStrife^]

Originally Posted by mudik

I think it’s RefObjItem the params, you did wrong calculation and this is why it’s not work on items. Sorry my English is not the best can’t help you with 100% correct information

Hello,
I tried to restore the table RefObjItem from a clean DB. All the stacks and alchemy rates changes have been reset but I still have the same error. Cannot use Immortal, Luck and Astral.
Any other idea to help? Thanks a lot.

[mudik]

Originally Posted by CloudStrife^

Hello,
I tried to restore the table RefObjItem from a clean DB. All the stacks and alchemy rates changes have been reset but I still have the same error. Cannot use Immortal, Luck and Astral.
Any other idea to help? Thanks a lot.

You did media side to?

[CloudStrife^]

Originally Posted by mudik

You did media side to?

Yes, sure. I used the DB2Media tool and generated new Media.pk2 with all new ItemData_x, and all other files.
In fact, on client side I can see old items stacks.

I found a clue:
when I mouse over Astral/Immortal/Luck stones i can see that:
Sort of item: Alchemy Stone
Object item: <Empty>

Instead, on the stones that are working, I can see:
Sort of item: Alchemy Stone
Object item: Weapon Type

This is what is missing I think. But I have no idea where to associate the Weapon Type to the stone. The database and client side seem correct

Originally Posted by CloudStrife^

Yes, sure. I used the DB2Media tool and generated new Media.pk2 with all new ItemData_x, and all other files.
In fact, on client side I can see old items stacks.

I found a clue:
when I mouse over Astral/Immortal/Luck stones i can see that:
Sort of item: Alchemy Stone
Object item: <Empty>

Instead, on the stones that are working, I can see:
Sort of item: Alchemy Stone
Object item: Weapon Type

This is what is missing I think. But I have no idea where to associate the Weapon Type to the stone. The database and client side seem correct

After some time and analysis I found the solution.
I will share the solution, hope it may help anyone who face this kind of issue.
The issue is related to _RefMagicOpt table and MagicOption.txt file in Media.pk2
There is a column "Prob", and these attributes:

MATTR_ATHANASIA (Immortal)
MATTR_SOLID (Steady)
MATTR_LUCK (Luck)
MATTR_ASTRAL (Astral)

have all the value 0,3.
When generating the MagicOption.txt using the DB2Media tool, this value is still "0,3" but it is not accepted by the client.
I tried to replace it with "0.3" and works fine (didn't replace on the DB, just MagicOption.txt).
I don't know what this "Prob" stands for (Probability of something?). All the other stones have this value set to 1.
Hope this may help.

[mudik]

Originally Posted by CloudStrife^

Yes, sure. I used the DB2Media tool and generated new Media.pk2 with all new ItemData_x, and all other files.
In fact, on client side I can see old items stacks.

I found a clue:
when I mouse over Astral/Immortal/Luck stones i can see that:
Sort of item: Alchemy Stone
Object item: <Empty>

Instead, on the stones that are working, I can see:
Sort of item: Alchemy Stone
Object item: Weapon Type

This is what is missing I think. But I have no idea where to associate the Weapon Type to the stone. The database and client side seem correct



After some time and analysis I found the solution.
I will share the solution, hope it may help anyone who face this kind of issue.
The issue is related to _RefMagicOpt table and MagicOption.txt file in Media.pk2
There is a column "Prob", and these attributes:

MATTR_ATHANASIA (Immortal)
MATTR_SOLID (Steady)
MATTR_LUCK (Luck)
MATTR_ASTRAL (Astral)

have all the value 0,3.
When generating the MagicOption.txt using the DB2Media tool, this value is still "0,3" but it is not accepted by the client.
I tried to replace it with "0.3" and works fine (didn't replace on the DB, just MagicOption.txt).
I don't know what this "Prob" stands for (Probability of something?). All the other stones have this value set to 1.
Hope this may help.

Good job dude