Jump to content
Forgot your email address? ×
×
×
  • Create New...
  • 0

Log table (errors)


zw0w

Question

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

3 answers to this question

Recommended Posts

  • 0

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 [email protected] errno: 1265)

 

My table, loginlog2:

 

tabel.jpg

 

Is ok?

Link to comment
  • 0

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

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

Announcements

  • -15% Discount in Metin2 Dev Store (01/10/2021 => 31/12/2021) => Code => 15_PCT_OCT_TO_DEC_2021


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.