Jump to content

Recommended Posts

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

  • Replies 4
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Hi,

column is defined as follows:

 

qeGvg.png

 

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 by Metin2 Dev
Core X - External 2 Internal
Link to comment
Share on other sites

 

Hi,

column is defined as follows:

 

qeGvg.png

 

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 by Metin2 Dev
Core X - External 2 Internal
Link to comment
Share on other sites

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

Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now

Announcements



  • Similar Content

  • Activity

    1. 0

      Target Information System

    2. 1

      Feeding game source to LLM

    3. 2

      anti exp explanation pls

    4. 1

      Feeding game source to LLM

    5. 2

      anti exp explanation pls

    6. 0

      [GR2] Positioning an object added with "Attach"

    7. 1417

      [40250] Reference Serverfile + Client + Src [15 Available Languages]

  • Recently Browsing

    • No registered users viewing this page.
×
×
  • Create New...

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.