Jump to content

Item table - Query error


Recommended Posts

Hello guys I have a problem with my item table, it doesn't store items.

Here is DB syserr

 SYSERR: Sep 10 10:34:08.386863 :: ChildLoop: AsyncSQL: query failed: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'window+0,pos,count,vnum,bind,socket0,socket1,socket2,attrtype0,attrvalue0,attrty' at line 1 (query: SELECT id,window+0,pos,count,vnum,bind,socket0,socket1,socket2,attrtype0,attrvalue0,attrtype1,attrvalue1,attrtype2,attrvalue2,attrtype3,attrvalue3,attrtype4,attrvalue4,attrtype5,attrvalue5,attrtype6,attrvalue6 FROM item WHERE owner_id=170 AND (window < 3 or window = 5) errno: 1064)
SYSERR: Sep 10 10:34:08.485291 :: RESULT_COMPOSITE_PLAYER: null MYSQL_RES QID 1
SYSERR: Sep 10 10:34:34.290094 :: ChildLoop: AsyncSQL: query failed: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'window, pos, count, vnum, bind, socket0, socket1, socket2, attrtype0, attrvalue0' at line 1 (query: REPLACE INTO item (id, owner_id, window, pos, count, vnum, bind, socket0, socket1, socket2, attrtype0, attrvalue0, attrtype1, attrvalue1, attrtype2, attrvalue2, attrtype3, attrvalue3, attrtype4, attrvalue4, attrtype5, attrvalue5, attrtype6, attrvalue6) VALUES(10000001, 170, 1, 0, 1, 19, 0, 1, 0, 0, 92, 5, 12, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0) errno: 1064) 

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now

Announcements



×
×
  • Create New...

Important Information

Terms of Use / Privacy Policy / Guidelines / We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.