• 0
Sign in to follow this  
Legolas

en cours [En cours] Problème Objet créer

Question

J'ai utiliser WoW-Vendeta pour créer un objet et lorsque je le met dans la base de donnée Mangos,sa me met erreur :l

Share this post


Link to post
Share on other sites

10 answers to this question

Recommended Posts

  • 0

J'ai le même problèmes que Legolas et voici ce qui apparait quand je fais open error file

 

Query:

UPDATE creature_template
 SET flags_extra = flags_extra | 2 WHERE civilian <> 0

Error occured at:2009-12-16 16:44:51
Line no.:2
Error Code: 1054 - Unknown column 'civilian' in 'where clause'

Query:
ALTER TABLE `creature_template` ADD COLUMN `flags_extra` int(10) unsigned NOT NULL default '0' after `mechanic_immune_mask`

Error occured at:2009-12-16 16:45:12
Line no.:1
Error Code: 1060 - Duplicate column name 'flags_extra'

Query:
ALTER TABLE `character_pet` DROP COLUMN `Commandstate`

Error occured at:2009-12-16 16:49:08
Line no.:1
Error Code: 1091 - Can't DROP 'Commandstate'; check that column/key exists

Query:
ALTER TABLE `character_pet` DROP COLUMN `Commandstate`

Error occured at:2009-12-16 16:49:11
Line no.:1
Error Code: 1091 - Can't DROP 'Commandstate'; check that column/key exists

Query:
ALTER TABLE characters
 CHANGE `logout_time` `logout_time` bigint(20) unsigned NOT NULL default '0',
 DROP `last_honor_date`,
 DROP `last_kill_date`

Error occured at:2009-12-16 16:49:16
Line no.:4
Error Code: 1091 - Can't DROP 'last_honor_date'; check that column/key exists

Query:
ALTER TABLE characters
 ADD COLUMN death_expire_time bigint(20) unsigned NOT NULL default '0' AFTER zone

Error occured at:2009-12-16 16:49:21
Line no.:2
Error Code: 1060 - Duplicate column name 'death_expire_time'

Query:
ALTER TABLE corpse
 ADD COLUMN corpse_type tinyint(3) unsigned NOT NULL default '0' AFTER bones_flag

Error occured at:2009-12-16 16:49:47
Line no.:2
Error Code: 1054 - Unknown column 'bones_flag' in 'corpse'

Query:
ALTER TABLE corpse
 ADD KEY idx_type (corpse_type)

Error occured at:2009-12-16 16:49:55
Line no.:2
Error Code: 1061 - Duplicate key name 'idx_type'

Query:
ALTER TABLE `character_instance`
 DROP KEY `leader`,
 DROP PRIMARY KEY,
 ADD PRIMARY KEY `guid` (`guid`,`instance`),
 DROP COLUMN `map`,
 DROP COLUMN `leader`,
 MODIFY COLUMN `instance` int(11) unsigned NOT NULL default '0',
 ADD COLUMN `permanent` tinyint(1) unsigned NOT NULL default '0'

Error occured at:2009-12-16 16:50:33
Line no.:11
Error Code: 1091 - Can't DROP 'leader'; check that column/key exists

Query:
ALTER TABLE `character_instance`
 DROP KEY `leader`,
 DROP PRIMARY KEY,
 ADD PRIMARY KEY `guid` (`guid`,`instance`),
 DROP COLUMN `map`,
 DROP COLUMN `leader`,
 MODIFY COLUMN `instance` int(11) unsigned NOT NULL default '0',
 ADD COLUMN `permanent` tinyint(1) unsigned NOT NULL default '0'

Error occured at:2009-12-16 16:50:36
Line no.:11
Error Code: 1091 - Can't DROP 'leader'; check that column/key exists

Query:
ALTER TABLE `character_ticket`
 DROP `ticket_category`

Error occured at:2009-12-16 16:50:40
Line no.:2
Error Code: 1091 - Can't DROP 'ticket_category'; check that column/key exists

Query:
CREATE DATABASE `mangos` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci

Error occured at:2009-12-19 09:45:02
Line no.:3
Error Code: 1007 - Can't create database 'mangos'; database exists

Query:
CREATE DATABASE `mangos` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci

Error occured at:2009-12-19 09:45:26
Line no.:3
Error Code: 1007 - Can't create database 'mangos'; database exists

Query:
ALTER TABLE `character_pet` DROP COLUMN `Commandstate`

