Alchemy Bug

[lemoniscool]

Hi!
I have a bug on my server that european items cant be upgraded .. my players put the item in, use the right elixir and magic powder and klick go .. then it loads and loads and then it diesnt change anything on the item, elixir and magic powder stay in inventory and the item isnt upgraded. Also the error message they get is:
"Cannot use a Elixir that is different from Items Type" Like as they put the wrong elixir, but its not its the right and it goes inside the window but the upgrade itself doesnt work ...

Anyone ever had this problem or knows what could cause this? Any help on this please ..

if you need to see the problem pm me ill tell you how to get on my server to test it your self ..

Thanks in advance
LemoniscooL

[MentaL]

[lemoniscool]

bump .. i still need help on this please ...

[frigga]

_RefObjItem

[lemoniscool]

yea i thought that already .. but i cant find anything that doesnt fit there .. i double checked with other dbs (statiic and other ones) all elixirs and magic powders .. they are all the same except the rates i use

[lemoniscool]

erm .. screw my last post i was at refobjcommon ..
anyways i checked all those lines now and still cant find any errors in there .. could you be a little more specific?


//edit:
got it .. if someone should ever experience this bug too .. do it this way to fix:

downlaod playsro or king sro database from this forum, download oracle sql developer and the mssql extension for it, connect to your sql server and export the _RefObjItem table as insert

you will get the SQL statements to add all lines of that table to your broken one.. then use "truncate table _RefObjItem" and after that execute the statements you got from your export ... but if you dont have a pc with 16 GB of ram do it in 1000 lines per query else your queries will fail because you dont have enough ram to do it

greetz