ChildLoop: AsyncSQL: query failed: Data truncated for column 'size' at row 1 (query: replace into mob_proto

[daradevil124 370]

SYSERR: Feb  4 12:07:14 :: 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 (101, "??", "Yabani Köpek", 0, 0, 0, 1, 0, 0, 1

 

I get syserr for every mob on db

I just installed freebsd 10.3 i386 and mysql 5.6.

The game opens without problems, but syserr is printing.

*****************UPDATE***********************

I solved the problem myself;

1. Dump the mob_proto file to the desktop and edit with notepad++
2. Search enum and replace with set

Problem was fixed permenantly

[Avulsen 0]

i have same error message can someone help me please ?

 

[TMP4 10995]

11 minutes ago, Avulsen said:

i have same error message can someone help me please ?

 

It's because of MySQL5.6 have STRICT_TRANS_TABLES on by default.
Change sql_mode from sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES to sql_mode=NO_ENGINE_SUBSTITUTION in /usr/local/my.cnf

[[TiTAN] 32]

You can do like TMP4 told you, but i advise you to keep this future on and modify tables and/or queries accordingly