Peterekczech 6 Posted June 1, 2014 Share Posted June 1, 2014 Hi, I have a problem with mysql table mob_proto on FreeBSD I have Mysql 5.6v makes a mistake in my syserr db: SYSERR: May 22 21:21:04 :: ChildLoop: AsyncSQL: query failed: Data truncated for column 'size' at row 1 (query: replace into mob_proto (vnum, name, locale_name, type, rank, battle_type, level, size, ai_flag, setRaceFlag, setImmuneFlag, on_click, empire, drop_item, resurrection_vnum, folder, st, dx, ht, iq, damage_min, damage_max, max_hp, regen_cycle, regen_percent, exp, gold_min, gold_max, def, attack_speed, move_speed, aggressive_hp_pct, aggressive_sight, attack_range, polymorph_item, enchant_curse, enchant_slow, enchant_poison, enchant_stun, enchant_critical, enchant_penetrate, resist_sword, resist_twohand, resist_dagger, resist_bell, resist_fan, resist_bow, resist_fire, resist_elect, resist_magic, resist_wind, resist_poison, dam_multiply, summon, drain_sp, skill_vnum0, skill_level0, skill_vnum1, skill_level1, skill_vnum2, skill_level2, skill_vnum3, skill_level3, skill_vnum4, skill_level4, sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive) values (102, "??", "Wolf", 0, 0, 0, 3, 0, 0, 1, 0, 0, 0 Thanks for all the answers. Link to comment Share on other sites More sharing options...
Premium Shogun 4591 Posted June 1, 2014 Premium Share Posted June 1, 2014 its harmless but if you want to fix it add a '' to the size enum in mysql Link to comment Share on other sites More sharing options...
Peterekczech 6 Posted June 2, 2014 Author Share Posted June 2, 2014 (edited) Hi, column is defined as follows: this errors show only on version 5.6 but if i install mysql 55 it is works INSERT INTO `mob_proto` VALUES ('101', '??', 0x4469766F6BFD20706573, '0', '0', '0', '1', '', '', '0', 'ANIMAL', '', '0', 'stray_dog', '0', '2', '4', '3', '1', '10', '15', '50', '6', '7', '6267', '8178', '3', '1', '100', '100', '0', '2000', '175', '800000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '20', '0', '0', '1', '0', '0', '0', '70105', '0', '0', '0', '0', null, null, null, null, null, null, '0', '0', '0', '0', '0'); [SQL]INSERT INTO `mob_proto` VALUES ('101', '????', 0x4469766F6BFD20706573, '0', '0', '0', '6', '', '', '0', 'stray_dog', '', '0', 'wolf', '0', '9', '12', '6', '3', '25', '38', '225', '6', '7', '6267', '8178', '40', '9', '100', '100', '25', '2000', '175', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '70104', '0', '0', '0', '0', null, null, null, null, null, null, '0', '0', '0', '0', '0'); error query [Err] 1265 - Data truncated for column 'size' at row 1 Edited August 15, 2022 by Metin2 Dev Core X - External 2 Internal Link to comment Share on other sites More sharing options...
Night 366 Posted June 2, 2014 Share Posted June 2, 2014 (edited) Hi, column is defined as follows: this errors show only on version 5.6 but if i install mysql 55 it is works INSERT INTO `mob_proto` VALUES ('101', '??', 0x4469766F6BFD20706573, '0', '0', '0', '1', '', '', '0', 'ANIMAL', '', '0', 'stray_dog', '0', '2', '4', '3', '1', '10', '15', '50', '6', '7', '6267', '8178', '3', '1', '100', '100', '0', '2000', '175', '800000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '20', '0', '0', '1', '0', '0', '0', '70105', '0', '0', '0', '0', null, null, null, null, null, null, '0', '0', '0', '0', '0'); [SQL]INSERT INTO `mob_proto` VALUES ('101', '????', 0x4469766F6BFD20706573, '0', '0', '0', '6', '', '', '0', 'stray_dog', '', '0', 'wolf', '0', '9', '12', '6', '3', '25', '38', '225', '6', '7', '6267', '8178', '40', '9', '100', '100', '25', '2000', '175', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '70104', '0', '0', '0', '0', null, null, null, null, null, null, '0', '0', '0', '0', '0'); error query [Err] 1265 - Data truncated for column 'size' at row 1 on my mob proto the allow null is disable on size any why why do you want to change it? Edited August 15, 2022 by Metin2 Dev Core X - External 2 Internal Link to comment Share on other sites More sharing options...
Peterekczech 6 Posted June 2, 2014 Author Share Posted June 2, 2014 When you change it in any way I have this mv syserr db SYSERR: Jun 2 17:52:35 :: ChildLoop: AsyncSQL: query failed: Data truncated for column 'size' at row 1 (query: replace into mob_proto (vnum, name, locale_name, type, rank, battle_type, level, size, ai_flag, setRaceFlag, setImmuneFlag, on_click, empire, drop_item, resurrection_vnum, folder, st, dx, ht, iq, damage_min, damage_max, max_hp, regen_cycle, regen_percent, exp, gold_min, gold_max, def, attack_speed, move_speed, aggressive_hp_pct, aggressive_sight, attack_range, polymorph_item, enchant_curse, enchant_slow, enchant_poison, enchant_stun, enchant_critical, enchant_penetrate, resist_sword, resist_twohand, resist_dagger, resist_bell, resist_fan, resist_bow, resist_fire, resist_elect, resist_magic, resist_wind, resist_poison, dam_multiply, summon, drain_sp, skill_vnum0, skill_level0, skill_vnum1, skill_level1, skill_vnum2, skill_level2, skill_vnum3, skill_level3, skill_vnum4, skill_level4, sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive) values (102, "??", "Vlk", 0, 0, 0, 3, 0, 0, 1, 0, 0, 0 but when I leave the original mob_proto see no record in the table. Because there is not no record insert [Err] 1265 - Data truncated for column 'size' at row 1 Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now