Tapasztalat

[Deadly2000]

Sziasztok !
Tapasztaltatok már olyat ,hogy egy futó szerveren ( legyen teszt vagy bármi ) leállás nélkül visszaáll egy bizonyos időre pár karakter

Mondjuk én felfejlődök 75 re . Lelépek 2 óra múlva visszaesik 70 -re . Vagy volt olyan is ,hogy a kezdőhídra üresen rakja.

pl : Eltünik a yang , szint , rang

Syserr tele van log hibákkal , ezek utalhatnak rá ..

Kód Kijelölés Kibont

SYSERR: Feb  2 21:12:55.382391 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xE1rgy e...' for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 68930, 960150, 269569, 38469, 'USE_ITEM', 'Tárgy elvarázsolás 13', '5.204.126.1', 71052) errno: 1366)
SYSERR: Feb  2 21:12:56.383177 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xE1rgy e...' for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 68930, 960150, 269569, 38469, 'USE_ITEM', 'Tárgy elvarázsolás 12', '5.204.126.1', 71052) errno: 1366)
SYSERR: Feb  2 21:12:57.502800 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xE1rgy e...' for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 68930, 960150, 269569, 38469, 'USE_ITEM', 'Tárgy elvarázsolás 11', '5.204.126.1', 71052) errno: 1366)
SYSERR: Feb  2 21:12:58.225919 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xF5r Csi...' for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 68950, 959679, 269654, 10010691, 'REFINE SUCCESS', 'Bõr Csizma+2', '213.181.198.243', 15082) errno: 1366)
SYSERR: Feb  2 21:12:58.226200 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xF5r Csi...' for column 'item_name' at row 1 (query: INSERT INTO refinelog (pid, item_name, item_id, step, time, is_success, setType) VALUES(68950, 'Bõr Csizma+1', 10010690, 1, NOW(), 1, 'SCROLL') errno: 1366)
SYSERR: Feb  2 21:12:58.226603 :: 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(), 68950, 959679, 269654, 10010690, 'REMOVE (REFINE SUCCESS)', 'Bõr Csizma+1 1 ', '213.181.198.243', 15081) errno: 1406)
SYSERR: Feb  2 21:12:58.420250 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xE1rgy e...' for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 68930, 960150, 269569, 38469, 'USE_ITEM', 'Tárgy elvarázsolás 10', '5.204.126.1', 71052) errno: 1366)
SYSERR: Feb  2 21:12:59.380213 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xE1rgy e...' for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 68930, 960150, 269569, 38469, 'USE_ITEM', 'Tárgy elvarázsolás 9', '5.204.126.1', 71052) errno: 1366)
SYSERR: Feb  2 21:13:00.302466 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xE1rgy e...' for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 68930, 960150, 269569, 38469, 'USE_ITEM', 'Tárgy elvarázsolás 8', '5.204.126.1', 71052) errno: 1366)
SYSERR: Feb  2 21:13:01.262385 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xE1rgy e...' for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 68930, 960150, 269569, 38469, 'USE_ITEM', 'Tárgy elvarázsolás 7', '5.204.126.1', 71052) errno: 1366)
SYSERR: Feb  2 21:13:01.701392 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xF5r Csi...' for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 68950, 959679, 269654, 10010692, 'REFINE SUCCESS', 'Bõr Csizma+3', '213.181.198.243', 15083) errno: 1366)
SYSERR: Feb  2 21:13:01.701691 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xF5r Csi...' for column 'item_name' at row 1 (query: INSERT INTO refinelog (pid, item_name, item_id, step, time, is_success, setType) VALUES(68950, 'Bõr Csizma+2', 10010691, 2, NOW(), 1, 'SCROLL') errno: 1366)
SYSERR: Feb  2 21:13:01.702080 :: 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(), 68950, 959679, 269654, 10010691, 'REMOVE (REFINE SUCCESS)', 'Bõr Csizma+2 1 ', '213.181.198.243', 15082) errno: 1406)
SYSERR: Feb  2 21:13:02.262451 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xE1rgy e...' for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 68930, 960150, 269569, 38469, 'USE_ITEM', 'Tárgy elvarázsolás 6', '5.204.126.1', 71052) errno: 1366)
SYSERR: Feb  2 21:13:03.562322 :: 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(), 68817, 959321, 270788, 0, 'LOGIN', '86.125.53.165 7096085 1 41 85', '86.125.53.165') errno: 1406)
SYSERR: Feb  2 21:13:03.562691 :: 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, 12, 68817, inet_aton('86.125.53.165'), '') errno: 1366)
SYSERR: Feb  2 21:13:04.521182 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xE1rgy e...' for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 68930, 960150, 269569, 38469, 'USE_ITEM', 'Tárgy elvarázsolás 5', '5.204.126.1', 71052) errno: 1366)
SYSERR: Feb  2 21:13:05.481484 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xE1rgy e...' for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 68930, 960150, 269569, 38469, 'USE_ITEM', 'Tárgy elvarázsolás 4', '5.204.126.1', 71052) errno: 1366)
SYSERR: Feb  2 21:13:05.640899 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xF5r Csi...' for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 68950, 959679, 269654, 10010693, 'REFINE SUCCESS', 'Bõr Csizma+4', '213.181.198.243', 15084) errno: 1366)
SYSERR: Feb  2 21:13:05.641247 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xF5r Csi...' for column 'item_name' at row 1 (query: INSERT INTO refinelog (pid, item_name, item_id, step, time, is_success, setType) VALUES(68950, 'Bõr Csizma+3', 10010692, 3, NOW(), 1, 'SCROLL') errno: 1366)
SYSERR: Feb  2 21:13:05.641643 :: 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(), 68950, 959679, 269654, 10010692, 'REMOVE (REFINE SUCCESS)', 'Bõr Csizma+3 1 ', '213.181.198.243', 15083) errno: 1406)
SYSERR: Feb  2 21:13:06.601862 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xE1rgy e...' for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 68930, 960150, 269569, 38469, 'USE_ITEM', 'Tárgy elvarázsolás 3', '5.204.126.1', 71052) errno: 1366)
SYSERR: Feb  2 21:13:07.639969 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xE1rgy e...' for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 68930, 960150, 269569, 38469, 'USE_ITEM', 'Tárgy elvarázsolás 2', '5.204.126.1', 71052) errno: 1366)
SYSERR: Feb  2 21:13:08.762931 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xE1rgy e...' for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 68930, 960150, 269569, 38469, 'USE_ITEM', 'Tárgy elvarázsolás 1', '5.204.126.1', 71052) errno: 1366)
SYSERR: Feb  2 21:13:12.882325 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xFBv\xF6l\xF5 ...' for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 68930, 960150, 269569, 37897, 'REMOVE', 'Megbûvölõ tárgy', '5.204.126.1', 71084) errno: 1366)
SYSERR: Feb  2 21:13:15.720216 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xFBv\xF6l\xF5 ...' for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 68930, 960150, 269569, 37899, 'USE_ITEM', 'Megbûvölõ tárgy 19', '5.204.126.1', 71084) errno: 1366)
SYSERR: Feb  2 21:13:17.320865 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xFBv\xF6l\xF5 ...' for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 68930, 960150, 269569, 37899, 'USE_ITEM', 'Megbûvölõ tárgy 18', '5.204.126.1', 71084) errno: 1366)
SYSERR: Feb  2 21:13:19.80610 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xFBv\xF6l\xF5 ...' for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 68930, 960150, 269569, 37899, 'USE_ITEM', 'Megbûvölõ tárgy 17', '5.204.126.1', 71084) errno: 1366)
SYSERR: Feb  2 21:13:20.363072 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xFBv\xF6l\xF5 ...' for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 68930, 960150, 269569, 37899, 'USE_ITEM', 'Megbûvölõ tárgy 16', '5.204.126.1', 71084) errno: 1366)
SYSERR: Feb  2 21:13:21.722010 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xFBv\xF6l\xF5 ...' for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 68930, 960150, 269569, 37899, 'USE_ITEM', 'Megbûvölõ tárgy 15', '5.204.126.1', 71084) errno: 1366)
SYSERR: Feb  2 21:13:24.682585 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xE9rt+9' for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 68950, 962097, 263896, 10010696, 'BUY', 'Feketevas Vért+9', '213.181.198.243', 11299) errno: 1366)
SYSERR: Feb  2 21:13:37.841719 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xE1rk\xE1ny...' for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 68949, 961731, 263649, 10010697, 'BUY', 'Sárkányisten Vért+9', '62.201.77.69', 11289) errno: 1366)
SYSERR: Feb  2 21:13:44.798683 :: 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(), 68930, 960702, 269932, 0, 'WARP', 'Spree MapIdx 41 DestMapIdx0 DestX704100 DestY464100 Empire3', '5.204.126.1') errno: 1406)
SYSERR: Feb  2 21:13:44.960742 :: 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(), 68930, 960702, 269932, 0, 'LOGOUT', '5.204.126.1 341469 1 41 3363', '5.204.126.1') errno: 1406)
SYSERR: Feb  2 21:13:45.80902 :: 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(), 68967, 959115, 268071, 0, 'WARP', 'N3YM4R MapIdx 41 DestMapIdx0 DestX873100 DestY242600 Empire3', '80.98.124.187') errno: 1406)
SYSERR: Feb  2 21:13:45.360503 :: 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(), 68967, 959115, 268071, 0, 'LOGOUT', '80.98.124.187 8742080 1 41 691', '80.98.124.187') errno: 1406)
SYSERR: Feb  2 21:13:46.955826 :: 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(), 68967, 873100, 242600, 0, 'LOGIN', '80.98.124.187 8742080 1 43 691', '80.98.124.187') errno: 1406)
SYSERR: Feb  2 21:13:53.758066 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xF6r\xF6s I...' for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 68848, 959588, 269471, 10010698, 'BUY', 'Vörös Ital(Nagy)', '78.92.83.209', 27003) errno: 1366)
SYSERR: Feb  2 21:13:53.957008 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xF6r\xF6s I...' for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 68848, 959588, 269471, 10010699, 'BUY', 'Vörös Ital(Nagy)', '78.92.83.209', 27003) errno: 1366)
SYSERR: Feb  2 21:13:54.116085 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xF6r\xF6s I...' for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 68848, 959588, 269471, 10010700, 'BUY', 'Vörös Ital(Nagy)', '78.92.83.209', 27003) errno: 1366)
SYSERR: Feb  2 21:13:54.275461 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xF6r\xF6s I...' for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 68848, 959588, 269471, 10010701, 'BUY', 'Vörös Ital(Nagy)', '78.92.83.209', 27003) errno: 1366)
SYSERR: Feb  2 21:13:54.477376 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xF6r\xF6s I...' for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 68848, 959588, 269471, 10010702, 'BUY', 'Vörös Ital(Nagy)', '78.92.83.209', 27003) errno: 1366)
SYSERR: Feb  2 21:13:59.638690 :: 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(), 0, 72, 4294967295, 10010440, 'SET_ATTR', '', '213.181.198.243', 299) errno: 1264)
SYSERR: Feb  2 21:13:59.640253 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xFBv\xF6l\xF5 ...' for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 68950, 960228, 269932, 38324, 'USE_ITEM', 'Megbûvölõ tárgy 49', '213.181.198.243', 71084) errno: 1366)
SYSERR: Feb  2 21:14:00.719716 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xFBv\xF6l\xF5 ...' for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 68950, 960228, 269932, 38324, 'USE_ITEM', 'Megbûvölõ tárgy 48', '213.181.198.243', 71084) errno: 1366)
SYSERR: Feb  2 21:14:02.199445 :: 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, 4294967295, 10010440, 'SET_ATTR', '', '213.181.198.243', 299) errno: 1264)
SYSERR: Feb  2 21:14:02.200871 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xFBv\xF6l\xF5 ...' for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 68950, 960228, 269932, 38324, 'USE_ITEM', 'Megbûvölõ tárgy 47', '213.181.198.243', 71084) errno: 1366)
SYSERR: Feb  2 21:14:03.118117 :: 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, 4294967286, 10010440, 'SET_ATTR', '', '213.181.198.243', 299) errno: 1264)
SYSERR: Feb  2 21:14:03.119765 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xFBv\xF6l\xF5 ...' for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 68950, 960357, 269834, 38324, 'USE_ITEM', 'Megbûvölõ tárgy 46', '213.181.198.243', 71084) errno: 1366)
SYSERR: Feb  2 21:14:03.999681 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xFBv\xF6l\xF5 ...' for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 68950, 960357, 269834, 38324, 'USE_ITEM', 'Megbûvölõ tárgy 45', '213.181.198.243', 71084) errno: 1366)


