Problem SQL.

[ManiacRobert 488]

Hi, i have error when create item from website or anything.

I use 40k with source, it's a new error, i don't add anything, and item it's like 

 

 

SYSERR: Feb 15 14:51:16 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Feb 15 15:16:28 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'attrtype1' at row 1 (query: REPLACE INTO item (id, owner_id, window, pos, count, vnum, attrtype0, attrvalue0, attrtype1, attrvalue1, attrtype2, attrvalue2, attrtype3, attrvalue3, attrtype4, attrvalue4, attrtype5, attrvalue5, attrtype6, attrvalue6, applytype0, applyvalue0, applytype1, applyvalue1, applytype2, applyvalue2, applytype3, applyvalue3, applytype4, applyvalue4, applytype5, applyvalue5, applytype6, applyvalue6, applytype7, applyvalue7) VALUES(190000177, 42, 1, 11, 1, 16549, 0, 1, 184, 29, 15, 16, 10, 15, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0) errno: 1264)
SYSERR: Feb 15 15:16:30 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'attrtype1' at row 1 (query: REPLACE INTO item (id, owner_id, window, pos, count, vnum, attrtype0, attrvalue0, attrtype1, attrvalue1, attrtype2, attrvalue2, attrtype3, attrvalue3, attrtype4, attrvalue4, attrtype5, attrvalue5, attrtype6, attrvalue6, applytype0, applyvalue0, applytype1, applyvalue1, applytype2, applyvalue2, applytype3, applyvalue3, applytype4, applyvalue4, applytype5, applyvalue5, applytype6, applyvalue6, applytype7, applyvalue7) VALUES(190000178, 42, 1, 24, 1, 16209, 0, 1, 184, 1, 136, 30, 15, 31, 15, 34, 15, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0) errno: 1264)
SYSERR: Feb 15 15:19:31 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'part_main' at row 1 (query: UPDATE player SET job = 2, voice = 0, dir = 0, x = 953446, y = 261209, z = 0, map_index = 41, exit_x = 953446, exit_y = 261209, exit_map_index = 41, hp = -21097, mp = 2872, stamina = 875, random_hp = 4902, random_sp = 2052, playtime = 2728, level = 115, level_step = 0, st = 5, ht = 3, dx = 3, iq = 5, gold = 389000000, exp = 35916401, stat_point = 267, skill_point = 114, sub_skill_point = 56, stat_reset_count = 0, ip = '86.126.17.30', part_main = 41029, part_hair = 0, part_acce = 0, last_play = NOW(), skill_group = 1, alignment = -113767, horse_level = 30, horse_riding = 0, horse_hp = 50, horse_hp_droptime = 1455735613, horse_stamina = 200, horse_skill_point = 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\0
SYSERR: Feb 15 15:26:09 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'attrtype1' at row 1 (query: REPLACE INTO item (id, owner_id, window, pos, count, vnum, attrtype0, attrvalue0, attrtype1, attrvalue1, attrtype2, attrvalue2, attrtype3, attrvalue3, attrtype4, attrvalue4, attrtype5, attrvalue5, attrtype6, attrvalue6, applytype0, applyvalue0, applytype1, applyvalue1, applytype2, applyvalue2, applytype3, applyvalue3, applytype4, applyvalue4, applytype5, applyvalue5, applytype6, applyvalue6, applytype7, applyvalue7) VALUES(190000177, 42, 2, 5, 1, 16549, 0, 1, 184, 29, 15, 16, 10, 15, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0) errno: 1264)
SYSERR: Feb 15 15:26:32 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'part_main' at row 1 (query: UPDATE player SET job = 2, voice = 0, dir = 0, x = 953662, y = 261202, z = 0, map_index = 41, exit_x = 953662, exit_y = 261202, exit_map_index = 41, hp = -21097, mp = 2872, stamina = 875, random_hp = 4902, random_sp = 2052, playtime = 2734, level = 115, level_step = 0, st = 5, ht = 3, dx = 3, iq = 5, gold = 389000000, exp = 35916401, stat_point = 267, skill_point = 114, sub_skill_point = 56, stat_reset_count = 0, ip = '86.126.17.30', part_main = 41029, part_hair = 0, part_acce = 0, last_play = NOW(), skill_group = 1, alignment = -113407, horse_level = 30, horse_riding = 0, horse_hp = 50, horse_hp_droptime = 1455735613, horse_stamina = 200, horse_skill_point = 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\0
SYSERR: Feb 15 15:33:33 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'part_main' at row 1 (query: UPDATE player SET job = 2, voice = 0, dir = 0, x = 954063, y = 261320, z = 0, map_index = 41, exit_x = 954063, exit_y = 261320, exit_map_index = 41, hp = -21097, mp = 2872, stamina = 875, random_hp = 4902, random_sp = 2052, playtime = 2743, level = 115, level_step = 0, st = 5, ht = 3, dx = 3, iq = 5, gold = 389000000, exp = 35916401, stat_point = 267, skill_point = 114, sub_skill_point = 56, stat_reset_count = 0, ip = '86.126.17.30', part_main = 41029, part_hair = 0, part_acce = 0, last_play = NOW(), skill_group = 1, alignment = -112867, horse_level = 30, horse_riding = 0, horse_hp = 50, horse_hp_droptime = 1455735613, horse_stamina = 200, horse_skill_point = 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\0

 

Edited August 20, 2022 by Metin2 Dev
Core X - External 2 Internal

[Mr.Slime 142]

Design table for table item

attrtype1 Type: tinyint Lenght: 4

Design table for table player

partmain Type: smallint Lenght: 6

 

Best Regards,

Mr.Slime

[ManiacRobert 488]

Already is, it's source problem or something?

 

//Fixed, Removed 4th stone.