Adatbázis probléma nem ment le semmit csak kari cucait

Indította Word, 2017-08-15, 11:26:49

Nyomtatás
Le Oldalak1
Felhasználói műveletek
2017-08-15, 11:26:49 Utolsó szerkesztés: 2017-08-15, 11:58:15 Szerző: Word
sziasztok hol lehetne ki deriteni hogy mi lehet a gond az adatbázisal hogy kari cucait menti csak le de ha le szintelem adok neki yangot exp-t skillek is 0 lásak akkor miért nem menti le ha  szabályosan le van kapcsolva a szerver?  ha pld 5km arréb kerül a karakter akkor is vissza kerül oda ahol volt syserr nem ír rá  semmit és nagyon idegesítő ez a fajta bugg vagy mi is lenne.

ennyit ír ki syserrbe

Kód Kijelölés
SYSERR: Aug 15 11:53:08.49296 :: pid_init:
Start of pid: 2466

SYSERR: Aug 15 11:53:23.164782 :: Show: cannot find sectree by 984013x273270 mapindex 41
SYSERR: Aug 15 11:53:34.520879 :: ChildLoop: AsyncSQL: query failed: Incorrect integer value: '' for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 68650, 571594, 761662, 5, 'GM_LOGIN', '', '86.101.16.128') errno: 1366)
SYSERR: Aug 15 11:53:34.521146 :: ChildLoop: AsyncSQL: query failed: Data truncated for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 68650, 571594, 761662, 0, 'LOGIN', '86.101.16.128 1999742563 0 1 30', '86.101.16.128') errno: 1265)
SYSERR: Aug 15 11:53:34.521491 :: 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, 68650, inet_aton('86.101.16.128'), '') errno: 1366)


ez le álitás uttán adta ki mikkor cuc nélküli max szintes karakter lett újra
2017-08-15, 12:01:31 #1
Forrás hiba lesz, pl Costume weaponba elvan szúrva a makró, ha makróval teszed be akkor kb ezt csinálja.
Természetesen máshol is lehet a hiba ha neked az nincs bent, vagy makró nélkül van bent.
Remélem vannak mentéseid...
2017-08-15, 12:03:20 #2 Utolsó szerkesztés: 2017-08-15, 15:23:00 Szerző: Word
utoljára a pánt rendszer került be ha számít valamit de nem tudom pontosan mióta van ez a hiba most vetem csak észre
Üzenet összefésülés: 2017-08-15, 15:19:46

ch1 syserr.txt

ATAG küldöt log táblákat de hát még így sem jó sajna mentés lvl4 es karit kaptam másik mappra tet vissza nem is ott marat a karakterem ahol hagytam 20k és lvl8 helyet lvl4 es 5k kp val és 1 skillel holot már 8 as volt a kari

ezeket firkálja a syserrbe ch1 nél

Kód Kijelölés
SYSERR: Aug 15 14:55:32.433666 :: pid_init:
Start of pid: 1276

