zw0w 3 Posted October 17, 2014 Share Posted October 17, 2014 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 More sharing options...
Honorable Member martysama0134 7180 Posted October 17, 2014 Honorable Member Share Posted October 17, 2014 log.loginlog2 table structure is wrong. Change it like this: type varchar(20) is_gm varchar(1) login_time datetime channel int account_id int pid int ip varchar(15) client_version varchar(11) 1 2 Check out my GitHub Link to comment Share on other sites More sharing options...
zw0w 3 Posted October 17, 2014 Author Share Posted October 17, 2014 (edited) 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: Is ok? Edited August 23, 2022 by Metin2 Dev Core X - External 2 Internal Link to comment Share on other sites More sharing options...
zw0w 3 Posted October 17, 2014 Author Share Posted October 17, 2014 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 More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now