Hello everyone, I have a problem, two of my friends does not connect to the server, arrive at the character screen, as soon as they click connect, it back of login screen, on their SYSERR there is only this string (which is also present in my SYSERR but with me work all):
I can not understand why but I think it's a client issue, although we have the same with the only difference of ip in root (I with 100 and their have full ip), in each case place the various SYSERR (i never know you can need ).
syserr db:
syserr auth:
syserr ch1:
I can not understand why it does not work, does anyone know help me? thank you and sorry for my so much bad english..
Code:
0403 17:27:14591 :: invalid idx 0
syserr db:
Code:
SYSERR: Apr 3 17:03:18 :: Start: TABLE_POSTFIX not configured use default SYSERR: Apr 3 17:03:18 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'name' in field list is ambiguous query: SELECT pid, name, date FROM monarch_candidacy a, player b where a.pid = b.id SYSERR: Apr 3 17:03:18 :: Load: DirectQuery failed(SELECT IP_FROM, IP_TO, COUNTRY_NAME FROM iptocountry) SYSERR: Apr 3 17:03:20 :: __GetAdminInfo: __GetAdminInfo() ==> DirectQuery failed(SELECT mID,mAccount,mName,mContactIP,mServerIP,mAuthority FROM gmlist WHERE mServerIP='ALL' or mServerIP='25.75.116.100') SYSERR: Apr 3 17:03:21 :: __GetAdminInfo: __GetAdminInfo() ==> DirectQuery failed(SELECT mID,mAccount,mName,mContactIP,mServerIP,mAuthority FROM gmlist WHERE mServerIP='ALL' or mServerIP='25.75.116.100') SYSERR: Apr 3 17:03:32 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down. SYSERR: Apr 3 17:08:21 :: Start: TABLE_POSTFIX not configured use default SYSERR: Apr 3 17:08:22 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'name' in field list is ambiguous query: SELECT pid, name, date FROM monarch_candidacy a, player b where a.pid = b.id SYSERR: Apr 3 17:08:22 :: Load: DirectQuery failed(SELECT IP_FROM, IP_TO, COUNTRY_NAME FROM iptocountry) SYSERR: Apr 3 17:08:23 :: __GetAdminInfo: __GetAdminInfo() ==> DirectQuery failed(SELECT mID,mAccount,mName,mContactIP,mServerIP,mAuthority FROM gmlist WHERE mServerIP='ALL' or mServerIP='25.75.116.100') SYSERR: Apr 3 17:08:25 :: __GetAdminInfo: __GetAdminInfo() ==> DirectQuery failed(SELECT mID,mAccount,mName,mContactIP,mServerIP,mAuthority FROM gmlist WHERE mServerIP='ALL' or mServerIP='25.75.116.100')
Code:
SYSERR: Apr 3 17:03:18 :: socket_connect: HOST 127.0.0.1:16000, could not connect. SYSERR: Apr 3 17:03:21 :: socket_connect: HOST 127.0.0.1:16000, could not connect. SYSERR: Apr 3 17:03:24 :: socket_connect: HOST 127.0.0.1:16000, could not connect. SYSERR: Apr 3 17:03:27 :: socket_connect: HOST 127.0.0.1:16000, could not connect. SYSERR: Apr 3 17:03:30 :: socket_connect: HOST 127.0.0.1:16000, could not connect. SYSERR: Apr 3 17:03:32 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down. SYSERR: Apr 3 17:03:32 :: socket_block: fcntl: nonblock: Bad file descriptor SYSERR: Apr 3 17:08:21 :: socket_connect: HOST 127.0.0.1:15000, could not connect.
Code:
SYSERR: Apr 3 17:20:40 :: 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, 52179, 57723, inet_aton('25.75.116.199'), '') errno: 1146)
SYSERR: Apr 3 17:23:51 :: Process: SEQUENCE 3c0baa00 mismatch 0xaf != 0x0 header 254
SYSERR: Apr 3 17:23:51 :: Process: SEQUENCE_LOG [UNKNOWN]-------------
[254 : 0xaf]
SYSERR: Apr 3 17:24:02 :: ChildLoop: AsyncSQL: query failed: Table 'log.loginlog2' doesn't exist (query: SET @i = (SELECT MAX(id) FROM loginlog2 WHERE account_id=52179 AND pid=57723) errno: 1146)
SYSERR: Apr 3 17:24:02 :: 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)