Jump to content

Recommended Posts

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
Share on other sites

  • Premium
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

 

"Nothing's free in this life.

Ignorant people have an obligation to make up for their ignorance by paying those who help them.

Either you got the brains or cash, if you lack both you're useless."

Syreldar

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.