Player query - problem with hp

[avertuss 58]

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

[Syreldar 2736]

player -> design table -> set hp column to bigint type, length 5.

[avertuss 58]

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

[Syreldar 2736]

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

[avertuss 58]

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

[Syreldar 2736]

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.

[avertuss 58]

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\

 

[avertuss 58]

Nvm, fixed. Fix -> tables.h hp mp to int.