Jump to content
  • 0

how to fix it


Traceur3RUN

Question

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)

Link to comment
Share on other sites

7 answers to this question

Recommended Posts

  • 0
  • Former Staff

 

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

  • Love 1
Link to comment
Share on other sites

  • 0

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:

Link to comment
Share on other sites

  • 0
  • Former Staff

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" :)

Link to comment
Share on other sites

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


×
×
  • 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.