avertuss 48 Posted January 14, 2017 Share Posted January 14, 2017 Hi. I have problem. SYSERR: Jan 14 13:42:48 :: 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(), 4, 30, 15, 2100000099, 'ADD_ATTRIBUTE_SUCCESS', '2100000109', '25.69.178.230', 71085) errno: 1406) SYSERR: Jan 14 13:42:49 :: 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(), 4, 34, 15, 2100000099, 'ADD_ATTRIBUTE_SUCCESS', '2100000109', '25.69.178.230', 71085) errno: 1406) SYSERR: Jan 14 13:42:49 :: 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(), 4, 23, 10, 2100000099, 'ADD_ATTRIBUTE_SUCCESS', '2100000109', '25.69.178.230', 71085) errno: 1406) SYSERR: Jan 14 13:42:50 :: 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(), 4, 32, 15, 2100000099, 'ADD_ATTRIBUTE_SUCCESS', '2100000109', '25.69.178.230', 71085) errno: 1406) SYSERR: Jan 14 13:42:51 :: 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(), 4, 29, 15, 2100000099, 'ADD_ATTRIBUTE_SUCCESS', '2100000109', '25.69.178.230', 71085) errno: 1406) and SYSERR: Jan 14 13:41:36 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'hp' at row 1 (query: UPDATE player SET job = 6, voice = 0, dir = 0, x = 959900, y = 269200, z = 0, map_index = 41, exit_x = 959900, exit_y = 269200, exit_map_index = 41, hp = -32763, mp = 6050, stamina = 1975, random_hp = 3761, random_sp = 1870, playtime = 258, level = 95, level_step = 0, st = 5, ht = 135, dx = 23, iq = 135, gold = 120061114, exp = 85039, stat_point = 0, skill_point = 1, sub_skill_point = 36, stat_reset_count = 0, ip = '25.69.178.230', part_main = 41004, part_hair = 5003, part_acce = 0, last_play = NOW(), skill_group = 1, alignment = 0, horse_level = 21, horse_riding = 1, horse_hp = 35, horse_hp_droptime = 1484656702, horse_stamina = 120, horse_skill_point = 0, prestige = 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 How to fix it? Link to comment Share on other sites More sharing options...
Bot Metin2 Dev 4940 Posted January 14, 2017 Bot Share Posted January 14, 2017 Field for example is set to: 5 as length. Your number is: 100.000 Increse the field length and set it's type to: "bigint". MfG Cyber Link to comment Share on other sites More sharing options...
avertuss 48 Posted January 15, 2017 Author Share Posted January 15, 2017 (edited) 22 hours ago, Cyber36 said: Field for example is set to: 5 as length. Your number is: 100.000 Increse the field length and set it's type to: "bigint". MfG Cyber Still SYSERR: Jan 15 13:13:32 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'hp' at row 1 (query: UPDATE player SET job = 6, voice = 0, dir = 0, x = 1042957, y = 1701933, z = 0, map_index = 217, exit_x = 1042957, exit_y = 1701933, exit_map_index = 217, hp = -31772, mp = 6220, stamina = 1975, random_hp = 3761, random_sp = 1870, playtime = 275, level = 95, level_step = 0, st = 5, ht = 135, dx = 23, iq = 135, gold = 116091055, exp = 61502430, stat_point = 0, skill_point = 0, sub_skill_point = 36, stat_reset_count = 0, ip = '25.69.178.230', part_main = 41004, part_hair = 5003, part_acce = 0, last_play = NOW(), skill_group = 1, alignment = 0, horse_level = 21, horse_riding = 1, horse_hp = 35, horse_hp_droptime = 1484741197, horse_stamina = 120, horse_skill_point = 0, prestige = 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\ SYSERR: Jan 15 13:20:33 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'hp' at row 1 (query: UPDATE player SET job = 6, voice = 0, dir = 0, x = 1044784, y = 1702911, z = 0, map_index = 217, exit_x = 1044784, exit_y = 1702911, exit_map_index = 217, hp = -31263, mp = 5994, stamina = 1975, random_hp = 3761, random_sp = 1870, playtime = 282, level = 95, level_step = 2, st = 5, ht = 135, dx = 25, iq = 135, gold = 130071483, exp = 192104334, stat_point = 0, skill_point = 0, sub_skill_point = 36, stat_reset_count = 0, ip = '25.69.178.230', part_main = 41004, part_hair = 5003, part_acce = 0, last_play = NOW(), skill_group = 1, alignment = 0, horse_level = 21, horse_riding = 1, horse_hp = 35, horse_hp_droptime = 1484741197, horse_stamina = 120, horse_skill_point = 0, prestige = 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 Edited August 20, 2022 by Metin2 Dev Core X - External 2 Internal Link to comment Share on other sites More sharing options...
Bot Metin2 Dev 4940 Posted January 15, 2017 Bot Share Posted January 15, 2017 You set the length to "5", make it 50 or something like that. Try, if the error will be fixxed with it. MfG Cyber Link to comment Share on other sites More sharing options...
avertuss 48 Posted January 16, 2017 Author Share Posted January 16, 2017 (edited) 22 hours ago, Cyber36 said: You set the length to "5", make it 50 or something like that. Try, if the error will be fixxed with it. MfG Cyber Still the same SYSERR: Jan 16 11:58:35 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'hp' at row 1 (query: UPDATE player SET job = 6, voice = 0, dir = 0, x = 1119208, y = 1738973, z = 0, map_index = 217, exit_x = 1119208, exit_y = 1738973, exit_map_index = 217, hp = -31214, mp = 6239, stamina = 1975, random_hp = 3802, random_sp = 1889, playtime = 299, level = 96, level_step = 1, st = 5, ht = 135, dx = 27, iq = 135, gold = 159090757, exp = 111663503, stat_point = 0, skill_point = 0, sub_skill_point = 37, stat_reset_count = 0, ip = '25.69.178.230', part_main = 41004, part_hair = 5003, part_acce = 0, last_play = NOW(), skill_group = 1, alignment = 0, horse_level = 21, horse_riding = 1, horse_hp = 35, horse_hp_droptime = 1484823150, horse_stamina = 120, horse_skill_point = 0, prestige = 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 Edited August 20, 2022 by Metin2 Dev Core X - External 2 Internal Link to comment Share on other sites More sharing options...
Premium North 1193 Posted January 16, 2017 Premium Share Posted January 16, 2017 http://dev.mysql.com/doc/refman/5.5/en/fixed-point-types.html 1 1 Link to comment Share on other sites More sharing options...
avertuss 48 Posted January 16, 2017 Author Share Posted January 16, 2017 33 minutes ago, Fleon said: http://dev.mysql.com/doc/refman/5.5/en/fixed-point-types.html ??? Link to comment Share on other sites More sharing options...
Premium North 1193 Posted January 16, 2017 Premium Share Posted January 16, 2017 try putting decimal using navicat ->right click player->design table -> player -> HP and i still dont know why you have a negative value on hp field Link to comment Share on other sites More sharing options...
avertuss 48 Posted January 16, 2017 Author Share Posted January 16, 2017 53 minutes ago, Fleon said: try putting decimal using navicat ->right click player->design table -> player -> HP and i still dont know why you have a negative value on hp field On character i have ~35hp if i remember max hp value is 32xxx so maybe it is problem? Maybe i should change hp value in packet.h to int or idk. Link to comment Share on other sites More sharing options...
Premium North 1193 Posted January 16, 2017 Premium Share Posted January 16, 2017 19 minutes ago, avertuss said: On character i have ~35hp if i remember max hp value is 32xxx so maybe it is problem? Maybe i should change hp value in packet.h to int or idk. Thats not the problem, try doing what i said Or just go into player.player serch for any -xxx value in hp field and modify that. Link to comment Share on other sites More sharing options...
avertuss 48 Posted January 16, 2017 Author Share Posted January 16, 2017 (edited) 23 minutes ago, Fleon said: Thats not the problem, try doing what i said Or just go into player.player serch for any -xxx value in hp field and modify that. My hp fields are okay imo i have problem with character with value 32352. Edited August 20, 2022 by Metin2 Dev Core X - External 2 Internal Link to comment Share on other sites More sharing options...
Premium North 1193 Posted January 17, 2017 Premium Share Posted January 17, 2017 25.69.178.230 Search for this ip and look for the HP value hp = -31214 You have this negative value Link to comment Share on other sites More sharing options...
avertuss 48 Posted January 17, 2017 Author Share Posted January 17, 2017 (edited) 15 minutes ago, Fleon said: 25.69.178.230 Search for this ip and look for the HP value hp = -31214 You have this negative value Nope, i have only 5 characters on my server(all mine - server hamachi) nobody have -31214 Edited August 20, 2022 by Metin2 Dev Core X - External 2 Internal Link to comment Share on other sites More sharing options...
Premium North 1193 Posted January 17, 2017 Premium Share Posted January 17, 2017 now that i checked better, he failed to insert that query so its normal to not have that value, ChildLoop: AsyncSQL: query failed: So you can ignore that if you dont want to have negative value in that field Link to comment Share on other sites More sharing options...
avertuss 48 Posted January 17, 2017 Author Share Posted January 17, 2017 9 minutes ago, Fleon said: now that i checked better, he failed to insert that query so its normal to not have that value, ChildLoop: AsyncSQL: query failed: So you can ignore that if you dont want to have negative value in that field Are you sure? It's a little bit annoying. Link to comment Share on other sites More sharing options...
Premium North 1193 Posted January 17, 2017 Premium Share Posted January 17, 2017 Just now, avertuss said: Are you sure? It's a little bit annoying. I am sure. If you want to fix that go into the hp part into the source and add some checks to dont let negative values appear. Link to comment Share on other sites More sharing options...
avertuss 48 Posted January 17, 2017 Author Share Posted January 17, 2017 17 minutes ago, Fleon said: I am sure. If you want to fix that go into the hp part into the source and add some checks to dont let negative values appear. How? Link to comment Share on other sites More sharing options...
Premium North 1193 Posted January 17, 2017 Premium Share Posted January 17, 2017 1 minute ago, avertuss said: How? Buy martysama source that has this fix, or ask him to buy that. Or just go and do it yourself, as we all do, we can give you directions not all the copy/paste code, if you got any question ask. a good starting point would be looking for HP parts in all your source, so you can analyze it and understand how it works Link to comment Share on other sites More sharing options...
avertuss 48 Posted January 17, 2017 Author Share Posted January 17, 2017 39 minutes ago, Fleon said: Buy martysama source that has this fix, or ask him to buy that. Or just go and do it yourself, as we all do, we can give you directions not all the copy/paste code, if you got any question ask. a good starting point would be looking for HP parts in all your source, so you can analyze it and understand how it works But I got this error only when hp exceeds 32k so idk. Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now