Error occured at:2009-12-19 16:58:08
Line no.:1
Error Code: 1091 - Can't DROP 'Commandstate'; check that column/key exists

Query:
ALTER TABLE characters
 CHANGE `logout_time` `logout_time` bigint(20) unsigned NOT NULL default '0',
 DROP `last_honor_date`,
 DROP `last_kill_date`

Error occured at:2009-12-19 16:58:13
Line no.:4
Error Code: 1091 - Can't DROP 'last_honor_date'; check that column/key exists

Query:
ALTER TABLE characters
 ADD COLUMN death_expire_time bigint(20) unsigned NOT NULL default '0' AFTER zone

Error occured at:2009-12-19 16:58:17
Line no.:2
Error Code: 1060 - Duplicate column name 'death_expire_time'

Query:
ALTER TABLE corpse
 ADD COLUMN corpse_type tinyint(3) unsigned NOT NULL default '0' AFTER bones_flag

Error occured at:2009-12-19 16:58:40
Line no.:2
Error Code: 1054 - Unknown column 'bones_flag' in 'corpse'

Query:
ALTER TABLE corpse
 ADD KEY idx_type (corpse_type)

Error occured at:2009-12-19 16:58:43
Line no.:2
Error Code: 1061 - Duplicate key name 'idx_type'

Query:
ALTER TABLE `character_instance`
 DROP KEY `leader`,
 DROP PRIMARY KEY,
 ADD PRIMARY KEY `guid` (`guid`,`instance`),
 DROP COLUMN `map`,
 DROP COLUMN `leader`,
 MODIFY COLUMN `instance` int(11) unsigned NOT NULL default '0',
 ADD COLUMN `permanent` tinyint(1) unsigned NOT NULL default '0'

Error occured at:2009-12-19 16:59:09
Line no.:11
Error Code: 1091 - Can't DROP 'leader'; check that column/key exists

Query:
ALTER TABLE `character_ticket`
 DROP `ticket_category`

Error occured at:2009-12-19 16:59:14
Line no.:2
Error Code: 1091 - Can't DROP 'ticket_category'; check that column/key exists

Query:
INSERT INTO items (entry, class, subclass, field4, name1, 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, 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, ReqDisenchantSkill, unk2, itemstatscount)
VALUES (47513, 2, 7, -1, "friendly", "friendly", "friendly", "friendly", 60674, 6, 0, 1.0E+19, 1.0E+19, 13, -1, -1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0,  1, 99999,  12, 99999,  41, 99999,  6, 99999,  3, 99999,  1, 99999,  1, 99999,  1, 99999,  1, 99999,  1, 99999, 9999999999, 9999999999, 0, 9999999999, 9999999999, 2, 99999999, 99999999, 99999999, 99999999, 99999999, 99999999, 99999999, 00000000, 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, 18060, 1, 0, 0, 0, 0, 0, "", 0, 0, 0, 0, 0, 1, 3, 0, 0, 99999999, 0, 99999999, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10)

Error occured at:2009-12-20 16:02:57
Line no.:2
Error Code: 1146 - Table 'mangos.items' doesn't exist

Query:
INSERT INTO items (entry, class, subclass, field4, name1, 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, 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, ReqDisenchantSkill, unk2, itemstatscount)
VALUES (47513, 2, 7, -1, "friendly", "friendly", "friendly", "friendly", 60674, 6, 0, 1.0E+19, 1.0E+19, 13, -1, -1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0,  1, 99999,  12, 99999,  41, 99999,  6, 99999,  3, 99999,  1, 99999,  1, 99999,  1, 99999,  1, 99999,  1, 99999, 9999999999, 9999999999, 0, 9999999999, 9999999999, 2, 99999999, 99999999, 99999999, 99999999, 99999999, 99999999, 99999999, 00000000, 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, 18060, 1, 0, 0, 0, 0, 0, "", 0, 0, 0, 0, 0, 1, 3, 0, 0, 99999999, 0, 99999999, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10)

Error occured at:2009-12-20 16:03:27
Line no.:2
Error Code: 1146 - Table 'mangos.items' doesn't exist

