Jump to content
×
×
  • Create New...
  • 0

[En cours] Problème Objet créer


Legolas

Question

  • Answers 10
  • Created
  • Last Reply

Top Posters For This Question

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'

:D"peace and love":P

Link to comment
  • 0
  • Retraité

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 ! :)

Link to comment


Important Information

Terms of Use / Privacy Policy / Guidelines / We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.