Loot Table Error with MaNGOS

[NetBlues]

The server runs just fine even with this error, but of course there aren't any drops except coins. I attempted to update loot_template.sql [using SQLyog] with the all of the versions I found in the SDB update I just downloaded, but every attempt received an error stating the table doesn't exist.

I'm running a MaNGOS installation that has been updated from 2619 to 2652 and I can't seem to shake this problem. Here's the output:

2006-12-19 02:49:53 Loading Loot Tables...
2006-12-19 02:49:53 creature_loot_template :
2006-12-19 02:49:53 ERROR:SQL: SELECT `entry`, `item`, `chance`, `questchance`, `maxcount`, `quest_freeforall` FROM `creature_loot_template`
2006-12-19 02:49:53 ERROR:query ERROR: Unknown column 'chance' in 'field list'
2006-12-19 02:49:53 ERROR:>> Loaded 0 loot definitions. DB table `creature_loot_template` is empty.
2006-12-19 02:49:53 fishing_loot_template :
2006-12-19 02:49:53 ERROR:SQL: SELECT `entry`, `item`, `chance`, `questchance`, `maxcount`, `quest_freeforall` FROM `fishing_loot_template`
2006-12-19 02:49:53 ERROR:query ERROR: Unknown column 'chance' in 'field list'
2006-12-19 02:49:53 ERROR:>> Loaded 0 loot definitions. DB table `fishing_loot_template` is empty.
2006-12-19 02:49:53 gameobject_loot_template :
2006-12-19 02:49:53 ERROR:SQL: SELECT `entry`, `item`, `chance`, `questchance`, `maxcount`, `quest_freeforall` FROM `gameobject_loot_template`
2006-12-19 02:49:53 ERROR:query ERROR: Unknown column 'chance' in 'field list'
2006-12-19 02:49:53 ERROR:>> Loaded 0 loot definitions. DB table `gameobject_loot_template` is empty.
2006-12-19 02:49:53 item_loot_template :
2006-12-19 02:49:53 ERROR:SQL: SELECT `entry`, `item`, `chance`, `questchance`, `maxcount`, `quest_freeforall` FROM `item_loot_template`
2006-12-19 02:49:53 ERROR:query ERROR: Unknown column 'chance' in 'field list'
2006-12-19 02:49:53 ERROR:>> Loaded 0 loot definitions. DB table `item_loot_template` is empty.
2006-12-19 02:49:53 pickpocketing_loot_template :
2006-12-19 02:49:53 ERROR:SQL: SELECT `entry`, `item`, `chance`, `questchance`, `maxcount`, `quest_freeforall` FROM `pickpocketing_loot_template`
2006-12-19 02:49:53 ERROR:query ERROR: Unknown column 'chance' in 'field list'
2006-12-19 02:49:53 ERROR:>> Loaded 0 loot definitions. DB table `pickpocketing_loot_template` is empty.
2006-12-19 02:49:53 skinning_loot_template :
2006-12-19 02:49:53 ERROR:SQL: SELECT `entry`, `item`, `chance`, `questchance`, `maxcount`, `quest_freeforall` FROM `skinning_loot_template`
2006-12-19 02:49:53 ERROR:query ERROR: Unknown column 'chance' in 'field list'
2006-12-19 02:49:53 ERROR:>> Loaded 0 loot definitions. DB table `skinning_loot_template` is empty.
2006-12-19 02:49:53 ERROR:SQL: SELECT `item`, `item2` FROM `skinning_loot_template_alternative`
2006-12-19 02:49:53 ERROR:query ERROR: Table 'mangos.skinning_loot_template_alternative' doesn't exist

[MentaL]

[Jigsaw]

You're not using the correct loot_template for that revision; What revision you using?

[wedtm]

Let me kindly refer you to this thread, it will solve your problem:
http://forum.ragezone.com/world-warc...os-201572.html

[NetBlues]

Here's the error I received through SQLyog when attempting to update file:

Query:
ALTER TABLE `creature_loot_template`  
ADD `maxcount` int(11) unsigned NOT NULL default '1'

Error occured at:2006-12-19 03:36:23
Line no.:2
Error Code: 1060 - Duplicate column name 'maxcount'

[NetBlues]

Alright, well I'm now running the latest build of both SDB and MaNGOS. Tell me how to fix this:

2006-12-19 03:46:42 Loading Quests...
2006-12-19 03:46:42 ERROR:Error opening quest_template table.

And I'm still unable to update the SQL, I get an error for practically every .sql file I try to throw in.