AlexDark

I checked the version table which says: TrinityCore rev. 2013-01-14 12:00:00 -0000 (45363b8216f03f2) (Win64, Debug), meaning I have to import ALL the files in the update folder (all of them are older then 2013-01-14). I merged them with the basic command (cmd > type *.sql > update.sql), so obviously i didn't missed the SQL you mentioned. The files also have been merged in correct date order, so I'm not sure what else I have to do... Is there some batch there that I can use? I haven't seen any batch in the source

Hi all, I've been looking around for solutions (yes, i did use the Search button ) but can't find a simple way to have this fixed: I've recently imported the latest TDB release (TDB_full_335.51_2013_02_14.sql). After that I merged all the updates into one single SQL file, but i get the error below: Query: UPDATE `creature_template` SET `equipment_id` = 0 WHERE `name` LIKE '%(1)' OR `name` LIKE '%(2)' OR `name` LIKE '%(3)' OR `name` LIKE '%(4)' Error occured at:2013-06-29 23:37:05 Line no.:102 Error Code: 1054 - Unknown column 'equipment_id' in 'field list' Query: UPDATE `creature_template` SET `equipment_id` = 0 WHERE `name` LIKE '%(1)' OR `name` LIKE '%(2)' OR `name` LIKE '%(3)' OR `name` LIKE '%(4)' Error occured at:2013-06-29 23:39:43 Line no.:14461 Error Code: 1054 - Unknown column 'equipment_id' in 'field list' Query: UPDATE `creature_template` SET `equipment_id` = 0 WHERE `name` LIKE '%(1)' OR `name` LIKE '%(2)' OR `name` LIKE '%(3)' OR `name` LIKE '%(4)' Error occured at:2013-06-29 23:44:25 Line no.:14461 Error Code: 1054 - Unknown column 'equipment_id' in 'field list' Query: UPDATE `creature_template` SET `equipment_id` = 0 WHERE `name` LIKE '%(1)' OR `name` LIKE '%(2)' OR `name` LIKE '%(3)' OR `name` LIKE '%(4)' Error occured at:2013-06-29 23:44:38 Line no.:102 Error Code: 1054 - Unknown column 'equipment_id' in 'field list' Query: UPDATE `creature_template` SET `equipment_id` = 0 WHERE `name` LIKE '%(1)' OR `name` LIKE '%(2)' OR `name` LIKE '%(3)' OR `name` LIKE '%(4)' Error occured at:2013-06-29 23:44:53 Line no.:102 Error Code: 1054 - Unknown column 'equipment_id' in 'field list' Query: DELETE FROM `playercreateinfo_spell` WHERE `race`=10 AND `Spell`=61437 Error occured at:2013-06-29 23:46:17 Line no.:724 Error Code: 1054 - Unknown column 'race' in 'where clause' Query: UPDATE `creature_template` SET `equipment_id` = 0 WHERE `name` LIKE '%(1)' OR `name` LIKE '%(2)' OR `name` LIKE '%(3)' OR `name` LIKE '%(4)' Error occured at:2013-06-30 12:54:04 Line no.:8035 Error Code: 1054 - Unknown column 'equipment_id' in 'field list' Query: INSERT INTO `playercreateinfo_spell` (`race`,`class`,`Spell`,`Note`) VALUES (10,2,61437, 'Opening'), (10,3,61437, 'Opening'), (10,4,61437, 'Opening'), (10,5,61437, 'Opening'), (10,6,61437, 'Opening'), (10,8,61437, 'Opening'), (10,9,61437, 'Opening') Error occured at:2013-06-30 12:57:12 Line no.:732 Error Code: 1054 - Unknown column 'class' in 'field list' Query: UPDATE `creature_template` SET `equipment_id` = 0 WHERE `name` LIKE '%(1)' OR `name` LIKE '%(2)' OR `name` LIKE '%(3)' OR `name` LIKE '%(4)' Error occured at:2013-06-30 13:08:17 Line no.:102 Error Code: 1054 - Unknown column 'equipment_id' in 'field list' Query: UPDATE `creature_template` SET `equipment_id` = 0 WHERE `name` LIKE '%(1)' OR `name` LIKE '%(2)' OR `name` LIKE '%(3)' OR `name` LIKE '%(4)' Error occured at:2013-06-30 13:18:07 Line no.:14461 Error Code: 1054 - Unknown column 'equipment_id' in 'field list' It seems as one of the updates deletes the "equipment_id" column and after it tries to add some data again to the same. I know the solution for this is running the updates one by one and paying attention to the one that fails... but i'm wondering if there is any fix released for this already? Extra Info OS: Windows 7 Ultimate x64 RAM: 8GB Processor: Quad Core Q8300 @ 2,5GHz TrinityCore release: b3bdcc6 (updated today 30/06/2013) TDB release: TDB_full_335.51_2013_02_14 MySQL Version: 5.5. SQLyog v11.13 CMake 2.8 GitExtensions 2.44