Jump to content
×
×
  • Create New...
  • 0

syser ch1 error


servan12

Question

SYSERR: Oct 15 04:23:08 :: ChildLoop: AsyncSQL: query failed: Data too long for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 2889, 968161, 277292, 0, 'LOGIN', '192.168.1.102 916271162 1 41 5685', '192.168.1.102') errno: 1406)
SYSERR: Oct 15 04:23:08 :: 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, 2889, inet_aton('192.168.1.102'), '') errno: 1366)
SYSERR: Oct 15 04:23:55 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xFCresi' for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 2889, 967962, 276338, 10000744, 'BUY', 'Kutsama Küresi', '192.168.1.102', 70024) errno: 1366)
SYSERR: Oct 15 04:23:55 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xFCresi' for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 2889, 967962, 276338, 10000745, 'BUY', 'Kutsama Küresi', '192.168.1.102', 70024) errno: 1366)
SYSERR: Oct 15 04:23:55 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xFCresi' for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 2889, 967962, 276338, 10000746, 'BUY', 'Kutsama Küresi', '192.168.1.102', 70024) errno: 1366)
SYSERR: Oct 15 04:26:25 :: ChildLoop: AsyncSQL: query failed: Data too long for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 2889, 967962, 276338, 0, 'LOGOUT', '192.168.1.102 915971361 1 41 5700', '192.168.1.102') errno: 1406)

 

Link to comment

2 answers to this question

Recommended Posts

  • 2
On 15/10/2016 at 3:04 PM, servan12 said:

SYSERR: Oct 15 04:26:25 :: ChildLoop: AsyncSQL: query failed: Data too long for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 2889, 967962, 276338, 0, 'LOGOUT', '192.168.1.102 915971361 1 41 5700', '192.168.1.102') errno: 1406)

log -> design table -> increase the hint column's length till the error disappears.

On 15/10/2016 at 3:04 PM, servan12 said:

SYSERR: Oct 15 04:23:08 :: 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, 2889, inet_aton('192.168.1.102'), '') errno: 1366)

loginlog2 -> design table -> is_gm -> from integer to varchar.

On 15/10/2016 at 3:04 PM, servan12 said:

SYSERR: Oct 15 04:23:55 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xFCresi' for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 2889, 967962, 276338, 10000745, 'BUY', 'Kutsama Küresi', '192.168.1.102', 70024) errno: 1366)

log -> design table -> set the hint column's charset to UTF-8.

  • Love 3

👑 Premium International Lua Developer 👑

 My service topic: https://bit.ly/2UPly54

 

Ignorant people have the obligation to compensate their ignorance by paying whoever helps them.

Syreldar

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.