Query:
INSERT INTO item_template (entry, class, subclass, unk0, name, displayid, Quality, Flags, BuyCount, BuyPrice, SellPrice, InventoryType, AllowableClass, AllowableRace, ItemLevel, RequiredLevel, RequiredSkill, RequiredSkillRank, requiredspell, requiredhonorrank, RequiredCityRank, RequiredReputationFaction, RequiredReputationRank, maxcount, stackable, 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, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, RangedModRange, 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, PageText, LanguageID, PageMaterial, startquest, lockid, Material, sheath, RandomProperty, RandomSuffix, block, itemset, MaxDurability, area, Map, BagFamily, TotemCategory, socketColor_1, socketContent_1, socketColor_2, socketContent_2, socketColor_3, socketContent_3, socketBonus, GemProperties, RequiredDisenchantSkill, ArmorDamageModifier, ScriptName, DisenchantID, StatsCount)
VALUES (123456789, 2, 0, -1, "friendly", 28295, 6, 0, 0, 1.0000000001E+13, 1.00000000001E+14, 26, -1, -1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0,  1, 99999,  1, 99999,  1, 99999,  1, 99999,  1, 99999,  1, 99999,  1, 99999,  1, 99999,  1, 99999,  1, 99999, 9999999999, 9999999999, 0, 9999999999, 9999999999, 5, 99999999, 99999999, 99999999, 99999999, 99999999, 99999999, 99999999, 0000, 0, 100, 18060, 1, 0, 0, 0, 0, 34696, 2, 0, 0, 0, 0, 14052, 1, 0, 0, 0, 0, 24585, 2, 0, 0, 0, 0, 18084, 2, 0, 0, 0, 0, 0, "", 0, 0, 0, 0, 0, 1, 3, 0, 0, 99999999, 0, 99999999, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'internalitemhanler', 0, 10)

Error occured at:2009-12-22 14:59:27
Line no.:2
Error Code: 1054 - Unknown column 'StatsCount' in 'field list'

Query:
INSERT INTO item_template (entry, class, subclass, unk0, name, displayid, Quality, Flags, BuyCount, BuyPrice, SellPrice, InventoryType, AllowableClass, AllowableRace, ItemLevel, RequiredLevel, RequiredSkill, RequiredSkillRank, requiredspell, requiredhonorrank, RequiredCityRank, RequiredReputationFaction, RequiredReputationRank, maxcount, stackable, 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, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, RangedModRange, 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, PageText, LanguageID, PageMaterial, startquest, lockid, Material, sheath, RandomProperty, RandomSuffix, block, itemset, MaxDurability, area, Map, BagFamily, TotemCategory, socketColor_1, socketContent_1, socketColor_2, socketContent_2, socketColor_3, socketContent_3, socketBonus, GemProperties, RequiredDisenchantSkill, ArmorDamageModifier, ScriptName, DisenchantID, StatsCount)
VALUES (123456789, 2, 0, -1, "friendly", 28295, 6, 0, 0, 1.0000000001E+13, 1.00000000001E+14, 26, -1, -1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0,  1, 99999,  1, 99999,  1, 99999,  1, 99999,  1, 99999,  1, 99999,  1, 99999,  1, 99999,  1, 99999,  1, 99999, 9999999999, 9999999999, 0, 9999999999, 9999999999, 5, 99999999, 99999999, 99999999, 99999999, 99999999, 99999999, 99999999, 0000, 0, 100, 18060, 1, 0, 0, 0, 0, 34696, 2, 0, 0, 0, 0, 14052, 1, 0, 0, 0, 0, 24585, 2, 0, 0, 0, 0, 18084, 2, 0, 0, 0, 0, 0, "", 0, 0, 0, 0, 0, 1, 3, 0, 0, 99999999, 0, 99999999, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'internalitemhanler', 0, 10)

Error occured at:2009-12-22 23:53:00
Line no.:2
Error Code: 1054 - Unknown column 'StatsCount' in 'field list'

Share this post


Link to post
Share on other sites
  • 0

Okay ! En faite, WoW-V adapte leurs scripts aux dernières versions des bases de données, et la base de données que vous utilisez (en 2.4.3) n'est pas la même que celle pour les version 3.2.2a.

 

Est-ce que tu pourrais me donner le fichier SQL (une fois l'objet créé sur WoW-V) stp ?

 

Merci ! :)

Share this post


Link to post
Share on other sites
  • 0

Oui, je vous conseil de créer vos items via WoW-Vendetta si votre Serveur est dans la dernière version. Autrement, soit vous devez les adapter, soit vous devez les faire directement via PhpMyAdmin, SQLyog, ou Quice.

 

Je déplace ! ;)

Share this post


Link to post
Share on other sites
Sign in to follow this