SQL error - 20m HP

[Cephaler]

: DB error - Out of range value for column 'hp' at row 1

[Debug]: at ..\src\char\char.c:499 - UPDATE `char` SET `base_level`='600', `job_

level`='250',`base_exp`='2', `job_exp`='2', `zeny`='871777525',`max_hp`='1523041

',`hp`='17371786',`max_sp`='18857',`sp`='22652',`status_point`='246649',`skill_p

oint`='249',`str`='500',`agi`='500',`vit`='500',`int`='500',`dex`='500',`luk`='5

00',`option`='0',`party_id`='0',`guild_id`='0',`pet_id`='0',`homun_id`='0',`elem

ental_id`='0',`weapon`='16',`shield`='0',`head_top`='208',`head_mid`='82',`head_

bottom`='1526',`last_map`='Mellina',`last_x`='60',`last_y`='74',`save_map`='pron

tera',`save_x`='150',`save_y`='175', `rename`='0',`delete_date`='0',`robe`='0' W

HERE `account_id`='2000000' AND `char_id` = '150000'

I changed max hp in config/battle/player to 20.000.000 and since then this error keeps showing up. although i do have 20m hp

Any way to fix it?

[Emistry]

this is because the SQL Data Type that used to save HP value is capped at

- 2,147,483,647 ~ 2,147,483,647

so, you can try this...

run this query in your SQL ( use at your own risk )

ALTER TABLE `char` CHANGE COLUMN `max_hp` `max_hp` BIGINT(11) UNSIGNED NOT NULL DEFAULT '0'  , CHANGE COLUMN `hp` `hp` BIGINT(11) UNSIGNED NOT NULL DEFAULT '0'  , CHANGE COLUMN `max_sp` `max_sp` BIGINT(11) UNSIGNED NOT NULL DEFAULT '0'  , CHANGE COLUMN `sp` `sp` BIGINT(11) UNSIGNED NOT NULL DEFAULT '0'  ;

[Cephaler]

Worked like a charm ! Thanks!