Jump to content
TrinityCore

Ataelia

Members
  • Posts

    21
  • Joined

  • Last visited

Ataelia's Achievements

Newbie

Newbie (1/14)

0

Reputation

  1. I just checked again and I don't missed any update. I also emptied my World DB and applied the updates again and I got the same error
  2. Hi everyone, I get a problem with an update for the World Trinity DB, the update is 2011_04_28_01_world_creature_equip_template Here is the content of the update ALTER TABLE `creature_equip_template` CHANGE `entry` `entry` SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL, CHANGE `equipentry1` `itemEntry1` MEDIUMINT(8) UNSIGNED DEFAULT '0' NOT NULL, CHANGE `equipentry2` `itemEntry2` MEDIUMINT(8) UNSIGNED DEFAULT '0' NOT NULL, CHANGE `equipentry3` `itemEntry3` MEDIUMINT(8) UNSIGNED DEFAULT '0' NOT NULL, ADD COLUMN `newEntry` INT UNSIGNED AUTO_INCREMENT, ADD INDEX(newEntry), DROP PRIMARY KEY; UPDATE `creature_template` ct, `creature_equip_template` cet SET ct.`equipment_id` = cet.`newEntry` WHERE ct.`equipment_id` = cet.`entry`; UPDATE `game_event_model_equip` geme, `creature_equip_template` cet SET geme.`equipment_id` = cet.`newEntry` WHERE geme.`equipment_id` = cet.`entry`; UPDATE `creature` c, `creature_equip_template` cet SET c.`equipment_id` = cet.`newEntry` WHERE c.`equipment_id` = cet.`entry`; UPDATE `creature_equip_template` SET `entry` = `newEntry`; ALTER TABLE `creature_equip_template` ADD PRIMARY KEY(`entry`), DROP COLUMN `newEntry`; So when I try to apply it to my World DB i get this error : Line no.:8 Error Code: 1054 - Unknown column 'equipentry1' in 'creature_equip_template' I have a fresh copy of the latest Trinity DB (335.11.39) and my core is in the last revision. So have I made something wrong with the updates or stuff like that ? Thanks for your future answers
×
×
  • Create New...