Hey guys, i have a problem.
I need help with this.
as in the subject, items in inventory dissappear after server restart.
Sysser from dB:
SYSERR: Oct 2 00:45:07 :: ChildLoop: AsyncSQL: query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '('INVENTORY','EQUIPMENT','DRAGON_SOUL_INVENTORY','SWITCHBOT','BELT_INVENTORY'))W' at line 1 (query: SELECT id,`window`+0,pos,count,vnum,socket0,socket1,socket2,attrtype0,attrvalue0,attrtype1,attrvalue1,attrtype2,attrvalue2,attrtype3,attrvalue3,attrtype4,attrvalue4,attrtype5,attrvalue5,attrtype6,attrvalue6 FROM itemin ('INVENTORY','EQUIPMENT','DRAGON_SOUL_INVENTORY','SWITCHBOT','BELT_INVENTORY'))WHERE owner_id=138180644 AND (window < 1 or window = 1 or window = 134659116) errno: 1064)
SYSERR: Oct 2 00:45:07 :: RESULT_COMPOSITE_PLAYER: null MYSQL_RES QID 1
can someone help me with this?
for 2 days I tried to fix it but to no avail.
sorry for my english