["unknown column" "missing table" "duplicate column" error / sql problems / SQLDriverLogFile < answer on 1st post of 1st page]

You missed a SQL update.

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

["unknown column" "missing table" "duplicate column" error / sql problems / SQLDriverLogFile < answer on 1st post of 1st page]

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