SQL query problem source

[avertuss 45]

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? 

[Metin2 Dev 4664]

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

[avertuss 45]

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

[Metin2 Dev 4664]

You set the length to "5", make it 50 or something like that. Try, if the error will be fixxed with it.

 

MfG

Cyber

[avertuss 45]

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

[North 1121]

http://dev.mysql.com/doc/refman/5.5/en/fixed-point-types.html
 

[avertuss 45]

33 minutes ago, Fleon said:

http://dev.mysql.com/doc/refman/5.5/en/fixed-point-types.html
 

???

[North 1121]

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

 

[avertuss 45]

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. 

[North 1121]

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.

[avertuss 45]

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

[North 1121]

25.69.178.230

Search for this ip and look for the HP value

 

hp = -31214

 

You have this negative value

[avertuss 45]

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

[North 1121]

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

[avertuss 45]

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.

[North 1121]

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.

[avertuss 45]

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? 

[North 1121]

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

[avertuss 45]

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.