SYSERR: Aug 15 14:55:42.885527 :: Show: cannot find sectree by 984013x273270 mapindex 41
SYSERR: Aug 15 14:55:51.811372 :: 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(), 68698, 550900, 784000, 0, 'LOGIN', '86.101.17.74 5011 0 1 30', '86.101.17.74') errno: 1406)
SYSERR: Aug 15 14:55:51.811674 :: 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, 68698, inet_aton('86.101.17.74'), '') errno: 1366)
SYSERR: Aug 15 15:01:12.451824 :: 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(), 68698, 550900, 784000, 0, 'LOGOUT', '86.101.17.74 5011 1 30 0', '86.101.17.74') errno: 1406)
SYSERR: Aug 15 15:04:24.251642 :: 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(), 68698, 550900, 784000, 0, 'LOGIN', '86.101.17.74 5011 0 1 30', '86.101.17.74') errno: 1406)
SYSERR: Aug 15 15:04:24.251890 :: 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, 68698, inet_aton('86.101.17.74'), '') errno: 1366)
SYSERR: Aug 15 15:04:58.251430 :: 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(), 68698, 539780, 791268, 0, 'WARP', 'teszt MapIdx 30 DestMapIdx0 DestX391100 DestY391300 Empire3', '86.101.17.74') errno: 1406)
SYSERR: Aug 15 15:04:58.331456 :: 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(), 68698, 539780, 791268, 0, 'LOGOUT', '86.101.17.74 5011 1 30 0', '86.101.17.74') errno: 1406)
SYSERR: Aug 15 15:04:59.883133 :: 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(), 68698, 391100, 391300, 0, 'LOGIN', '86.101.17.74 5011 0 1 31', '86.101.17.74') errno: 1406)
SYSERR: Aug 15 15:05:49.82848 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xE9kfark...' for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 68698, 399126, 396261, 104, 'DEAD_BY_NPC', 'Kékfarkas', '86.101.17.74') errno: 1366)
SYSERR: Aug 15 15:06:23.3509 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xFAr ruh...' for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 68698, 398735, 395297, 10021341, 'GET', 'azúr ruha+2 1 11402', '86.101.17.74', 11402) errno: 1366)
SYSERR: Aug 15 15:06:24.323517 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xE9rt+3 ...' for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 68698, 398735, 395297, 10021342, 'GET', 'Szerzetes Lemezvért+3 1 11203', '86.101.17.74', 11203) errno: 1366)
SYSERR: Aug 15 15:06:45.283497 :: 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(), 68698, 390641, 390790, 0, 'WARP', 'teszt MapIdx 31 DestMapIdx0 DestX550900 DestY784000 Empire3', '86.101.17.74') errno: 1406)
SYSERR: Aug 15 15:06:45.363074 :: 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(), 68698, 390641, 390790, 0, 'LOGOUT', '86.101.17.74 7878 1 31 207', '86.101.17.74') errno: 1406)
SYSERR: Aug 15 15:06:46.758346 :: 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(), 68698, 550900, 784000, 0, 'LOGIN', '86.101.17.74 7878 0 1 30', '86.101.17.74') errno: 1406)
SYSERR: Aug 15 15:07:09.558291 :: 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(), 68698, 545249, 773526, 0, 'CLEAR_SKILL', 'Fertigkeit nach Fertigkeitsmeister löschen', '86.101.17.74') errno: 1406)
SYSERR: Aug 15 15:07:12.998380 :: 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(), 68698, 545781, 774291, 63, 'SKILLUP', 'SkillUp: teszt 63 0 1[Before:0] type 3', '86.101.17.74') errno: 1406)
SYSERR: Aug 15 15:07:13.236904 :: 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(), 68698, 545897, 774434, 63, 'SKILLUP', 'SkillUp: teszt 63 0 2[Before:1] type 3', '86.101.17.74') errno: 1406)
SYSERR: Aug 15 15:07:13.438368 :: 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(), 68698, 546065, 774642, 63, 'SKILLUP', 'SkillUp: teszt 63 0 3[Before:2] type 3', '86.101.17.74') errno: 1406)
SYSERR: Aug 15 15:07:13.518355 :: 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(), 68698, 546065, 774642, 63, 'SKILLUP', 'SkillUp: teszt 63 0 4[Before:3] type 3', '86.101.17.74') errno: 1406)
SYSERR: Aug 15 15:07:13.718288 :: 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(), 68698, 546124, 774715, 63, 'SKILLUP', 'SkillUp: teszt 63 0 5[Before:4] type 3', '86.101.17.74') errno: 1406)
SYSERR: Aug 15 15:07:45.276792 :: 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(), 68698, 539926, 791221, 0, 'WARP', 'teszt MapIdx 30 DestMapIdx0 DestX391100 DestY391300 Empire3', '86.101.17.74') errno: 1406)
SYSERR: Aug 15 15:07:45.358161 :: 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(), 68698, 539926, 791221, 0, 'LOGOUT', '86.101.17.74 7878 1 30 207', '86.101.17.74') errno: 1406)
SYSERR: Aug 15 15:07:46.712258 :: 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(), 68698, 391100, 391300, 0, 'LOGIN', '86.101.17.74 7878 0 1 31', '86.101.17.74') errno: 1406)
SYSERR: Aug 15 15:08:09.872210 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xE9rt+2 ...' for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 68698, 394504, 393577, 10021343, 'GET', 'Requiem Lemezvért+2 1 11602', '86.101.17.74', 11602) errno: 1366)
SYSERR: Aug 15 15:09:16.311320 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xE9kfark...' for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 68698, 397481, 395702, 104, 'DEAD_BY_NPC', 'Kékfarkas', '86.101.17.74') errno: 1366)
SYSERR: Aug 15 15:09:29.994391 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xE9rt+2 ...' for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 68698, 397481, 395702, 10021344, 'GET', 'Requiem Lemezvért+2 1 11602', '86.101.17.74', 11602) errno: 1366)
SYSERR: Aug 15 15:09:43.754011 :: 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(), 68698, 397481, 395702, 63, 'SKILLUP', 'SkillUp: teszt 63 0 6[Before:5] type 3', '86.101.17.74') errno: 1406)
SYSERR: Aug 15 15:10:02.633980 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xF5r+3 1...' for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 68698, 397420, 395738, 10021345, 'GET', 'Tőr+3 1 1003', '86.101.17.74', 1003) errno: 1366)
SYSERR: Aug 15 15:10:13.671725 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xC9hes a...' for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 68698, 397402, 395750, 177, 'DEAD_BY_NPC', 'Éhes alfa szürkefarkas', '86.101.17.74') errno: 1366)
SYSERR: Aug 15 15:10:38.234034 :: 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(), 68698, 399107, 397491, 63, 'SKILLUP', 'SkillUp: teszt 63 0 7[Before:6] type 3', '86.101.17.74') errno: 1406)
SYSERR: Aug 15 15:10:50.473932 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xC9hes v...' for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 68698, 399077, 397117, 171, 'DEAD_BY_NPC', 'Éhes vad kutya', '86.101.17.74') errno: 1366)
SYSERR: Aug 15 15:10:59.354612 :: 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(), 68698, 399077, 397117, 0, 'LOGOUT', '86.101.17.74 12570 1 31 442', '86.101.17.74') errno: 1406)
SYSERR: Aug 15 15:11:05.667785 :: 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(), 68698, 399077, 397117, 0, 'LOGIN', '86.101.17.74 12570 0 1 31', '86.101.17.74') errno: 1406)
SYSERR: Aug 15 15:11:05.668079 :: 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, 68698, inet_aton('86.101.17.74'), '') errno: 1366)
SYSERR: Aug 15 15:11:20.629679 :: 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(), 68698, 399077, 397117, 0, 'LOGOUT', '86.101.17.74 12570 1 31 442', '86.101.17.74') errno: 1406)
SYSERR: Aug 15 15:12:08.806968 :: 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(), 68650, 571594, 761662, 0, 'LOGIN', '86.101.17.74 1999742563 0 1 30', '86.101.17.74') errno: 1406)
SYSERR: Aug 15 15:12:08.807227 :: 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, 68650, inet_aton('86.101.17.74'), '') errno: 1366)
SYSERR: Aug 15 15:12:41.128947 :: 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(), 68650, 571594, 761662, 0, 'LOGOUT', '86.101.17.74 1999742563 1 30 200000', '86.101.17.74') errno: 1406)
SYSERR: Aug 15 15:13:18.502771 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Aug 15 15:13:19.119526 :: ForAttrRegion: Cannot find SECTREE_MAP by map index 41
SYSERR: Aug 15 15:13:19.168190 :: pid_deinit:
End of pid

