Jump to content

Log table (errors)


Recommended Posts

Hello, have one problem with table LOG - loginlog2, receive this errors in syserr CH1:

 

When connecting a server GM:

 

ChildLoop: AsyncSQL: query failed: Incorrect integer value: 'Y' for column 'is_gm' at row 1 (query: INSERT INTO loginlog2(type, is_gm, login_time, channel, account_id, pid, ip, client_version) VALUES('INVALID', 'Y', NOW(), 1, 1, 8, inet_aton('79.118.197.139'), '') errno: 1366)
 

 

 

When connecting a server PLAYER:

 

SYSERR: Oct 17 04:03:40 :: ChildLoop: AsyncSQL: query failed: Incorrect integer value: 'N' for column 'is_gm' at row 1 (query: INSERT INTO loginlog2(type, is_gm, login_time, channel, account_id, pid, ip, client_version) VALUES('INVALID', 'N', NOW(), 1, 3, 9, inet_aton('79.118.197.139'), '') errno: 1366)
 

Help me, please !

Link to comment
Share on other sites

Thanks you!
Now I have another errors:

 

Command /i 189

 

SYSERR: Oct 17 13:18:05 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'y' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 1, 71, 4294967291, 10000984, 'SET_ATTR', '', '', 189) errno: 1264)

 

Logout

 

SYSERR: Oct 17 13:32:20 :: ChildLoop: AsyncSQL: query failed: Data truncated for column 'playtime' at row 1 (query: UPDATE loginlog2 SET type='VALID', logout_time=NOW(), playtime=TIMEDIFF(logout_time,login_time) WHERE id=@i errno: 1265)

 

My table, loginlog2:

 

tabel.jpg

 

Is ok?

Edited by Metin2 Dev
Core X - External 2 Internal
Link to comment
Share on other sites

Sorry for double-post, i can't edit.

 

I have one error and done.

 

Command /i 299

 

ChildLoop: AsyncSQL: query failed: Out of range value for column 'y' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 1, 71, 4294967283, 10001020, 'SET_ATTR', '', '', 299) errno: 1264)

 

Help me, please !
 

Link to comment
Share on other sites

Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now

Announcements



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