Neue Items batchen

03/31/2008 00:55 Illidan1988#1
Moin zusammen,

ich hab mich mal auf der Vendetta Page umgeschaut und mir nen paar sets geladen. Nunja einige gingen. Bei den meisten kommt immer sonen kram:

[Err] 1054 - Unknown column 'name' in 'field list'
[Err] INSERT INTO items (entry, class, subclass, field4, name, name2, name3, name4, displayid, quality, flags, buyprice, sellprice, inventorytype, allowableclass, allowablerace, itemlevel, requiredlevel, RequiredSkill, RequiredSkillRank, RequiredSkillSubRank, RequiredPlayerRank1, RequiredPlayerRank2, RequiredFaction, RequiredFactionStanding, `Unique`, maxcount, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, `range`, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, page_id, page_language, page_material, quest_id, lock_id, lock_material, sheathID, randomprop, unk203_1, block, itemset, MaxDurability, ZoneNameID, mapid, bagfamily, TotemCategory, socket_color_1, unk201_3, socket_color_2, unk201_5, socket_color_3, unk201_7, socket_bonus, GemProperties, ItemExtendedCost, ReqDisenchantSkill, unk2)
VALUES (200000,4,1,-1,"Helm of The Gods","Helm of The Gods","Helm of The Gods","Helm of The Gods",44050,6,0,10000000,5000000,1,-1,-1,999,80,0,0,0,0,0,0,0,0,1,0,3,10000,4,10000,5,100 00,6,10000,7,10000,7,10000,7,10000,19,10000,16,100 00,16,10000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,100000,1 0000000,10000000,10000000,10000000,10000000,100000 00,0,0,0,18060,1,0,0,0,0,18060,1,0,0,0,0,18060,1,0 ,0,0,0,18060,1,0,0,0,0,17713,1,0,0,0,0,0,"The Best Of the Best",0,0,0,0,0,6,0,0,0,0,0,99999999,0,0,0,0,2,0,4 ,0,8,0,1585,0,0,0,0);
[Msg] Finished - Unsuccessfully

Kann mir da jemand sagen was da falsch läuft oder gar nicht läuft^^

MFG

(Versuche das auf nen Ascent 4.0 Stable zu batchen)
03/31/2008 14:19 Gordge#2
du kopierst aus dem falschen anzeige fenster... das obere ist für Ascent das untere für Antrix, demnach sind die Datenbanken anders zusammen gebaut was dann dazu führt das dein SQL Statement nicht zu den Tables passt.