Query fail'd -> Hilfe dringend ben�tigt!

Ah Moment mal, das war der von mir bearbeitete Query. xD

INSERT INTO mob_proto(`vnum`, `name`, `gb2312name`, `rank`, `type`, `battle_type`, `level`, `size`, `ai_flag`, `mount_capacity`, `setRaceFlag`, `setImmuneFlag`, `empire`, `folder`, `on_click`, `st`, `dx`, `ht`, `iq`, `damage_min`, `damage_max`, `max_hp`, `regen_cycle`, `regen_percent`, `gold_min`, `gold_max`, `exp`, `def`, `attack_speed`, `move_speed`, `aggressive_hp_pct`, `aggressive_sight`, `attack_range`, `drop_item`, `resurrection_vnum`, `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`, `mob_color`, `polymorph_item`, `skill_level0`, `skill_vnum0`, `skill_level1`, `skill_vnum1`, `sp_berserk`, `sp_stoneskin`, `sp_godspeed`, `sp_deathblow`, `sp_revive`)VALUES(8028, 'Metin der Zombies', 'Metin der Zombies', 5, 2, 3, 90, '', 'NOMOVE', 0, '', 'STUN,SLOW,CURSE,TERROR', 0, '', 0, 0, 0, 60, 0, 0, 0, 999999, 5, 1, 184800, 92400, 540, 57, 9529, 9530, 0, 2000, 175, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 0, 70104, 0, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO mob_proto(`vnum`, `name`, `gb2312name`, `rank`, `type`, `battle_type`, `level`, `size`, `ai_flag`, `mount_capacity`, `setRaceFlag`, `setImmuneFlag`, `empire`, `folder`, `on_click`, `st`, `dx`, `ht`, `iq`, `damage_min`, `damage_max`, `max_hp`, `regen_cycle`, `regen_percent`, `gold_min`, `gold_max`, `exp`, `def`, `attack_speed`, `move_speed`, `aggressive_hp_pct`, `aggressive_sight`, `attack_range`, `drop_item`, `resurrection_vnum`, `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`, `mob_color`, `polymorph_item`, `skill_level0`, `skill_vnum0`, `skill_level1`, `skill_vnum1`, `sp_berserk`, `sp_stoneskin`, `sp_godspeed`, `sp_deathblow`, `sp_revive`)VALUES(8030, 'Metin der Zombies', 'Metin der Zombies', 5, 2, 3, 90, '', 'NOMOVE', 0, '', 'STUN,SLOW,CURSE,TERROR', 0, '', 0, 0, 0, 60, 0, 0, 0, 999999, 5, 1, 184800, 92400, 540, 57, 9529, 9530, 0, 2000, 175, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 0, 70104, 0, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO mob_proto(`vnum`, `name`, `gb2312name`, `rank`, `type`, `battle_type`, `level`, `size`, `ai_flag`, `mount_capacity`, `setRaceFlag`, `setImmuneFlag`, `empire`, `folder`, `on_click`, `st`, `dx`, `ht`, `iq`, `damage_min`, `damage_max`, `max_hp`, `regen_cycle`, `regen_percent`, `gold_min`, `gold_max`, `exp`, `def`, `attack_speed`, `move_speed`, `aggressive_hp_pct`, `aggressive_sight`, `attack_range`, `drop_item`, `resurrection_vnum`, `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`, `mob_color`, `polymorph_item`, `skill_level0`, `skill_vnum0`, `skill_level1`, `skill_vnum1`, `sp_berserk`, `sp_stoneskin`, `sp_godspeed`, `sp_deathblow`, `sp_revive`)VALUES(8031, 'Metin der Zombies', 'Metin der Zombies', 5, 2, 3, 90, '', 'NOMOVE', 0, '', 'STUN,SLOW,CURSE,TERROR', 0, '', 0, 0, 0, 60, 0, 0, 0, 999999, 5, 1, 184800, 92400, 540, 57, 9529, 9530, 0, 2000, 175, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 0, 70104, 0, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO mob_proto(`vnum`, `name`, `gb2312name`, `rank`, `type`, `battle_type`, `level`, `size`, `ai_flag`, `mount_capacity`, `setRaceFlag`, `setImmuneFlag`, `empire`, `folder`, `on_click`, `st`, `dx`, `ht`, `iq`, `damage_min`, `damage_max`, `max_hp`, `regen_cycle`, `regen_percent`, `gold_min`, `gold_max`, `exp`, `def`, `attack_speed`, `move_speed`, `aggressive_hp_pct`, `aggressive_sight`, `attack_range`, `drop_item`, `resurrection_vnum`, `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`, `mob_color`, `polymorph_item`, `skill_level0`, `skill_vnum0`, `skill_level1`, `skill_vnum1`, `sp_berserk`, `sp_stoneskin`, `sp_godspeed`, `sp_deathblow`, `sp_revive`)VALUES(8032, 'Metin der Zombies', 'Metin der Zombies', 5, 2, 3, 90, '', 'NOMOVE', 0, '', 'STUN,SLOW,CURSE,TERROR', 0, '', 0, 0, 0, 60, 0, 0, 0, 999999, 5, 1, 184800, 92400, 540, 57, 9529, 9530, 0, 2000, 175, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 0, 70104, 0, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO mob_proto(`vnum`, `name`, `gb2312name`, `rank`, `type`, `battle_type`, `level`, `size`, `ai_flag`, `mount_capacity`, `setRaceFlag`, `setImmuneFlag`, `empire`, `folder`, `on_click`, `st`, `dx`, `ht`, `iq`, `damage_min`, `damage_max`, `max_hp`, `regen_cycle`, `regen_percent`, `gold_min`, `gold_max`, `exp`, `def`, `attack_speed`, `move_speed`, `aggressive_hp_pct`, `aggressive_sight`, `attack_range`, `drop_item`, `resurrection_vnum`, `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`, `mob_color`, `polymorph_item`, `skill_level0`, `skill_vnum0`, `skill_level1`, `skill_vnum1`, `sp_berserk`, `sp_stoneskin`, `sp_godspeed`, `sp_deathblow`, `sp_revive`)VALUES(8029, 'Metin der Zombies', 'Metin der Zombies', 5, 2, 3, 90, '', 'NOMOVE', 0, '', 'STUN,SLOW,CURSE,TERROR', 0, '', 0, 0, 0, 60, 0, 0, 0, 999999, 5, 1, 184800, 92400, 540, 57, 9529, 9530, 0, 2000, 175, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 0, 70104, 0, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO mob_proto(`vnum`, `name`, `gb2312name`, `rank`, `type`, `battle_type`, `level`, `size`, `ai_flag`, `mount_capacity`, `setRaceFlag`, `setImmuneFlag`, `empire`, `folder`, `on_click`, `st`, `dx`, `ht`, `iq`, `damage_min`, `damage_max`, `max_hp`, `regen_cycle`, `regen_percent`, `gold_min`, `gold_max`, `exp`, `def`, `attack_speed`, `move_speed`, `aggressive_hp_pct`, `aggressive_sight`, `attack_range`, `drop_item`, `resurrection_vnum`, `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`, `mob_color`, `polymorph_item`, `skill_level0`, `skill_vnum0`, `skill_level1`, `skill_vnum1`, `sp_berserk`, `sp_stoneskin`, `sp_godspeed`, `sp_deathblow`, `sp_revive`)VALUES(8033, 'Metin der Zombies', 'Metin der Zombies', 5, 2, 3, 90, '', 'NOMOVE', 0, '', 'STUN,SLOW,CURSE,TERROR', 0, '', 0, 0, 0, 60, 0, 0, 0, 999999, 5, 1, 184800, 92400, 540, 57, 9529, 9530, 0, 2000, 175, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 0, 70104, 0, 0, 0, 0, 0, 0, 0, 0, 0);

Das ist der richtige Query, und diese Fehlermeldung kommt;

Spoiler

Mensch, learn English!

Unknown column 'gb2312name' in 'field list'
Unbekannte spalte 'gb2312name' in Felder Liste
Klardeutsch: Spalte 'gb2312name' existiert nicht, du dummy.

L�sung:

Code:

INSERT INTO mob_proto(`vnum`, `name`, `[B][COLOR="Red"]locale_name[/COLOR][/B]`, `rank`, `type`, `battle_type`, `level`, `size`, `ai_flag`, `mount_capacity`, `setRaceFlag`, `setImmuneFlag`, `empire`, `folder`, `on_click`, `st`, `dx`, `ht`, `iq`, `damage_min`, `damage_max`, `max_hp`, `regen_cycle`, `regen_percent`, `gold_min`, `gold_max`, `exp`, `def`, `attack_speed`, `move_speed`, `aggressive_hp_pct`, `aggressive_sight`, `attack_range`, `drop_item`, `resurrection_vnum`, `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`, `mob_color`, `polymorph_item`, `skill_level0`, `skill_vnum0`, `skill_level1`, `skill_vnum1`, `sp_berserk`, `sp_stoneskin`, `sp_godspeed`, `sp_deathblow`, `sp_revive`)VALUES(8028, 'Metin der Zombies', 'Metin der Zombies', 5, 2, 3, 90, '', 'NOMOVE', 0, '', 'STUN,SLOW,CURSE,TERROR', 0, '', 0, 0, 0, 60, 0, 0, 0, 999999, 5, 1, 184800, 92400, 540, 57, 9529, 9530, 0, 2000, 175, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 0, 70104, 0, 0, 0, 0, 0, 0, 0, 0, 0);

siehe das Rote
Deine Spalte sollte entweder unbenannt werden in 'gb2312name' oder du passt deine QUERY an deine Tabelle an.