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

[En cours] Problème Objet créer


Legolas
 Share

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
Share on other sites

  • 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
Share on other sites

 Share



  • Flux d'Activité

    1. 0

      Projet Oceania Pasifika

    2. 0

      Présentation Barbossa

    3. 3

      I18N Editor ( C# D2I Editor )

    4. 0

      Recherche un développeur pour compléter notre team pour un projet INTER

    5. 21

      Partage Populus 2.51

    6. 4

      KraizyReworked

    7. 0

      wsl2 and systemd

    8. 1

      Need Help pour WPE PRO/FAILLE - Recherche personne qualifié & rémunération.

    9. 1

      Need Help pour WPE PRO/FAILLE - Recherche personne qualifié & rémunération.

  • Recently Browsing

    • No registered users viewing this page.

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.