[mikee0121]

Igen én már tapasztaltam nekem akkor valahogy a pánt rendszer kavart be de nagyon ken félét használtam még anno és amikor a két új kinézetűt tettem fel a karakterre ugyan ez történt nálam is lehet ez csak véletlen egybe esés de nekem akkor volt hasonló gondom. DB nem írt rá semmit viszont a db.core-om volt és az árulta el hogy valami nem oké.

Azóta áttértem itemscalésra nincsen ilyen gondom.

[Deadly2000]

Kód Kijelölés Kibont



SYSERR: Feb  2 21:08:38.624968 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'part_main' at row 1 (query: UPDATE player SET job = 0, voice = 0, dir = 0, x = 960090, y = 271155, z = 0, map_index = 41, exit_x = 960090, exit_y = 271155, exit_map_index = 41, hp = 25864, mp = 4942, stamina = 1250, random_hp = 8964, random_sp = 4482, playtime = 64, level = 250, level_step = 0, st = 90, ht = 90, dx = 90, iq = 13, gold = 7096085, exp = 0, stat_point = 0, skill_point = 135, sub_skill_point = 241, stat_reset_count = 0, ip = '86.125.53.165', part_main = 41313, part_hair = 1009, part_acce = 0, last_play = NOW(), skill_group = 2, alignment = 85, horse_level = 21, horse_riding = 0, horse_hp = 35, horse_hp_droptime = 1486298956, horse_stamina = 120, 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
SYSERR: Feb  2 21:11:31.617810 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'part_main' at row 1 (query: UPDATE player SET job = 2, voice = 0, dir = 0, x = 959344, y = 270142, z = 0, map_index = 41, exit_x = 959344, exit_y = 270142, exit_map_index = 41, hp = 13802, mp = 7000, stamina = 1195, random_hp = 9462, random_sp = 4731, playtime = 397, level = 250, level_step = 0, st = 90, ht = 79, dx = 24, iq = 90, gold = 201690098, exp = 4, stat_point = 0, skill_point = 243, sub_skill_point = 241, stat_reset_count = 0, ip = '80.95.64.57', part_main = 41313, part_hair = 3007, part_acce = 0, last_play = NOW(), skill_group = 1, alignment = 200000, horse_level = 21, horse_riding = 0, horse_hp = 35, horse_hp_droptime = 1486147071, horse_stamina = 120, 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\
SYSERR: Feb  2 21:11:51.617392 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'part_main' at row 1 (query: UPDATE player SET job = 7, voice = 0, dir = 0, x = 960037, y = 271768, z = 0, map_index = 41, exit_x = 960037, exit_y = 271768, exit_map_index = 41, hp = 11271, mp = 5051, stamina = 795, random_hp = 9711, random_sp = 4731, playtime = 126, level = 250, level_step = 2, st = 3, ht = 4, dx = 3, iq = 6, gold = 499011, exp = 46988, stat_point = 269, skill_point = 249, sub_skill_point = 241, stat_reset_count = 0, ip = '84.2.4.38', part_main = 41315, part_hair = 4011, part_acce = 0, last_play = NOW(), skill_group = 1, alignment = 565, horse_level = 21, horse_riding = 0, horse_hp = 35, horse_hp_droptime = 1486289914, horse_stamina = 120, 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
SYSERR: Feb  2 21:13:43.613272 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'part_main' at row 1 (query: UPDATE player SET job = 0, voice = 0, dir = 0, x = 1093409, y = 16457, z = 0, map_index = 68, exit_x = 1093409, exit_y = 16457, exit_map_index = 68, hp = 21985, mp = 3447, stamina = 1208, random_hp = 3261, random_sp = 1622, playtime = 267, level = 82, level_step = 3, st = 90, ht = 90, dx = 67, iq = 3, gold = 180253376, exp = 297714759, stat_point = 12, skill_point = 57, sub_skill_point = 67, stat_reset_count = 0, ip = '91.147.249.163', part_main = 41163, part_hair = 0, part_acce = 2, last_play = NOW(), skill_group = 1, alignment = 24166, horse_level = 21, horse_riding = 0, horse_hp = 35, horse_hp_droptime = 1486307056, horse_stamina = 120, 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\
SYSERR: Feb  2 21:13:44.613453 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'part_main' at row 1 (query: UPDATE player SET job = 0, voice = 0, dir = 0, x = 959970, y = 270627, z = 0, map_index = 41, exit_x = 959970, exit_y = 270627, exit_map_index = 41, hp = 17245, mp = 3499, stamina = 1325, random_hp = 3337, random_sp = 1663, playtime = 291, level = 84, level_step = 1, st = 90, ht = 90, dx = 83, iq = 3, gold = 947839512, exp = 168350750, stat_point = 0, skill_point = 51, sub_skill_point = 68, stat_reset_count = 0, ip = '84.236.109.142', part_main = 41163, part_hair = 1007, part_acce = 1, last_play = NOW(), skill_group = 1, alignment = 38794, horse_level = 21, horse_riding = 0, horse_hp = 35, horse_hp_droptime = 1486305794, horse_stamina = 120, 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\
SYSERR: Feb  2 21:13:59.613425 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'part_main' at row 1 (query: UPDATE player SET job = 2, voice = 0, dir = 0, x = 959865, y = 271083, z = 0, map_index = 41, exit_x = 959865, exit_y = 271083, exit_map_index = 41, hp = 23024, mp = 4095, stamina = 1275, random_hp = 3081, random_sp = 1659, playtime = 208, level = 80, level_step = 0, st = 64, ht = 90, dx = 9, iq = 90, gold = 2896405, exp = 35333367, stat_point = 0, skill_point = 38, sub_skill_point = 70, stat_reset_count = 0, ip = '85.67.110.155', part_main = 46230, part_hair = 3006, part_acce = 1, last_play = NOW(), skill_group = 1, alignment = 13352, horse_level = 21, horse_riding = 0, horse_hp = 35, horse_hp_droptime = 1486304413, horse_stamina = 120, 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\
SYSERR: Feb  2 21:14:26.613370 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'part_main' at row 1 (query: UPDATE player SET job = 0, voice = 0, dir = 0, x = 960416, y = 269543, z = 0, map_index = 41, exit_x = 960416, exit_y = 269543, exit_map_index = 41, hp = 20154, mp = 2225, stamina = 1250, random_hp = 3160, random_sp = 1563, playtime = 178, level = 80, level_step = 0, st = 90, ht = 90, dx = 55, iq = 3, gold = 530101080, exp = 375656, stat_point = 15, skill_point = 61, sub_skill_point = 71, stat_reset_count = 0, ip = '82.131.231.107', part_main = 42230, part_hair = 1002, part_acce = 2, last_play = NOW(), skill_group = 1, alignment = 25563, horse_level = 21, horse_riding = 0, horse_hp = 35, horse_hp_droptime = 1486307299, horse_stamina = 120, 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\
SYSERR: Feb  2 21:14:28.613447 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'part_main' at row 1 (query: UPDATE player SET job = 7, voice = 0, dir = 0, x = 960585, y = 271332, z = 0, map_index = 41, exit_x = 960585, exit_y = 271332, exit_map_index = 41, hp = 11511, mp = 6029, stamina = 820, random_hp = 10209, random_sp = 5478, playtime = 6, level = 250, level_step = 0, st = 3, ht = 4, dx = 3, iq = 6, gold = 0, exp = 0, stat_point = 267, skill_point = 249, sub_skill_point = 241, stat_reset_count = 0, ip = '84.236.111.152', part_main = 51090, part_hair = 4009, part_acce = 0, last_play = NOW(), skill_group = 0, alignment = 30, horse_level = 0, horse_riding = 0, 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: Feb  2 21:14:49.613463 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'part_main' at row 1 (query: UPDATE player SET job = 2, voice = 0, dir = 0, x = 78653, y = 590796, z = 0, map_index = 217, exit_x = 78653, exit_y = 590796, exit_map_index = 217, hp = 17613, mp = 7565, stamina = 1250, random_hp = 2696, random_sp = 1385, playtime = 75, level = 69, level_step = 2, st = 31, ht = 90, dx = 3, iq = 90, gold = 242607411, exp = 38955568, stat_point = 8, skill_point = 51, sub_skill_point = 60, stat_reset_count = 0, ip = '86.126.226.146', part_main = 41163, part_hair = 1, part_acce = 0, last_play = NOW(), skill_group = 1, alignment = 7698, horse_level = 21, horse_riding = 1, horse_hp = 35, horse_hp_droptime = 1486304535, horse_stamina = 120, 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\
SYSERR: Feb  2 21:15:16.613344 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'part_main' at row 1 (query: UPDATE player SET job = 2, voice = 0, dir = 0, x = 959634, y = 269726, z = 0, map_index = 41, exit_x = 959634, exit_y = 269726, exit_map_index = 41, hp = 20434, mp = 4090, stamina = 1250, random_hp = 2802, random_sp = 1385, playtime = 88, level = 71, level_step = 3, st = 46, ht = 90, dx = 3, iq = 90, gold = 103483459, exp = 82904610, stat_point = 0, skill_point = 70, sub_skill_point = 62, stat_reset_count = 0, ip = '85.66.121.250', part_main = 41163, part_hair = 0, part_acce = 0, last_play = NOW(), skill_group = 1, alignment = 6854, horse_level = 21, horse_riding = 0, horse_hp = 35, horse_hp_droptime = 1486318933, horse_stamina = 120, 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
SYSERR: Feb  2 21:15:33.613353 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'part_main' at row 1 (query: UPDATE player SET job = 2, voice = 0, dir = 0, x = 200812, y = 1219796, z = 0, map_index = 73, exit_x = 200812, exit_y = 1219796, exit_map_index = 73, hp = 22928, mp = 4377, stamina = 1293, random_hp = 3115, random_sp = 1567, playtime = 175, level = 80, level_step = 2, st = 71, ht = 90, dx = 3, iq = 90, gold = 345268768, exp = 147217459, stat_point = 1, skill_point = 59, sub_skill_point = 71, stat_reset_count = 0, ip = '79.120.137.26', part_main = 46230, part_hair = 0, part_acce = 1, last_play = NOW(), skill_group = 1, alignment = 21993, horse_level = 21, horse_riding = 0, horse_hp = 35, horse_hp_droptime = 1486309538, horse_stamina = 120, 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\
SYSERR: Feb  2 21:15:33.613980 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'part_main' at row 1 (query: UPDATE player SET job = 6, voice = 0, dir = 0, x = 959195, y = 269263, z = 0, map_index = 41, exit_x = 959195, exit_y = 269263, exit_map_index = 41, hp = 20195, mp = 4548, stamina = 1250, random_hp = 2957, random_sp = 1720, playtime = 254, level = 83, level_step = 0, st = 64, ht = 90, dx = 18, iq = 90, gold = 33201391, exp = 80790094, stat_point = 0, skill_point = 110, sub_skill_point = 116, stat_reset_count = 0, ip = '78.92.83.209', part_main = 46230, part_hair = 0, part_acce = 1, last_play = NOW(), skill_group = 1, alignment = 24462, horse_level = 21, horse_riding = 0, horse_hp = 35, horse_hp_droptime = 1486305454, horse_stamina = 120, 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\
SYSERR: Feb  2 21:15:39.613135 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'part_main' at row 1 (query: UPDATE player SET job = 0, voice = 0, dir = 0, x = 55700, y = 157900, z = 0, map_index = 21, exit_x = 55700, exit_y = 157900, exit_map_index = 21, hp = 25864, mp = 4942, stamina = 1250, random_hp = 8964, random_sp = 4482, playtime = 65, level = 250, level_step = 0, st = 90, ht = 90, dx = 90, iq = 13, gold = 7096085, exp = 0, stat_point = 0, skill_point = 135, sub_skill_point = 241, stat_reset_count = 0, ip = '86.125.53.165', part_main = 41313, part_hair = 1009, part_acce = 0, last_play = NOW(), skill_group = 2, alignment = 85, horse_level = 21, horse_riding = 0, horse_hp = 35, horse_hp_droptime = 1486298956, horse_stamina = 120, 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


Ez lesz az !

[Deadly2000]

Cseréltem MYSQL -t , új szerverfájlt , új forrás de ez nem jött össze :

Kód Kijelölés Kibont

SYSERR: Feb  6 20:53:46.817650 :: 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, 4294967290, 10030912, 'SET_ATTR', '', '', 1179) errno: 1264)
SYSERR: Feb  6 20:54:06.377038 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xF68746j...' for column '4' at row 1 (query: INSERT INTO shout_log VALUES(NOW(), 1, 3,'nev : k43nm52o3u54ntgqu93nfcsodfm3op436i59ö8746j5 mn.,z245mp4kpõ34ojzm3o56õhgnwie') errno: 1366)
SYSERR: Feb  6 20:54:15.936234 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xE9132\xE1\xE9...' for column '4' at row 1 (query: INSERT INTO shout_log VALUES(NOW(), 1, 3,'nev :  asdé132áé12áéd1á2édásadá21á21áéd12áéd12áéd21') errno: 1366)



Már rá jöttem ,hogy nem tudja berakni a táblázatba ,de azt nem ,hogy miért

[MagicBoss]

Az első hibát azért írja, mert túlcsordul az y mező értéke.
Navicat->log->log táblára jobb klikk->Design table
y mező típusát írd át bigint-re.

A 2. és 3. hibának ehhez semmi köze, bár ennek sem.
A shout_logba érvénytelen karaktert próbál írni, ergo karakterkódolás probléma.
Módosítsd a shout_log reláció 4-es mezőjének karakterkódolását latin2_hungarian-ra.
Magyarul: shout_log tábla 4 névre keresztelt oszlopának karakterkódolását.