Alchemy issue The type does not suit the corresponding item

05/26/2020 00:18 CloudStrife^#1
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
05/26/2020 04:11 mudik#2
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 :)
05/26/2020 11:39 CloudStrife^#3
Quote:
Originally Posted by mudik View Post
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.
05/26/2020 17:40 mudik#4
Quote:
Originally Posted by CloudStrife^ View Post
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
05/26/2020 21:41 CloudStrife^#5
Quote:
Originally Posted by mudik View Post
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.
05/26/2020 22:16 mudik#6
Quote:
Originally Posted by CloudStrife^ View Post
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?
05/26/2020 22:21 CloudStrife^#7
Quote:
Originally Posted by mudik View Post
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 :(

Quote:
Originally Posted by CloudStrife^ View Post
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.
05/29/2020 00:12 mudik#8
Quote:
Originally Posted by CloudStrife^ View Post
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 :)