[BUG DB] BINDING SYSTEM

[tristano98 6]

Hello guys, i'm have this bug:

The file game starts and works 100% but every time restart the items disappear and giving this SYSERR in DB 

Spoiler

SYSERR: Jan 24 07:37:28 :: ChildLoop: AsyncSQL: query failed: Unknown column 'bind' in 'field list' (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, applytype0, applyvalue0, applytype1, applyvalue1, applytype2, applyvalue2, applytype3, applyvalue3, applytype4, applyvalue4, applytype5, applyvalue5, applytype6, applyvalue6, applytype7, applyvalue7 FROM item WHERE owner_id=4 AND (window < 3 or window = 5) errno: 1054)
SYSERR: Jan 24 07:37:28 :: RESULT_COMPOSITE_PLAYER: null MYSQL_RES QID 1
SYSERR: Jan 24 08:00:20 :: ChildLoop: AsyncSQL: query failed: Unknown column 'bind' in 'field list' (query: REPLACE INTO item (id, owner_id, window, pos, count, vnum,bind, attrtype0, attrvalue0, attrtype1, attrvalue1, attrtype2, attrvalue2, attrtype3, attrvalue3, attrtype4, attrvalue4, attrtype5, attrvalue5, attrtype6, attrvalue6, applytype0, applyvalue0, applytype1, applyvalue1, applytype2, applyvalue2, applytype3, applyvalue3, applytype4, applyvalue4, applytype5, applyvalue5, applytype6, applyvalue6, applytype7, applyvalue7) VALUES(30000005, 31278, 2, 1, 1, 21529 ,0 , 7, 8, 10, 30, 11, 30, 28, 15, 24, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0) errno: 1054)
SYSERR: Jan 24 08:00:20 :: ChildLoop: AsyncSQL: query failed: Unknown column 'bind' in 'field list' (query: REPLACE INTO item (id, owner_id, window, pos, count, vnum,bind, attrtype0, attrvalue0, attrtype1, attrvalue1, attrtype2, attrvalue2, attrtype3, attrvalue3, attrtype4, attrvalue4, attrtype5, attrvalue5, attrtype6, attrvalue6, applytype0, applyvalue0, applytype1, applyvalue1, applytype2, applyvalue2, applytype3, applyvalue3, applytype4, applyvalue4, applytype5, applyvalue5, applytype6, applyvalue6, applytype7, applyvalue7) VALUES(30000002, 31278, 2, 10, 1, 13049 ,0 , 3, 12, 27, 15, 39, 10, 48, 1, 49, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0) errno: 1054)
SYSERR: Jan 24 08:00:20 :: ChildLoop: AsyncSQL: query failed: Unknown column 'bind' in 'field list' (query: REPLACE INTO item (id, owner_id, window, pos, count, vnum,bind, attrtype0, attrvalue0, attrtype1, attrvalue1, attrtype2, attrvalue2, attrtype3, attrvalue3, attrtype4, attrvalue4, attrtype5, attrvalue5, attrtype6, attrvalue6, applytype0, applyvalue0, applytype1, applyvalue1, applytype2, applyvalue2, applytype3, applyvalue3, applytype4, applyvalue4, applytype5, applyvalue5, applytype6, applyvalue6, applytype7, applyvalue7) VALUES(30000006, 31278, 2, 3, 1, 14109 ,0 , 1, 2000, 2, 80, 16, 10, 23, 10, 25, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0) errno: 1054)
SYSERR: Jan 24 08:00:20 :: ChildLoop: AsyncSQL: query failed: Unknown column 'bind' in 'field list' (query: REPLACE INTO item (id, owner_id, window, pos, count, vnum,bind, attrtype0, attrvalue0, attrtype1, attrvalue1, attrtype2, attrvalue2, attrtype3, attrvalue3, attrtype4, attrvalue4, attrtype5, attrvalue5, attrtype6, attrvalue6, applytype0, applyvalue0, applytype1, applyvalue1, applytype2, applyvalue2, applytype3, applyvalue3, applytype4, applyvalue4, applytype5, applyvalue5, applytype6, applyvalue6, applytype7, applyvalue7) VALUES(30000003, 31278, 2, 2, 1, 15189 ,0 , 1, 2000, 2, 80, 8, 8, 7, 8, 15, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0) errno: 1054)
SYSERR: Jan 24 08:00:20 :: ChildLoop: AsyncSQL: query failed: Unknown column 'bind' in 'field list' (query: REPLACE INTO item (id, owner_id, window, pos, count, vnum,bind, attrtype0, attrvalue0, attrtype1, attrvalue1, attrtype2, attrvalue2, attrtype3, attrvalue3, attrtype4, attrvalue4, attrtype5, attrvalue5, attrtype6, attrvalue6, applytype0, applyvalue0, applytype1, applyvalue1, applytype2, applyvalue2, applytype3, applyvalue3, applytype4, applyvalue4, applytype5, applyvalue5, applytype6, applyvalue6, applytype7, applyvalue7) VALUES(30000007, 31278, 2, 6, 1, 17109 ,0 , 8, 20, 25, 10, 41, 5, 22, 20, 21, 20, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0) errno: 1054)
SYSERR: Jan 24 08:00:20 :: ChildLoop: AsyncSQL: query failed: Unknown column 'bind' in 'field list' (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, applytype0, applyvalue0, applytype1, applyvalue1, applytype2, applyvalue2, applytype3, applyvalue3, applytype4, applyvalue4, applytype5, applyvalue5, applytype6, applyvalue6, applytype7, applyvalue7) VALUES(30000004, 31278, 2, 4, 1, 6079 ,0 , 1, 1, 1, 72, 60, 71, -39, 16, 10, 22, 20, 5, 12, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0) errno: 1054)
SYSERR: Jan 24 08:00:20 :: ChildLoop: AsyncSQL: query failed: Unknown column 'bind' in 'field list' (query: REPLACE INTO item (id, owner_id, window, pos, count, vnum,bind, attrtype0, attrvalue0, attrtype1, attrvalue1, attrtype2, attrvalue2, attrtype3, attrvalue3, attrtype4, attrvalue4, attrtype5, attrvalue5, attrtype6, attrvalue6, applytype0, applyvalue0, applytype1, applyvalue1, applytype2, applyvalue2, applytype3, applyvalue3, applytype4, applyvalue4, applytype5, applyvalue5, applytype6, applyvalue6, applytype7, applyvalue7) VALUES(30000008, 31278, 2, 5, 1, 16109 ,0 , 1, 2000, 2, 80, 15, 10, 16, 10, 24, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0) errno: 1054)
SYSERR: Jan 24 08:00:20 :: ChildLoop: AsyncSQL: query failed: Unknown column 'bind' in 'field list' (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, applytype0, applyvalue0, applytype1, applyvalue1, applytype2, applyvalue2, applytype3, applyvalue3, applytype4, applyvalue4, applytype5, applyvalue5, applytype6, applyvalue6, applytype7, applyvalue7) VALUES(30000001, 31278, 2, 0, 1, 21089 ,0 , 1, 1, 1, 1, 2000, 9, 20, 23, 10, 39, 10, 53, 50, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0) errno: 1054)
SYSERR: Jan 24 08:02:29 :: ChildLoop: AsyncSQL: query failed: Unknown column 'bind' in 'field list' (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, applytype0, applyvalue0, applytype1, applyvalue1, applytype2, applyvalue2, applytype3, applyvalue3, applytype4, applyvalue4, applytype5, applyvalue5, applytype6, applyvalue6, applytype7, applyvalue7 FROM item WHERE owner_id=31278 AND (window < 3 or window = 5) errno: 1054)
SYSERR: Jan 24 08:02:29 :: RESULT_COMPOSITE_PLAYER: null MYSQL_RES QID 1
SYSERR: Jan 24 08:48:52 :: ChildLoop: AsyncSQL: query failed: Unknown column 'bind' in 'field list' (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, applytype0, applyvalue0, applytype1, applyvalue1, applytype2, applyvalue2, applytype3, applyvalue3, applytype4, applyvalue4, applytype5, applyvalue5, applytype6, applyvalue6, applytype7, applyvalue7 FROM item WHERE owner_id=13 AND (window < 3 or window = 5) errno: 1054)
SYSERR: Jan 24 08:48:52 :: RESULT_COMPOSITE_PLAYER: null MYSQL_RES QID 1
SYSERR: Jan 26 00:25:57 :: pid_init: 

 

