Jump to content

Log problem

Fliegex3
 Share

Recommended Posts

Fliegex3 Collaborator

Fliegex3 29

Posted
Posted

Hello,

I have some problems with the Log on my Server, some tables are incorrect.

I don't know how I can fix them.

 

Can someone send me correct log tables?

 

Syserr:

 

 

SYSERR: Mar 21 04:12:04.519742 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: 'xFCck' for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 37, 459410, 948889, 10001196, 'SYSTEM', 'Steinstück', '78.49.4.29', 27990) errno: 1366)
SYSERR: Mar 21 04:12:48.999030 :: RunState: LUA_ERROR: [string "tshop"]:47: attempt to call global `say_gold' (a nil value)
SYSERR: Mar 21 04:12:48.999057 :: WriteRunningStateToSyserr: LUA_ERROR: quest tshop.start click
SYSERR: Mar 21 10:11:09.761003 :: 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, 52168, 33, inet_aton('2.245.244.237'), '') errno: 1366)
SYSERR: Mar 21 10:12:08.479271 :: 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(), 33, 350343, 839886, 0, 'WARP', 'PHloX MapIdx 3 DestMapIdx0 DestX474086 DestY954540 Empire1', '2.245.244.237') errno: 1406)
SYSERR: Mar 21 10:12:23.318985 :: Click: CQuestManager::Click(pid=33, target_npc_name=Ereignishelfer) - NOT EXIST NPC RACE VNUM[9004]
SYSERR: Mar 21 10:12:52.41393 :: ChildLoop: AsyncSQL: query failed: Data too long for column 'how' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 33, 476489, 951585, 10001197, 'REMOVE (REFINE SUCCESS)', 'Bambusschwert+7 1 ', '2.245.244.237', 47) errno: 1406)
SYSERR: Mar 21 10:13:00.279490 :: ChildLoop: AsyncSQL: query failed: Data too long for column 'how' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 33, 22, 15, 10001087, 'ADD_ATTRIBUTE_SUCCESS', '10001198', '2.245.244.237', 71085) errno: 1406)
SYSERR: Mar 21 10:13:00.279642 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: 'xE4rken ...' for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 33, 475661, 952844, 87, 'USE_ITEM', 'Gegenstand verstärken 186', '2.245.244.237', 71085) errno: 1366)
SYSERR: Mar 21 10:13:00.679353 :: ChildLoop: AsyncSQL: query failed: Data too long for column 'how' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 33, 15, 5, 10001087, 'ADD_ATTRIBUTE_SUCCESS', '10001198', '2.245.244.237', 71085) errno: 1406)
SYSERR: Mar 21 10:13:00.679490 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: 'xE4rken ...' for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 33, 475360, 953042, 87, 'USE_ITEM', 'Gegenstand verstärken 185', '2.245.244.237', 71085) errno: 1366)
SYSERR: Mar 21 10:13:01.199372 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: 'xE4rken ...' for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 33, 474932, 953225, 87, 'USE_ITEM', 'Gegenstand verstärken 184', '2.245.244.237', 71085) errno: 1366)
SYSERR: Mar 21 10:13:01.519870 :: ChildLoop: AsyncSQL: query failed: Data too long for column 'how' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 33, 16, 5, 10001087, 'ADD_ATTRIBUTE_SUCCESS', '10001198', '2.245.244.237', 71085) errno: 1406)
SYSERR: Mar 21 10:13:01.520010 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: 'xE4rken ...' for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 33, 474650, 953292, 87, 'USE_ITEM', 'Gegenstand verstärken 183', '2.245.244.237', 71085) errno: 1366)
SYSERR: Mar 21 10:13:01.919360 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: 'xE4rken ...' for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 33, 474299, 953371, 87, 'USE_ITEM', 'Gegenstand verstärken 182', '2.245.244.237', 71085) errno: 1366)
SYSERR: Mar 21 10:13:02.359363 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: 'xE4rken ...' for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 33, 473911, 953456, 87, 'USE_ITEM', 'Gegenstand verstärken 181', '2.245.244.237', 71085) errno: 1366)
SYSERR: Mar 21 10:13:03.399369 :: ChildLoop: AsyncSQL: query failed: Data too long for column 'how' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 33, 4, 5, 10001087, 'ADD_ATTRIBUTE_SUCCESS', '10001198', '2.245.244.237', 71085) errno: 1406)
SYSERR: Mar 21 10:13:03.399505 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: 'xE4rken ...' for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 33, 472995, 953652, 87, 'USE_ITEM', 'Gegenstand verstärken 180', '2.245.244.237', 71085) errno: 1366)
SYSERR: Mar 21 10:14:51.319269 :: 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(), 33, 471463, 954694, 0, 'WARP', 'PHloX MapIdx 1 DestMapIdx0 DestX332885 DestY745737 Empire1', '2.245.244.237') errno: 1406)
SYSERR: Mar 21 10:53:50.959218 :: GetServerLocation: location error name  mapindex 0 0 x 0 empire 3
SYSERR: Mar 21 14:35:28.972125 :: 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, 4, 27, inet_aton('158.255.214.38'), '') errno: 1366)
SYSERR: Mar 21 14:37:37.659460 :: 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, 52174, 38, inet_aton('158.255.214.38'), '') errno: 1366)
SYSERR: Mar 21 14:37:47.779583 :: 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, 4, 34, inet_aton('158.255.214.38'), '') errno: 1366)
SYSERR: Mar 21 14:38:41.659385 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: 'xFCrtel+...' for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 38, 958385, 266615, 10000857, 'EXCHANGE_TAKE', 'Prunkvoller Gürtel+9 34 1', '158.255.214.38', 18029) errno: 1366)
SYSERR: Mar 21 14:38:41.659540 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: 'xFCrtel+...' for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 34, 958545, 266784, 10000857, 'EXCHANGE_GIVE', 'Prunkvoller Gürtel+9 38 1', '158.255.214.38', 18029) errno: 1366)
SYSERR: Mar 21 14:38:41.659922 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: 'xE4nenoh...' for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 38, 958385, 266615, 10000843, 'EXCHANGE_TAKE', 'Himmelstränenohrringe+9 34 1', '158.255.214.38', 17209) errno: 1366)
SYSERR: Mar 21 14:38:41.660124 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: 'xE4nenoh...' for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 34, 958545, 266784, 10000843, 'EXCHANGE_GIVE', 'Himmelstränenohrringe+9 38 1', '158.255.214.38', 17209) errno: 1366)
SYSERR: Mar 21 14:38:41.660280 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: 'xE4nenar...' for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 38, 958385, 266615, 10000840, 'EXCHANGE_TAKE', 'Himmelstränenarmband+9 34 1', '158.255.214.38', 14209) errno: 1366)
SYSERR: Mar 21 14:38:41.660452 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: 'xE4nenar...' for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 34, 958545, 266784, 10000840, 'EXCHANGE_GIVE', 'Himmelstränenarmband+9 38 1', '158.255.214.38', 14209) errno: 1366)
SYSERR: Mar 21 14:38:41.660611 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: 'xE4nenha...' for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 38, 958385, 266615, 10000842, 'EXCHANGE_TAKE', 'Himmelstränenhalskette+9 34 1', '158.255.214.38', 16209) errno: 1366)
SYSERR: Mar 21 14:38:41.660786 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: 'xE4nenha...' for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 34, 958545, 266784, 10000842, 'EXCHANGE_GIVE', 'Himmelstränenhalskette+9 38 1', '158.255.214.38', 16209) errno: 1366)
SYSERR: Mar 21 14:38:41.660935 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: 'xF6rnter...' for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 38, 958385, 266615, 10000868, 'EXCHANGE_TAKE', 'Gehörnter Helm +9 34 1', '158.255.214.38', 12539) errno: 1366)
SYSERR: Mar 21 14:38:41.661070 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: 'xF6rnter...' for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 34, 958545, 266784, 10000868, 'EXCHANGE_GIVE', 'Gehörnter Helm +9 38 1', '158.255.214.38', 12539) errno: 1366)
SYSERR: Mar 21 14:38:46.539766 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: 'xF6nixsc...' for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 38, 958403, 266763, 10000841, 'EXCHANGE_TAKE', 'Phönixschuhe+9 34 1', '158.255.214.38', 15209) errno: 1366)
SYSERR: Mar 21 14:38:46.539920 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: 'xF6nixsc...' for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 34, 958545, 266784, 10000841, 'EXCHANGE_GIVE', 'Phönixschuhe+9 38 1', '158.255.214.38', 15209) errno: 1366)
SYSERR: Mar 21 14:39:34.619215 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: 'xF6rnter...' for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 38, 953451, 261209, 10000868, 'SAFEBOX PUT', 'Gehörnter Helm +9 1', '158.255.214.38', 12539) errno: 1366)
SYSERR: Mar 21 14:39:36.139234 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: 'xE4nenha...' for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 38, 953451, 261209, 10000842, 'SAFEBOX PUT', 'Himmelstränenhalskette+9 1', '158.255.214.38', 16209) errno: 1366)
SYSERR: Mar 21 14:39:37.699244 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: 'xF6nixsc...' for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 38, 953451, 261209, 10000841, 'SAFEBOX PUT', 'Phönixschuhe+9 1', '158.255.214.38', 15209) errno: 1366)
SYSERR: Mar 21 14:39:41.139231 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: 'xE4nenar...' for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 38, 953451, 261209, 10000840, 'SAFEBOX PUT', 'Himmelstränenarmband+9 1', '158.255.214.38', 14209) errno: 1366)
SYSERR: Mar 21 14:39:43.859193 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: 'xE4nenoh...' for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 38, 953451, 261209, 10000843, 'SAFEBOX PUT', 'Himmelstränenohrringe+9 1', '158.255.214.38', 17209) errno: 1366)
SYSERR: Mar 21 14:39:45.979390 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: 'xFCrtel+...' for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 38, 953451, 261209, 10000857, 'SAFEBOX PUT', 'Prunkvoller Gürtel+9 1', '158.255.214.38', 18029) errno: 1366)
SYSERR: Mar 21 14:40:42.979334 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: 'xFCndel' for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 34, 959673, 273616, 10001220, 'BUY', 'Bündel', '158.255.214.38', 50200) errno: 1366)
SYSERR: Mar 21 14:40:43.218949 :: Process: SEQUENCE 307d7000 mismatch 0xaf != 0x64 header 254
SYSERR: Mar 21 14:40:43.218969 :: Process: SEQUENCE_LOG [uNKNOWN]-------------
[254 : 0xaf]
Link to comment
Share on other sites
  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Popular Posts

.Devil.
.Devil.

Design Table -> UTF-8 to hint.

Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now
 Share
Go to topic listing

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.