SYSERR: Aug 15 15:13:37.462636 :: pid_init:
Start of pid: 1393

SYSERR: Aug 15 15:13:49.140112 :: Show: cannot find sectree by 984013x273270 mapindex 41
SYSERR: Aug 15 15:14:16.780805 :: 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(), 68698, 550900, 784000, 0, 'LOGIN', '86.101.17.74 5011 0 1 30', '86.101.17.74') errno: 1406)
SYSERR: Aug 15 15:14:16.781135 :: 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, 68698, inet_aton('86.101.17.74'), '') errno: 1366)


core1 (ch1)

Kód Kijelölés
SYSERR: Aug 15 14:55:34.438271 :: pid_init:
Start of pid: 1279

SYSERR: Aug 15 14:55:45.154067 :: Show: cannot find sectree by 984013x273270 mapindex 41
SYSERR: Aug 15 15:12:22.131376 :: Analyze: Accept shutdown p2p command from 87.229.71.55.
SYSERR: Aug 15 15:13:18.503165 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Aug 15 15:13:19.106354 :: ForAttrRegion: Cannot find SECTREE_MAP by map index 41
SYSERR: Aug 15 15:13:19.156131 :: pid_deinit:
End of pid

SYSERR: Aug 15 15:13:39.474246 :: pid_init:
Start of pid: 1396

SYSERR: Aug 15 15:13:50.83066 :: Show: cannot find sectree by 984013x273270 mapindex 41


db syserr.txt

Kód Kijelölés
SYSERR: Aug 15 14:55:28.388262 :: pid_init:
Start of pid: 1270

