|
You last visited: Today at 05:14
Advertisement
Query fail'd -> Hilfe dringend benötigt!
Discussion on Query fail'd -> Hilfe dringend benötigt! within the Metin2 Private Server forum part of the Metin2 category.
05/14/2011, 10:53
|
#1
|
elite*gold: 0 
Join Date: Dec 2010
Posts: 508
Received Thanks: 275
|
Query fail'd -> Hilfe dringend benötigt!
Guuten Morgen,
ja, ich versuche schon seit Stunden diese scheiß Metins in die
DB reinzubekommen -> jedoch ohne Erfolg.
Der Query fail'd immer.
[SQL] SELECT * FROM `mob_proto`;
Affected rows: 0
Time: 0.148ms
[SQL]
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);
[Err] 1054 - Unknown column 'gb2312name' in 'field list'
Bräuchte mal dringend eure Hilfe.
Gz.
|
|
|
|
05/14/2011, 11:05
|
#2
|
elite*gold: 0
Join Date: May 2009
Posts: 7,902
Received Thanks: 2,151
|
sehr komische Query o0
INSERT INTO mob_proto (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);
Dies sind die entscheidenden Punkten.
Wozu sind die einzelnen Spalten der mob_proto in der Query o0 ?
|
|
|
|
|
05/14/2011, 11:11
|
#3
|
elite*gold: 0
Join Date: Dec 2010
Posts: 508
Received Thanks: 275
|
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;
[SQL] SELECT * FROM `mob_proto`;
Affected rows: 0
Time: 0.148ms
[SQL]
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);
[Err] 1054 - Unknown column 'gb2312name' in 'field list'
|
|
|
|
|
05/14/2011, 12:19
|
#4
|
elite*gold: 1862
Join Date: Jan 2009
Posts: 3,725
Received Thanks: 7,671
|
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.
|
|
|
|
|
05/14/2011, 12:41
|
#5
|
elite*gold: 0
Join Date: Dec 2010
Posts: 508
Received Thanks: 275
|
Gutgut, dass ich das übersehen hab! ;x
Mein Englisch ist sowieso nicht das beste, u know?
Aber danke, hat geklappt.
Kann geclosed werden!
|
|
|
|
 |
Similar Threads
|
Dringend Hilfe benötigt :O
03/06/2011 - Flyff - 0 Replies
PUSH!
ERLEDIGT x3
|
dringend hilfe benötigt -.-
12/21/2010 - WarRock - 7 Replies
hi erstma also hab warrock gezockt gansnormal im gegnerteam war ein hacker (eig nix besonderes)
er wurde gekickt aber nach dem spiel hingen wir alle noch in room fest hab versucht mit Esc rauszukommen und 10 min gewartet ging aber nix
dan bin ich mit Alt+F4 aus dem spiel, als ich mich wieder einloggen wollte stand da(berreits eingeloggt)
hab rechner schon runtergef. warrock neu instal. und mein passwort geendert weil ich gedacht hab das der mein pass wort irgendwie hatt also der hacker ...
|
[HELP] Dringend Hilfe benötigt !
01/17/2010 - Metin2 Private Server - 5 Replies
Hi Leute,
ich möchte auch mal einen eigenen Hamachiserver erstellen.
Habe aber noch ein paar fragen.
Ich bin sozusagen "Newcomer" in dem Bereich, habe es schon einmal versucht aber nicht hinbekommen, und jetzt will ich es erneut probieren.
Also:
Welche Serverfiles sind besser, die normalen oder die Instant ?
Was mache ich mit folgenden Programmen ?
1. )Virtual PC 2007
|
dringend hilfe benötigt
04/23/2009 - Metin2 Private Server - 4 Replies
meine abbyfinreader testversion ist zuende und jezt kan ich mir kein vipmt2 acc machen könnte mir vll einer machen würd ein dickes fettes thx kriegen plsss
|
Dringend Hilfe benötigt !
09/17/2007 - Technical Support - 0 Replies
Hallo ,
tut mir leid , dass ich die sufu nicht benutzt habe , aber ich habe ein Problem .
Mein antivir entdeckt seit neustem einen Virus im Windows ordner , der wie ich denke meinen Pc von Minute zu minute langsamer macht . Mein tastatur reagiert nur noch 5 sek später , system prüfungen kann ich nicht mehr starten , dann bleibt der pc hängen . Mozilla firefox startet auch sehr langsam ...
Danke für die hilfe
|
All times are GMT +2. The time now is 05:14.
|
|
