Błąd tylko dla wytrwałych !

[JestemWariat]

Witam od pewnego czasu wywala mi taki błąd w sysser chaneli 

 

co on oznacza ?

SYSERR: Nov  1 01:16:16 :: GetServerLocation: location error name sdvs mapindex 0 845100 x 745900 empire 3
SYSERR: Nov  1 01:16:22 :: GetServerLocation: location error name sdvs mapindex 0 845100 x 745900 empire 3
SYSERR: Nov  1 01:16:22 :: ChildLoop: AsyncSQL: query failed: Unknown column 'ip' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 1289, 957095, 255049, 0, 'LOGIN', '25.118.108.54 0 1 5 0', '25.118.108.54') errno: 1054)
SYSERR: Nov  1 01:16:22 :: ChildLoop: AsyncSQL: query failed: Table 'log.loginlog2' doesn't exist (query: INSERT INTO loginlog2(type, is_gm, login_time, channel, account_id, pid, ip, client_version) VALUES('INVALID', 'N', NOW(), 1, 346544167, 1289, inet_aton('25.118.108.54'), '') errno: 1146)
SYSERR: Nov  1 01:16:35 :: ChildLoop: AsyncSQL: query failed: Table 'log.loginlog2' doesn't exist (query: SET @i = (SELECT MAX(id) FROM loginlog2 WHERE account_id=346544167 AND pid=1289) errno: 1146)
SYSERR: Nov  1 01:16:35 :: ChildLoop: AsyncSQL: query failed: Table 'log.loginlog2' doesn't exist (query: UPDATE loginlog2 SET type='VALID', logout_time=NOW(), playtime=TIMEDIFF(logout_time,login_time) WHERE id=@i errno: 1146)
SYSERR: Nov  1 01:16:35 :: ChildLoop: AsyncSQL: query failed: Unknown column 'ip' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 1289, 957095, 255049, 0, 'LOGOUT', '', '25.118.108.54') errno: 1054)

 

a tu sysser DB

 

SYSERR: Nov  1 00:45:12 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL errno: 2002)
SYSERR: Nov  1 00:45:12 :: ChildLoop: AsyncSQL: retrying
SYSERR: Nov  1 00:45:13 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Nov  1 00:45:13 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL errno: 2002)
SYSERR: Nov  1 00:45:13 :: ChildLoop: AsyncSQL: retrying
SYSERR: Nov  1 00:45:13 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL errno: 2002)
SYSERR: Nov  1 00:45:13 :: ChildLoop: AsyncSQL: retrying
SYSERR: Nov  1 00:46:57 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Nov  1 00:46:57 :: LoadMonarchCandidacy:  DirectQuery failed(SELECT pid, name, date FROM monarch_candidacy a, player b where a.pid = b.id)
SYSERR: Nov  1 00:46:57 :: Load:  DirectQuery failed(SELECT login FROM block_exception)
SYSERR: Nov  1 01:05:07 :: ChildLoop: AsyncSQL: query failed: Query execution was interrupted (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL errno: 1317)
SYSERR: Nov  1 01:05:10 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Nov  1 01:05:10 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: UPDATE player SET job = 6, voice = 0, dir = 0, x = 957095, y = 255049, z = 0, map_index = 5, exit_x = 957095, exit_y = 255049, exit_map_index = 5, hp = 770, mp = 300, stamina = 815, random_hp = 0, random_sp = 0, playtime = 0, level = 1, level_step = 0, st = 5, ht = 3, dx = 3, iq = 5, gold = 0, exp = 0, stat_point = 0, skill_point = 0, sub_skill_point = 0, stat_reset_count = 0, ip = '25.118.108.54', part_main = 0, part_hair = 0, last_play = NOW(), skill_group = 0, alignment = 0, horse_level = 30, horse_riding = 0, horse_hp = 0, horse_hp_droptime = 0, horse_stamina = 200, horse_skill_point = 0, skill_level = '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\
SYSERR: Nov  1 01:05:10 :: ChildLoop: AsyncSQL: retrying
SYSERR: Nov  1 01:06:46 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Nov  1 01:06:46 :: LoadMonarchCandidacy:  DirectQuery failed(SELECT pid, name, date FROM monarch_candidacy a, player b where a.pid = b.id)
SYSERR: Nov  1 01:06:46 :: Load:  DirectQuery failed(SELECT login FROM block_exception)

 

[dzekon]

Te błędy, to brakujące tabelki w bazie danych.

Musisz poszukać tych tabelek gdzieś w necie...

Zobacz te:

http://www.mpcforum.pl/topic/330541-poprawne-tabelki-z-logami-w-sf2010/

[JestemWariat]

ref

[Sathian]

ChildLoop: AsyncSQL: query failed: Table 'log.loginlog2' doesn't exist 

 

Nie masz tabelki loginlog2 w bazie log.

Zrób taką tabelę albo pobierz z jakichś plików.

 

Z tego co widzę to cała DB jest jakaś nie teges.

Spróbuj wgrać ją na nowo.