SYSERR: Aug 15 15:05:55.376048 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'horse_riding' at row 1 (query: UPDATE player  SET job = 6, voice = 0, dir = 0, x = 396639, y = 395060, z = 0, map_index = 31, exit_x = 396639, exit_y = 395060, exit_map_index = 31, hp = 1552, mp = 1362, stamina = 770, random_hp = 200, random_sp = 92, playtime = 10, level = 5, level_step = 2, st = 5, ht = 6, dx = 5, iq = 29, gold = 7567, exp = 0, stat_point = 45, skill_point = 2, sub_skill_point = 0, stat_reset_count = 0, ip = '(null)', part_main = 682559521, part_hair = 11601, part_sash = 11601, last_play = NOW(), skill_group = 0, alignment = 0, horse_level = 160, horse_riding = 195, horse_hp = 0, horse_hp_droptime = 0, horse_stamina = 0, horse_skill_point = 0, skill_level = '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0
SYSERR: Aug 15 15:12:56.370226 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'horse_level' at row 1 (query: UPDATE player  SET job = 6, voice = 0, dir = 0, x = 399077, y = 397117, z = 0, map_index = 31, exit_x = 399077, exit_y = 397117, exit_map_index = 31, hp = 2042, mp = 1613, stamina = 855, random_hp = 342, random_sp = 163, playtime = 14, level = 8, level_step = 2, st = 5, ht = 11, dx = 5, iq = 35, gold = 12570, exp = 0, stat_point = 62, skill_point = 0, sub_skill_point = 0, stat_reset_count = 0, ip = '(null)', part_main = 682559521, part_hair = 11602, part_sash = 11601, last_play = NOW(), skill_group = 0, alignment = 1, horse_level = 442, horse_riding = 195, horse_hp = 0, horse_hp_droptime = 0, horse_stamina = 0, horse_skill_point = 0, skill_level = '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0
SYSERR: Aug 15 15:13:18.763796 :: Process: FDWATCH: peer null in event: ident 23
SYSERR: Aug 15 15:13:18.763816 :: Process: FDWATCH: peer null in event: ident 20
SYSERR: Aug 15 15:13:19.175553 :: Process: FDWATCH: peer null in event: ident 22
SYSERR: Aug 15 15:13:19.194622 :: Process: FDWATCH: peer null in event: ident 21
SYSERR: Aug 15 15:13:22.549876 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Aug 15 15:13:22.550741 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'horse_level' at row 1 (query: UPDATE player  SET job = 0, voice = 0, dir = 0, x = 571594, y = 761662, z = 0, map_index = 30, exit_x = 571594, exit_y = 761662, exit_map_index = 30, hp = 15411, mp = 6268, stamina = 1380, random_hp = 9711, random_sp = 5478, playtime = 2200, level = 105, level_step = 0, st = 90, ht = 90, dx = 90, iq = 13, gold = 1999742563, exp = 0, stat_point = 0, skill_point = 0, sub_skill_point = 16, stat_reset_count = 96, ip = '(null)', part_main = 702879777, part_hair = 0, part_sash = 0, last_play = NOW(), skill_group = 0, alignment = 1, horse_level = 200000, horse_riding = 21, horse_hp = 0, horse_hp_droptime = 0, horse_stamina = 1414634920, horse_skill_point = 120, skill_level = '\0\0\0\0\0\0(\0\0\0\0(\0\0\0\0(\0\0\0\0(\0\0\0\0(\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\
SYSERR: Aug 15 15:13:22.555857 :: pid_deinit:
End of pid

SYSERR: Aug 15 15:13:33.426139 :: pid_init:
Start of pid: 1387



auth syserr.txt

Kód Kijelölés
SYSERR: Aug 15 14:55:30.425647 :: pid_init:
Start of pid: 1273

SYSERR: Aug 15 15:13:18.503373 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Aug 15 15:13:18.759517 :: pid_deinit:
End of pid

SYSERR: Aug 15 15:13:35.462128 :: pid_init:
Start of pid: 1390



game99 syserr.txt

Kód Kijelölés
SYSERR: Aug 15 14:55:36.444584 :: pid_init:
Start of pid: 1282

SYSERR: Aug 15 14:55:45.766276 :: Show: cannot find sectree by 984013x273270 mapindex 41
SYSERR: Aug 15 15:12:22.137829 :: Analyze: Accept shutdown p2p command from 87.229.71.55.
SYSERR: Aug 15 15:13:18.502687 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Aug 15 15:13:18.767314 :: ForAttrRegion: Cannot find SECTREE_MAP by map index 41
SYSERR: Aug 15 15:13:18.802438 :: pid_deinit:
End of pid

SYSERR: Aug 15 15:13:41.476620 :: pid_init:
Start of pid: 1399

SYSERR: Aug 15 15:13:50.168437 :: Show: cannot find sectree by 984013x273270 mapindex 41


nem tudom pánt kavar e be vagy sem de már nagyon idegesítő ez a hiba hogy nem ment le semmit

vagy ép lvl4 karit skillek nélkül kapom meg de már nagyon idegesítő egy hiba hogy semmit nem képes le menteni :(

persze kari cucait le menti úgy ahogy persze amit idáig fel szedet az ember azok el tűntek

mielőtt valaki írja hogy nem jól van le kapcsolva a szerver pedig rendesen szabályosan le van kapcsolva tehát ez nem lehet probléma!
2017-08-15, 21:57:41 #3
up
2017-08-16, 07:00:52 #4
Esetlegesen erre:

Kód Kijelölés
Data too long for column 'hint' at row

Túl hosszú ha a log log táblába a design table résznél a hint értékét 20-ról megnöveled pl 40-50 akkor elviekben ez megszűnik.
Kód Kijelölés

SYSERR: Aug 15 15:13:18.763796 :: Process: FDWATCH: peer null in event: ident 23
SYSERR: Aug 15 15:13:18.763816 :: Process: FDWATCH: peer null in event: ident 20
SYSERR: Aug 15 15:13:19.175553 :: Process: FDWATCH: peer null in event: ident 22
SYSERR: Aug 15 15:13:19.194622 :: Process: FDWATCH: peer null in event: ident 21

95% -ban biztos hogy ezek a syserek az item_proto hibájára hivatkoznak. Valószínüleg a protoreader.cpp nem a legszebb egy alappal próbáld már meg és protot is cserélj. Nekem anno akkor jött ez elő mikor még nem akartam át szokni txt protokra és akkor a sql querrykben lévő ékezetek elválasztó elemek nem tetszettek neki.
Kód Kijelölés

bool SECTREE_MANAGER::GetValidLocation(long lMapIndex, long x, long y, long & r_lValidMapIndex, PIXEL_POSITION & r_pos, BYTE empire)


Ebben a fügvényben lévőő syser ami neked is jön
Kód Kijelölés
[code] sys_err("cannot find sectree_map by map index %d", lMapIndex);
[/code] Nekem ez kicserélt mapoknál jött mikor is a játékos olyan területre ment ami elviekben nem érhető el illetve map össze éréskor.
2017-08-16, 13:39:57 #5 Utolsó szerkesztés: 2017-08-16, 13:54:00 Szerző: Word
esetleg  egy tip hogy tudnám ezeket orvosolni?


ch1 új syserr.txt je

Kód Kijelölés
SYSERR: Aug 15 14:55:32.433666 :: pid_init:
Start of pid: 1276

SYSERR: Aug 15 14:55:42.885527 :: Show: cannot find sectree by 984013x273270 mapindex 41
SYSERR: Aug 15 14:55:51.811372 :: 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(), 68698, 550900, 784000, 0, 'LOGIN', '86.101.17.74 5011 0 1 30', '86.101.17.74') errno: 1406)
SYSERR: Aug 15 14:55:51.811674 :: 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, 68698, inet_aton('86.101.17.74'), '') errno: 1366)
SYSERR: Aug 15 15:01:12.451824 :: 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(), 68698, 550900, 784000, 0, 'LOGOUT', '86.101.17.74 5011 1 30 0', '86.101.17.74') errno: 1406)
SYSERR: Aug 15 15:04:24.251642 :: 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(), 68698, 550900, 784000, 0, 'LOGIN', '86.101.17.74 5011 0 1 30', '86.101.17.74') errno: 1406)
SYSERR: Aug 15 15:04:24.251890 :: 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, 68698, inet_aton('86.101.17.74'), '') errno: 1366)
SYSERR: Aug 15 15:04:58.251430 :: 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(), 68698, 539780, 791268, 0, 'WARP', 'teszt MapIdx 30 DestMapIdx0 DestX391100 DestY391300 Empire3', '86.101.17.74') errno: 1406)
SYSERR: Aug 15 15:04:58.331456 :: 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(), 68698, 539780, 791268, 0, 'LOGOUT', '86.101.17.74 5011 1 30 0', '86.101.17.74') errno: 1406)
SYSERR: Aug 15 15:04:59.883133 :: 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(), 68698, 391100, 391300, 0, 'LOGIN', '86.101.17.74 5011 0 1 31', '86.101.17.74') errno: 1406)
SYSERR: Aug 15 15:05:49.82848 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xE9kfark...' for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 68698, 399126, 396261, 104, 'DEAD_BY_NPC', 'Kékfarkas', '86.101.17.74') errno: 1366)
SYSERR: Aug 15 15:06:23.3509 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xFAr ruh...' for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 68698, 398735, 395297, 10021341, 'GET', 'azúr ruha+2 1 11402', '86.101.17.74', 11402) errno: 1366)
SYSERR: Aug 15 15:06:24.323517 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xE9rt+3 ...' for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 68698, 398735, 395297, 10021342, 'GET', 'Szerzetes Lemezvért+3 1 11203', '86.101.17.74', 11203) errno: 1366)
SYSERR: Aug 15 15:06:45.283497 :: 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(), 68698, 390641, 390790, 0, 'WARP', 'teszt MapIdx 31 DestMapIdx0 DestX550900 DestY784000 Empire3', '86.101.17.74') errno: 1406)
SYSERR: Aug 15 15:06:45.363074 :: 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(), 68698, 390641, 390790, 0, 'LOGOUT', '86.101.17.74 7878 1 31 207', '86.101.17.74') errno: 1406)
SYSERR: Aug 15 15:06:46.758346 :: 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(), 68698, 550900, 784000, 0, 'LOGIN', '86.101.17.74 7878 0 1 30', '86.101.17.74') errno: 1406)
SYSERR: Aug 15 15:07:09.558291 :: 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(), 68698, 545249, 773526, 0, 'CLEAR_SKILL', 'Fertigkeit nach Fertigkeitsmeister löschen', '86.101.17.74') errno: 1406)
SYSERR: Aug 15 15:07:12.998380 :: 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(), 68698, 545781, 774291, 63, 'SKILLUP', 'SkillUp: teszt 63 0 1[Before:0] type 3', '86.101.17.74') errno: 1406)
SYSERR: Aug 15 15:07:13.236904 :: 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(), 68698, 545897, 774434, 63, 'SKILLUP', 'SkillUp: teszt 63 0 2[Before:1] type 3', '86.101.17.74') errno: 1406)
SYSERR: Aug 15 15:07:13.438368 :: 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(), 68698, 546065, 774642, 63, 'SKILLUP', 'SkillUp: teszt 63 0 3[Before:2] type 3', '86.101.17.74') errno: 1406)
SYSERR: Aug 15 15:07:13.518355 :: 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(), 68698, 546065, 774642, 63, 'SKILLUP', 'SkillUp: teszt 63 0 4[Before:3] type 3', '86.101.17.74') errno: 1406)
SYSERR: Aug 15 15:07:13.718288 :: 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(), 68698, 546124, 774715, 63, 'SKILLUP', 'SkillUp: teszt 63 0 5[Before:4] type 3', '86.101.17.74') errno: 1406)
SYSERR: Aug 15 15:07:45.276792 :: 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(), 68698, 539926, 791221, 0, 'WARP', 'teszt MapIdx 30 DestMapIdx0 DestX391100 DestY391300 Empire3', '86.101.17.74') errno: 1406)
SYSERR: Aug 15 15:07:45.358161 :: 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(), 68698, 539926, 791221, 0, 'LOGOUT', '86.101.17.74 7878 1 30 207', '86.101.17.74') errno: 1406)
SYSERR: Aug 15 15:07:46.712258 :: 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(), 68698, 391100, 391300, 0, 'LOGIN', '86.101.17.74 7878 0 1 31', '86.101.17.74') errno: 1406)
SYSERR: Aug 15 15:08:09.872210 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xE9rt+2 ...' for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 68698, 394504, 393577, 10021343, 'GET', 'Requiem Lemezvért+2 1 11602', '86.101.17.74', 11602) errno: 1366)
SYSERR: Aug 15 15:09:16.311320 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xE9kfark...' for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 68698, 397481, 395702, 104, 'DEAD_BY_NPC', 'Kékfarkas', '86.101.17.74') errno: 1366)
SYSERR: Aug 15 15:09:29.994391 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xE9rt+2 ...' for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 68698, 397481, 395702, 10021344, 'GET', 'Requiem Lemezvért+2 1 11602', '86.101.17.74', 11602) errno: 1366)
SYSERR: Aug 15 15:09:43.754011 :: 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(), 68698, 397481, 395702, 63, 'SKILLUP', 'SkillUp: teszt 63 0 6[Before:5] type 3', '86.101.17.74') errno: 1406)
SYSERR: Aug 15 15:10:02.633980 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xF5r+3 1...' for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 68698, 397420, 395738, 10021345, 'GET', 'Tőr+3 1 1003', '86.101.17.74', 1003) errno: 1366)
SYSERR: Aug 15 15:10:13.671725 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xC9hes a...' for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 68698, 397402, 395750, 177, 'DEAD_BY_NPC', 'Éhes alfa szürkefarkas', '86.101.17.74') errno: 1366)
SYSERR: Aug 15 15:10:38.234034 :: 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(), 68698, 399107, 397491, 63, 'SKILLUP', 'SkillUp: teszt 63 0 7[Before:6] type 3', '86.101.17.74') errno: 1406)
SYSERR: Aug 15 15:10:50.473932 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xC9hes v...' for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 68698, 399077, 397117, 171, 'DEAD_BY_NPC', 'Éhes vad kutya', '86.101.17.74') errno: 1366)
SYSERR: Aug 15 15:10:59.354612 :: 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(), 68698, 399077, 397117, 0, 'LOGOUT', '86.101.17.74 12570 1 31 442', '86.101.17.74') errno: 1406)
SYSERR: Aug 15 15:11:05.667785 :: 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(), 68698, 399077, 397117, 0, 'LOGIN', '86.101.17.74 12570 0 1 31', '86.101.17.74') errno: 1406)
SYSERR: Aug 15 15:11:05.668079 :: 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, 68698, inet_aton('86.101.17.74'), '') errno: 1366)
SYSERR: Aug 15 15:11:20.629679 :: 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(), 68698, 399077, 397117, 0, 'LOGOUT', '86.101.17.74 12570 1 31 442', '86.101.17.74') errno: 1406)
SYSERR: Aug 15 15:12:08.806968 :: 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(), 68650, 571594, 761662, 0, 'LOGIN', '86.101.17.74 1999742563 0 1 30', '86.101.17.74') errno: 1406)
SYSERR: Aug 15 15:12:08.807227 :: 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, 68650, inet_aton('86.101.17.74'), '') errno: 1366)
SYSERR: Aug 15 15:12:41.128947 :: 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(), 68650, 571594, 761662, 0, 'LOGOUT', '86.101.17.74 1999742563 1 30 200000', '86.101.17.74') errno: 1406)
SYSERR: Aug 15 15:13:18.502771 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Aug 15 15:13:19.119526 :: ForAttrRegion: Cannot find SECTREE_MAP by map index 41
SYSERR: Aug 15 15:13:19.168190 :: pid_deinit:
End of pid

