koe

I put alll updates manual from the world floder in a seperate sql file and now works. These are the new errors : 2012-04-25 01:40:32 ERROR: Table 'gameobject_loot_template' entry 27985 (gameobject entry) does not exist but used as loot id in DB. 2012-04-25 01:40:32 ERROR: Table 'gameobject_loot_template' entry 28057 (gameobject entry) does not exist but used as loot id in DB. 2012-04-25 01:40:32 ERROR: Table 'gameobject_loot_template' entry 28072 (gameobject entry) does not exist but used as loot id in DB. 2012-04-25 01:40:32 ERROR: Table 'gameobject_loot_template' entry 28090 (gameobject entry) does not exist but used as loot id in DB. 2012-04-25 01:40:32 ERROR: Table 'gameobject_loot_template' entry 28057 (gameobject entry) does not exist but used as loot id in DB. 2012-04-25 01:40:32 ERROR: Table 'gameobject_loot_template' entry 28090 (gameobject entry) does not exist but used as loot id in DB. 2012-04-25 01:40:32 ERROR: Table 'gameobject_loot_template' entry 28072 (gameobject entry) does not exist but used as loot id in DB. 2012-04-25 01:40:32 ERROR: Table 'gameobject_loot_template' entry 27985 (gameobject entry) does not exist but used as loot id in DB. 2012-04-25 01:40:32 ERROR: Table 'gameobject_loot_template' entry 27993 (gameobject entry) does not exist but used as loot id in DB. 2012-04-25 01:40:32 ERROR: Table 'gameobject_loot_template' entry 27993 (gameobject entry) does not exist but used as loot id in DB. 2012-04-25 01:40:32 ERROR: Table 'gameobject_loot_template' entry 28683 (gameobject entry) does not exist but used as loot id in DB. 2012-04-25 01:40:34 ERROR: SourceEntry 46485 SourceGroup 1 in `condition` table - spell 46485 does not have implicit targets of types: _AREA_, _CONE_, _NEARBY_ for effect 0, SourceGroup needs correction, ignoring. 2012-04-25 01:40:34 ERROR: SourceEntry 46485 SourceGroup 1 in `condition` table - spell 46485 does not have implicit targets of types: _AREA_, _CONE_, _NEARBY_ for effect 0, SourceGroup needs correction, ignoring. 2012-04-25 01:40:35 ERROR: SmartAIMgr::LoadSmartAIFromDB: GameObject entry (25814) does not exist, skipped loading. TrinityCore rev. 2012-04-24 13:39:37 -0400 (e6a6f6539d59)

TDB_fuul_33.11.46_2012_02_13.sql -> FullDatabase Then uptade the SQL files from "update/world" floder step by step SQL-Patch Error on Table : 2012_02_24_00_world_gameobject_loot_template.sql SQLogy ErrorFile : Query: INSERT INTO `reference_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`lootmode`,`groupid`,`mincountOrRef`,`maxcount`) VALUES (28058,49908,20,1,0,1,1), -- Primordial Saronite 10H (28074,49908,20,1,0,1,1), -- Primordial Saronite 25N (28088,49908,20,1,0,1,1), -- Primordial Saronite 25H (28064,49908,20,1,0,1,1), -- Primordial Saronite 10H (28082,49908,20,1,0,1,1), -- Primordial Saronite 25N (28096,49908,20,1,0,1,1) Error occured at:2012-04-24 23:24:26 Line no.:10 Error Code: 1062 - Duplicate entry '28058-49908' for key 'PRIMARY' Mfg Koe 2012_04_18_00_world_npc_spellclick_spells.sql Query: UPDATE `npc_spellclick_spells` SET `quest_end`=11999 WHERE `npc_entry`=26477 AND `spell_id`=61832 AND `quest_start`=11999 Error occured at:2012-04-24 23:42:04 Line no.:15589 Error Code: 1054 - Unknown column 'quest_start' in 'where clause'