Jump to content
  • 0

[HELP] DB Error


Peterekczech

Question

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
  • Answers 4
  • Created
  • Last Reply

Top Posters For This Question

Popular Days

Top Posters For This Question

4 answers to this question

Recommended Posts

  • 0

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

 

Link to comment
  • 0

 

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?

Link to comment
  • 0

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

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


  • Read our Rules
  • Activity

    1. 2

      [Python] Code Translator 2 to 3

    2. 0

      bug gaya

    3. 5

      Fix Core Crash (unused serverside packet)

    4. 45

      Chest Drop View

    5. 0

      How to add Python 3.9 script?

    6. 15

      Metin2 Download Center - Specifications & Documentation

    7. 5

      Fix Core Crash (unused serverside packet)

    8. 45

      Chest Drop View

    9. 5

      Fix Core Crash (unused serverside packet)

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