MaNGOS TBC Sql

[Sammyboy]

Hi,
i have downloaded the Mangos TBC package, it says it has all i need in it. Its filename is "MaNGOS v2.0.1 Inc Maps DBCs SQLs.rar" but after setting it all up the SQL files dont work i get an error message about "item_template".
I got told the SQL db wasnt the right one, does any one have a link to a working DB for me please
Thanks

[MentaL]

[Sammyboy]

_bump_ :)

[EvilRyu]

Can you take a screenshot of the error, or post what the server log says please.

[runnam]

blah

[Sammyboy]

Here is ther Server Log:

2007-01-22 21:50:57 Using configuration file mangosd.conf.
2007-01-22 21:50:57 MaNGOS daemon /0.6-SVN (Win32)
2007-01-22 21:50:57 <Ctrl-C> to stop.

MM   MM         MM   MM  MMMMM   MMMM   MMMMM
MM   MM         MM   MM MMM MMM MM  MM MMM MMM
MMM MMM         MMM  MM MMM MMM MM  MM MMM
MM M MM         MMMM MM MMM     MM  MM  MMM
MM M MM  MMMMM  MM MMMM MMM     MM  MM   MMM
MM M MM M   MMM MM  MMM MMMMMMM MM  MM    MMM
MM   MM     MMM MM   MM MM  MMM MM  MM     MMM
MM   MM MMMMMMM MM   MM MMM MMM MM  MM MMM MMM
MM   MM MM  MMM MM   MM  MMMMMM  MMMM   MMMMM
        MM  MMM MaNGOS project discussion forums (Powered by Invision Power Board)
        MMMMMM

2007-01-22 21:50:57 World Database: ******;****;****;*****;mangos
2007-01-22 21:50:57 Login Database: ******;****;****;*****;realmd
2007-01-22 21:50:57 Realm running as realm ID 1
2007-01-22 21:50:57 Using DataDir ./ ...
2007-01-22 21:50:57 Initialize data stores...
2007-01-22 21:50:58 
2007-01-22 21:50:58 >> Loaded 28 data stores
2007-01-22 21:50:58 
2007-01-22 21:50:58 Loading Game Object Templates...
2007-01-22 21:50:58 
2007-01-22 21:50:58 >> Loaded 3688 game object templates
2007-01-22 21:50:58 Loading player create info & level stats...
2007-01-22 21:50:58 
2007-01-22 21:50:58 >> Loaded 40 player create definitions
2007-01-22 21:50:58 
2007-01-22 21:50:58 >> Loaded 294 player create items
2007-01-22 21:50:58 
2007-01-22 21:50:58 >> Loaded 837 player create spells
2007-01-22 21:50:58 
2007-01-22 21:50:58 >> Loaded 497 player create skills
2007-01-22 21:50:58 
2007-01-22 21:50:58 >> Loaded 192 player create actions
2007-01-22 21:50:58 
2007-01-22 21:50:58 >> Loaded 2400 level stats definitions
2007-01-22 21:50:58 Loading Quests...
2007-01-22 21:50:59 
2007-01-22 21:50:59 >> Loaded 4042 quests definitions
2007-01-22 21:50:59 Loading Spell Chain Data...
2007-01-22 21:50:59 
2007-01-22 21:50:59 >> Loaded 1329 spell chain records
2007-01-22 21:50:59 Loading Scripts...
2007-01-22 21:50:59 
2007-01-22 21:50:59 >> Loaded 14 script definitions
2007-01-22 21:50:59 Loading NPC Texts...
2007-01-22 21:51:00 
2007-01-22 21:51:00 >> Loaded 2663 npc texts
2007-01-22 21:51:00 Loading Quest Area Triggers...
2007-01-22 21:51:00 
2007-01-22 21:51:00 >> Loaded 14 quest trigger points
2007-01-22 21:51:00 Loading Items...
2007-01-22 21:51:01 ERROR:Error in `item_template` table, probably sql file format was updated (there should be 119 fields in sql).

[EvilRyu]

Yup, you are correct.
The tbc sdb you are using must have been build with a glitch in it, if you look at the mangos release thread "stickies" you can download the newest ones.

Either that, or rebuild the sdb you are using via sqlyog, and import any updates it comes with it in an sql folder.