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

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)

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

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'