How can rezolv ?

[MrFrancisc]

I have a private server ,and i have a "little" problem
The problem is :
At intervals of time ,others players are disconnected
How can rezolv ?

In Channel 1 ,in "syserr" these errors occur

SYSERR: Jan 31 22:12:06 :: ChildLoop: AsyncSQL: query failed: Unknown column 'ip' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 1, 18, 4, 11173325, 'SET_ATTR', '', '93.114.55.59', 299) errno: 1054)
SYSERR: Jan 31 22:12:06 :: ChildLoop: AsyncSQL: query failed: Unknown column 'ip' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 2, 19, 10, 11173325, 'SET_ATTR', '', '93.114.55.59', 299) errno: 1054)
SYSERR: Jan 31 22:12:06 :: ChildLoop: AsyncSQL: query failed: Unknown column 'ip' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 3, 3, 8, 11173325, 'SET_ATTR', '', '93.114.55.59', 299) errno: 1054)
SYSERR: Jan 31 22:12:06 :: ChildLoop: AsyncSQL: query failed: Unknown column 'ip' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 59448, 965841, 269481, 11286188, 'CHANGE_ATTRIBUTE', '11173325', '93.114.55.59', 71084) errno: 1054)
SYSERR: Jan 31 22:12:07 :: ChildLoop: AsyncSQL: query failed: Unknown column 'ip' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 0, 72, 4294967289, 11173325, 'SET_ATTR', '', '93.114.55.59', 299) errno: 1054)
SYSERR: Jan 31 22:12:07 :: ChildLoop: AsyncSQL: query failed: Unknown column 'ip' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 1, 71, 5, 11173325, 'SET_ATTR', '', '93.114.55.59', 299) errno: 1054)
SYSERR: Jan 31 22:12:07 :: ChildLoop: AsyncSQL: query failed: Unknown column 'ip' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 2, 20, 6, 11173325, 'SET_ATTR', '', '93.114.55.59', 299) errno: 1054)
SYSERR: Jan 31 22:12:07 :: ChildLoop: AsyncSQL: query failed: Unknown column 'ip' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 3, 9, 8, 11173325, 'SET_ATTR', '', '93.114.55.59', 299) errno: 1054)
SYSERR: Jan 31 22:12:07 :: ChildLoop: AsyncSQL: query failed: Unknown column 'ip' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 59448, 965841, 269481, 11286188, 'CHANGE_ATTRIBUTE', '11173325', '93.114.55.59', 71084) errno: 1054)
SYSERR: Jan 31 22:12:07 :: ChildLoop: AsyncSQL: query failed: Unknown column 'ip' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 2, 2775, 0, 11289870, 'SET_SOCKET', '', '', 72701) errno: 1054)

[.Restince]

#Falsche Section

Gehört hier rein ^_^

[Mijago]

You need to add the Column "IP" to the table log.log.
Look @ Design Table in Navicat, it should help you

[collado]

you use 2011sf?

check this:

[MrFrancisc]

Originally Posted by collado

you use 2011sf?

check this:

Yes ,i use 2011-sf ,but i make this tutorial of you
but give me this error in syserr

SYSERR: Feb  1 08:53:10 :: 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, 53894, 59161, inet_aton('92.80.247.140'), '') errno: 1146)