Jump to content
×
×
  • Create New...
  • 0

Item table - Query error


shuty

Question

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

  • Answers 0
  • Created
  • Last Reply

Top Posters For This Question

Popular Days

Top Posters For This Question

0 answers to this question

Recommended Posts

There have been no answers to this question yet

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.


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.