[Question] Files or game

[PandiCore 9]

Hi guys, I have a problem with the server
 

When you make a new character and bring items and level, and yang, etc., but when leaving the client, or give it a reboot occurs with level 1 character with items and yang but remains level and where I can be led lam the problem?

 

And when I kill someone give me in town

 

I use source to compile game and db

 

 

 

 

[PandiCore 9]

Up..

[Galet 514]

Google translate ?

 

If you create a new character, with level and items, only level remains ? Please give us your db syserr

[PandiCore 9]

Google translate ?

 

If you create a new character, with level and items, only level remains ? Please give us your db syserr

SYSERR: May 11 08:51:54 :: pid_init:

Start of pid: 1173

SYSERR: May 11 08:51:54 :: Start: TABLE_POSTFIX not configured use default

SYSERR: May 11 08:51:55 :: ChildLoop: AsyncSQL: query failed: Data truncated for column 'setImmuneFlag' 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 (2092, "´ë¿Õ°Å¹Ì", "Spider King", 0, 5

SYSERR: May 11 08:51:58 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'name' in field list is ambiguous

query: SELECT empire, pid, name, money, windate FROM monarch a, player b where a.pid=b.id

SYSERR: May 11 09:00:43 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'stat_reset_count' at row 1 (query: UPDATE player SET job = 4, voice = 0, dir = 0, x = 969253, y = 278400, z = 0, map_index = 41, exit_x = 969253, exit_y = 278400, exit_map_index = 41, hp = 10343, mp = 5305, stamina = 820, random_hp = 9583, random_sp = 5439, playtime = 1, level = 260, level_step = 0, st = 6, ht = 4, dx = 3, iq = 3, gold = 0, exp = 0, stat_point = 0, skill_point = 267, sub_skill_point = 259, stat_reset_count = 251, ip = '(null)', part_main = 683554849, part_hair = 0, last_play = NOW(), skill_group = 0, alignment = 1, horse_level = 0, horse_riding = 0, horse_hp = 0, horse_hp_droptime = 0, horse_stamina = 0, horse_skill_point = 0, skill_level = '000000(0000(0000(0000(0000(0000(000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

 

[Benhero 23]

Query Failed.

1. AsyncSQL: query failed: Data truncated for column 'setImmuneFlag' at row 1

2. mysql_query error: Column 'name' in field list is ambiguous

Check & Repair you Mob_proto and your player table

 

Greatz