avertuss 48 Posted March 11, 2017 Share Posted March 11, 2017 Hi. I have problem with hp query into player table. Query: SYSERR: Mar 11 15:59:44 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'hp' at row 1 (query: UPDATE player SET job = 0, voice = 0, dir = 0, x = 960272, y = 273122, z = 0, map_index = 41, exit_x = 960272, exit_y = 273122, exit_map_index = 41, hp = -19450, mp = 2731, stamina = 1975, random_hp = 4072, random_sp = 2016, playtime = 10, level = 102, level_step = 0, st = 135, ht = 135, dx = 46, iq = 3, gold = 530273745, exp = 76221927, stat_point = 0, skill_point = 0, sub_skill_point = 43, stat_reset_count = 0, ip = '25.69.178.230', part_main = 41337, part_hair = 5070, part_sash = 0, last_play = NOW(), skill_group = 0, alignment = -10000, horse_level = 21, horse_riding = 0, horse_hp = 35, horse_hp_droptime = 1489503257, 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 hp in query : -19450 but in game i have 46086 hp Link to comment Share on other sites More sharing options...
Premium Syreldar 1886 Posted March 11, 2017 Premium Share Posted March 11, 2017 player -> design table -> set hp column to bigint type, length 5. "Nothing's free in this life. Ignorant people have an obligation to make up for their ignorance by paying those who help them. Either you got the brains or cash, if you lack both you're useless." Syreldar Link to comment Share on other sites More sharing options...
avertuss 48 Posted March 11, 2017 Author Share Posted March 11, 2017 (edited) 45 minutes ago, Syreldar said: player -> design table -> set hp column to bigint type, length 5. it isn't reason because already i have idk why hp in query has value < 0 if in game i have hp >0 Edited August 20, 2022 by Metin2 Dev Core X - External 2 Internal Link to comment Share on other sites More sharing options...
Premium Syreldar 1886 Posted March 11, 2017 Premium Share Posted March 11, 2017 If you don't know what are you talking about, at least listen to what i say, little buddy. You got type smallint, which is a basic signed integer type. Capable of containing a number which value is <= +32,767. You said you have got 46086 hp, which is greater than 32767, the maximum positive number that type can handle, thus creating an overflow, or out of range, exception. ChildLoop: AsyncSQL: query failed: Out of range value for column 'hp' Put bigint instead of int in the column type, and please.. next time if you ask for help at least learn to listen "Nothing's free in this life. Ignorant people have an obligation to make up for their ignorance by paying those who help them. Either you got the brains or cash, if you lack both you're useless." Syreldar Link to comment Share on other sites More sharing options...
avertuss 48 Posted March 11, 2017 Author Share Posted March 11, 2017 (edited) 26 minutes ago, Syreldar said: If you don't know what are you talking about, at least listen to what i say, little buddy. You got type int, which is a basic signed integer type. Capable of containing a number which value is <= +32,767. You said you have got 46086 hp, which is greater than 32767, the maximum positive number that type can handle, thus creating an overflow, or out of range, exception. ChildLoop: AsyncSQL: query failed: Out of range value for column 'hp' Put bigint instead of int in the column type, and please.. next time if you ask for help at least learn to listen Still SYSERR: Mar 11 21:26:58 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'hp' at row 1 (query: UPDATE player SET job = 0, voice = 0, dir = 0, x = 959652, y = 273628, z = 0, map_index = 41, exit_x = 959652, exit_y = 273628, exit_map_index = 41, hp = -27950, mp = 2731, stamina = 1975, random_hp = 4072, random_sp = 2016, playtime = 13, level = 102, level_step = 0, st = 135, ht = 135, dx = 46, iq = 3, gold = 532359523, exp = 88267224, stat_point = 0, skill_point = 16, sub_skill_point = 43, stat_reset_count = 0, ip = '25.69.178.230', part_main = 41337, part_hair = 5070, part_sash = 4, last_play = NOW(), skill_group = 1, alignment = -10000, horse_level = 21, horse_riding = 0, horse_hp = 35, horse_hp_droptime = 1489522939, 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(üĹX(\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\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: Mar 11 21:33:59 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'hp' at row 1 (query: UPDATE player SET job = 0, voice = 0, dir = 0, x = 469300, y = 964200, z = 0, map_index = 1, exit_x = 469300, exit_y = 964200, exit_map_index = 1, hp = -22950, mp = 2731, stamina = 1975, random_hp = 4072, random_sp = 2016, playtime = 18, level = 102, level_step = 0, st = 135, ht = 135, dx = 46, iq = 3, gold = 532359523, exp = 88267224, stat_point = 0, skill_point = 16, sub_skill_point = 43, stat_reset_count = 0, ip = '25.69.178.230', part_main = 41337, part_hair = 5070, part_sash = 4, last_play = NOW(), skill_group = 1, alignment = -10000, horse_level = 21, horse_riding = 0, horse_hp = 35, horse_hp_droptime = 1489522939, 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(üĹX(\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\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 Syreldar 1886 Posted March 11, 2017 Premium Share Posted March 11, 2017 ALTER TABLE `player` MODIFY COLUMN `hp` bigint(6) UNSIGNED NOT NULL DEFAULT 0 AFTER `exit_map_index`; ALTER TABLE `player` MODIFY COLUMN `mp` bigint(6) UNSIGNED NOT NULL DEFAULT 0 AFTER `hp`; Then restart the server. "Nothing's free in this life. Ignorant people have an obligation to make up for their ignorance by paying those who help them. Either you got the brains or cash, if you lack both you're useless." Syreldar Link to comment Share on other sites More sharing options...
avertuss 48 Posted March 11, 2017 Author Share Posted March 11, 2017 14 minutes ago, Syreldar said: ALTER TABLE `player` MODIFY COLUMN `hp` bigint(5) UNSIGNED NOT NULL AFTER `exit_map_index`; Then restart the server. Still SYSERR: Mar 11 21:55:04 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'hp' at row 1 (query: UPDATE player SET job = 0, voice = 0, dir = 0, x = 967125, y = 277225, z = 0, map_index = 41, exit_x = 967125, exit_y = 277225, exit_map_index = 41, hp = -27950, mp = 2731, stamina = 1975, random_hp = 4072, random_sp = 2016, playtime = 12, level = 102, level_step = 0, st = 135, ht = 135, dx = 46, iq = 3, gold = 542019661, exp = 87633261, stat_point = 0, skill_point = 16, sub_skill_point = 43, stat_reset_count = 0, ip = '25.69.178.230', part_main = 41337, part_hair = 5070, part_sash = 4, last_play = NOW(), skill_group = 1, alignment = -10000, horse_level = 21, horse_riding = 0, horse_hp = 35, horse_hp_droptime = 1489524623, 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\ Link to comment Share on other sites More sharing options...
avertuss 48 Posted March 11, 2017 Author Share Posted March 11, 2017 Nvm, fixed. Fix -> tables.h hp mp to int. 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