how to fix it

[Traceur3RUN 98]

SYSERR: Jan  3 17:24:40 :: ChildLoop: AsyncSQL: query failed: Unknown column 'window' in 'field list' (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 item  WHERE owner_id=57755 AND (window < 3 or window = 5) errno: 1054)

[Shogun 5758]

You are missing the field "window" in the player.item table. Where do you guys get this broken databases from?

[Traceur3RUN 98]

You are missing the field "window" in the player.item table. Where do you guys get this broken databases from?

from db

[flygun 356]

 

You are missing the field "window" in the player.item table. Where do you guys get this broken databases from?

from db

 

lol db = database ... he asked this question because there are many problems with people  in a lot of databases

[Shogun 5758]

Yeah I keep seeing missing fields in syserrs so I wonder who is passing around those databases that don't even work still in 2015.

[Traceur3RUN 98]

i fix it but now new error from ch1

 

SYSERR: Jan  3 18:37:48 :: ReadVnumMapper: dragon_soul_table.txt need VnumMapper.
SYSERR: Jan  3 18:37:48 :: Boot: cannot load DragonSoulTable: locale/poland/dragon_soul_table.txt
SYSERR: Jan  3 18:38:08 :: ChildLoop: AsyncSQL: query failed: DELAYED option not supported for table 'log' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 57755, 51892, 166625, 0, 'LOGIN', '192.168.1.26 0 1 1 0', '192.168.1.26') errno: 1616)
SYSERR: Jan  3 18:38:09 :: ChildLoop: AsyncSQL: query failed: DELAYED option not supported for table 'log' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 57755, 51892, 166625, 0, 'LOGOUT', '192.168.1.26 0 1 1 0', '192.168.1.26') errno: 1616)
SYSERR: Jan  3 18:39:51 :: ChildLoop: AsyncSQL: query failed: DELAYED option not supported for table 'log' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 57755, 51892, 166625, 0, 'LOGIN', '192.168.1.26 0 1 1 0', '192.168.1.26') errno: 1616)
SYSERR: Jan  3 18:40:13 :: ChildLoop: AsyncSQL: query failed: DELAYED option not supported for table 'log' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 57755, 51892, 166625, 0, 'LOGOUT', '192.168.1.26 0 1 1 0', '192.168.1.26') errno: 1616)
SYSERR: Jan  3 18:43:06 :: ChildLoop: AsyncSQL: query failed: DELAYED option not supported for table 'log' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 57755, 51892, 166625, 0, 'LOGIN', '192.168.1.26 0 1 1 0', '192.168.1.26') errno: 1616)
SYSERR: Jan  3 18:43:20 :: ChildLoop: AsyncSQL: query failed: DELAYED option not supported for table 'log' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 57755, 51892, 166625, 0, 'LOGOUT', '192.168.1.26 0 1 1 0', '192.168.1.26') errno: 1616)
SYSERR: Jan  3 18:46:30 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Jan  3 18:46:31 :: pid_deinit:

[flygun 356]

i fix it but now new error from ch1

 

SYSERR: Jan  3 18:37:48 :: ReadVnumMapper: dragon_soul_table.txt need VnumMapper.

SYSERR: Jan  3 18:37:48 :: Boot: cannot load DragonSoulTable: locale/poland/dragon_soul_table.txt

SYSERR: Jan  3 18:38:08 :: ChildLoop: AsyncSQL: query failed: DELAYED option not supported for table 'log' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 57755, 51892, 166625, 0, 'LOGIN', '192.168.1.26 0 1 1 0', '192.168.1.26') errno: 1616)

SYSERR: Jan  3 18:38:09 :: ChildLoop: AsyncSQL: query failed: DELAYED option not supported for table 'log' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 57755, 51892, 166625, 0, 'LOGOUT', '192.168.1.26 0 1 1 0', '192.168.1.26') errno: 1616)

SYSERR: Jan  3 18:39:51 :: ChildLoop: AsyncSQL: query failed: DELAYED option not supported for table 'log' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 57755, 51892, 166625, 0, 'LOGIN', '192.168.1.26 0 1 1 0', '192.168.1.26') errno: 1616)

SYSERR: Jan  3 18:40:13 :: ChildLoop: AsyncSQL: query failed: DELAYED option not supported for table 'log' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 57755, 51892, 166625, 0, 'LOGOUT', '192.168.1.26 0 1 1 0', '192.168.1.26') errno: 1616)

SYSERR: Jan  3 18:43:06 :: ChildLoop: AsyncSQL: query failed: DELAYED option not supported for table 'log' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 57755, 51892, 166625, 0, 'LOGIN', '192.168.1.26 0 1 1 0', '192.168.1.26') errno: 1616)

SYSERR: Jan  3 18:43:20 :: ChildLoop: AsyncSQL: query failed: DELAYED option not supported for table 'log' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 57755, 51892, 166625, 0, 'LOGOUT', '192.168.1.26 0 1 1 0', '192.168.1.26') errno: 1616)

SYSERR: Jan  3 18:46:30 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.

SYSERR: Jan  3 18:46:31 :: pid_deinit:

use other db to save time for you and "US"

[Ayaka 322]

Quote:

INSERT DELAYED works only with MyISAM, MEMORY, ARCHIVE, and (as of MySQL 5.1.19) BLACKHOLE tables. If you execute INSERT DELAYED with another storage engine, you will get this error.

 

as simple as it is. Change the storage engine.