Jump to content
×
×
  • Create New...
  • 0

SQL query problem source


avertuss

Question

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

18 answers to this question

Recommended Posts

  • 0
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

5f205ad281315a4d6ac209b8c29e939f.png

Link to comment
  • 0
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

a7428627910aebdb0e7749aebb708b59.png

Link to comment
  • 0
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
  • 0
  • Premium
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
  • 0
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  611de8d130422d2686d4d2621aa0bf6c.png i have problem with character with value 32352. 

Link to comment
  • 0
  • Premium

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
  • 0
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
  • 0
  • Premium
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
  • 0
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

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

Announcements

  • -15% Discount in Metin2 Dev Store (01/10/2021 => 31/12/2021) => Code => 15_PCT_OCT_TO_DEC_2021


Important Information

Terms of Use / Privacy Policy / Guidelines / We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.