SYSERR: Aug 15 15:13:37.462636 :: pid_init:
Start of pid: 1393

SYSERR: Aug 15 15:13:49.140112 :: Show: cannot find sectree by 984013x273270 mapindex 41
SYSERR: Aug 15 15:14:16.780805 :: 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(), 68698, 550900, 784000, 0, 'LOGIN', '86.101.17.74 5011 0 1 30', '86.101.17.74') errno: 1406)
SYSERR: Aug 15 15:14:16.781135 :: 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, 68698, inet_aton('86.101.17.74'), '') errno: 1366)
SYSERR: Aug 15 15:20:07.822390 :: 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(), 68698, 550900, 784000, 0, 'LOGOUT', '86.101.17.74 5011 1 30 0', '86.101.17.74') errno: 1406)



db syserr.txt je igen sok a 0 la benne

Kód Kijelölés
SYSERR: Aug 15 14:55:28.388262 :: pid_init:
Start of pid: 1270

SYSERR: Aug 15 15:05:55.376048 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'horse_riding' at row 1 (query: UPDATE player  SET job = 6, voice = 0, dir = 0, x = 396639, y = 395060, z = 0, map_index = 31, exit_x = 396639, exit_y = 395060, exit_map_index = 31, hp = 1552, mp = 1362, stamina = 770, random_hp = 200, random_sp = 92, playtime = 10, level = 5, level_step = 2, st = 5, ht = 6, dx = 5, iq = 29, gold = 7567, exp = 0, stat_point = 45, skill_point = 2, sub_skill_point = 0, stat_reset_count = 0, ip = '(null)', part_main = 682559521, part_hair = 11601, part_sash = 11601, last_play = NOW(), skill_group = 0, alignment = 0, horse_level = 160, horse_riding = 195, horse_hp = 0, horse_hp_droptime = 0, horse_stamina = 0, horse_skill_point = 0, skill_level = '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0
SYSERR: Aug 15 15:12:56.370226 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'horse_level' at row 1 (query: UPDATE player  SET job = 6, voice = 0, dir = 0, x = 399077, y = 397117, z = 0, map_index = 31, exit_x = 399077, exit_y = 397117, exit_map_index = 31, hp = 2042, mp = 1613, stamina = 855, random_hp = 342, random_sp = 163, playtime = 14, level = 8, level_step = 2, st = 5, ht = 11, dx = 5, iq = 35, gold = 12570, exp = 0, stat_point = 62, skill_point = 0, sub_skill_point = 0, stat_reset_count = 0, ip = '(null)', part_main = 682559521, part_hair = 11602, part_sash = 11601, last_play = NOW(), skill_group = 0, alignment = 1, horse_level = 442, horse_riding = 195, horse_hp = 0, horse_hp_droptime = 0, horse_stamina = 0, horse_skill_point = 0, skill_level = '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0
SYSERR: Aug 15 15:13:18.763796 :: Process: FDWATCH: peer null in event: ident 23
SYSERR: Aug 15 15:13:18.763816 :: Process: FDWATCH: peer null in event: ident 20
SYSERR: Aug 15 15:13:19.175553 :: Process: FDWATCH: peer null in event: ident 22
SYSERR: Aug 15 15:13:19.194622 :: Process: FDWATCH: peer null in event: ident 21
SYSERR: Aug 15 15:13:22.549876 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Aug 15 15:13:22.550741 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'horse_level' at row 1 (query: UPDATE player  SET job = 0, voice = 0, dir = 0, x = 571594, y = 761662, z = 0, map_index = 30, exit_x = 571594, exit_y = 761662, exit_map_index = 30, hp = 15411, mp = 6268, stamina = 1380, random_hp = 9711, random_sp = 5478, playtime = 2200, level = 105, level_step = 0, st = 90, ht = 90, dx = 90, iq = 13, gold = 1999742563, exp = 0, stat_point = 0, skill_point = 0, sub_skill_point = 16, stat_reset_count = 96, ip = '(null)', part_main = 702879777, part_hair = 0, part_sash = 0, last_play = NOW(), skill_group = 0, alignment = 1, horse_level = 200000, horse_riding = 21, horse_hp = 0, horse_hp_droptime = 0, horse_stamina = 1414634920, horse_skill_point = 120, skill_level = '\0\0\0\0\0\0(\0\0\0\0(\0\0\0\0(\0\0\0\0(\0\0\0\0(\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\
SYSERR: Aug 15 15:13:22.555857 :: pid_deinit:
End of pid

SYSERR: Aug 15 15:13:33.426139 :: pid_init:
Start of pid: 1387

SYSERR: Aug 15 15:24:21.416446 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'horse_riding' at row 1 (query: UPDATE player  SET job = 6, voice = 0, dir = 0, x = 550900, y = 784000, z = 0, map_index = 30, exit_x = 550900, exit_y = 784000, exit_map_index = 30, hp = 1598, mp = 1037, stamina = 830, random_hp = 148, random_sp = 67, playtime = 10, level = 4, level_step = 0, st = 5, ht = 6, dx = 5, iq = 19, gold = 5011, exp = 0, stat_point = 0, skill_point = 7, sub_skill_point = 0, stat_reset_count = 0, ip = '(null)', part_main = 682481697, part_hair = 11602, part_sash = 11601, last_play = NOW(), skill_group = 0, alignment = 0, horse_level = 0, horse_riding = 195, horse_hp = 0, horse_hp_droptime = 0, horse_stamina = 0, horse_skill_point = 1, skill_level = '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\



és anyi még ha ezeket sikerülne rendbe hozni hogy mentés meg e lesz karaktereknél tehát ott marad ahol hagytam szintjük pénzük exp skill stat tehát minden meg marad náluk? :)
Nyomtatás
Fel Oldalak1
Felhasználói műveletek