Loot Table Error with MaNGOS
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:
Code:
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