[tierrilopes 446]

« Unknown column 'bind' in 'field list' »

 

you dont have field on database.

Go design mode and add it

[tristano98 6]

1 hour ago, tierrilopes said:

« Unknown column 'bind' in 'field list' »

 

you dont have field on database.

Go design mode and add it

ok thanks, i'm add column but i'm have this error now and items  disappear

Spoiler

SYSERR: Jan 26 01:50:43 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Jan 26 01:50:43 :: ChildLoop: AsyncSQL: query failed: Query execution was interrupted (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, applytype0, applyvalue0, applytype1, applyvalue1, applytype2, applyvalue2, applytype3, applyvalue3, applytype4, applyvalue4, applytype5, applyvalue5, applytype6, applyvalue6, applytype7, applyvalue7) VALUES(10000001, 31278, 2, 0, 1, 21089 ,259200 , 1, 1, 1, 1, 2000, 9, 20, 23, 10, 39, 10, 53, 50, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0) errno: 1317)
SYSERR: Jan 26 01:50:43 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (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, applytype0, applyvalue0, applytype1, applyvalue1, applytype2, applyvalue2, applytype3, applyvalue3, applytype4, applyvalue4, applytype5, applyvalue5, applytype6, applyvalue6, applytype7, applyvalue7) VALUES(10000004, 31278, 2, 4, 1, 6079 ,1 , 1, 1, 1, 72, 60, 71, -39, 16, 10, 22, 20, 5, 12, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0) errno: 2002)
SYSERR: Jan 26 01:50:43 :: ChildLoop: AsyncSQL: retrying
SYSERR: Jan 26 01:50:43 :: pid_deinit: 
End of pid