Jump to content

Please help with Mangos DB error


Recommended Posts

After runnings mangos.exe and then viewing my DB error file i am presented with this:

2010-12-20 00:46:47 Spell (id: 33824) have SPELL_EFFECT_QUEST_COMPLETE for quest 10162 , but quest does not have SpecialFlags QUEST_SPECIAL_FLAG_EXPLORATION_OR_EVENT (2) set. Quest SpecialFlags should be corrected to enable this objective.
2010-12-20 00:47:02 SQL: SELECT entry, spell,spellcost,reqskill,reqskillvalue,reqlevel FROM npc_trainer_template
2010-12-20 00:47:02 query ERROR: Unknown column 'spell' in 'field list'
2010-12-20 00:47:02 >> Loaded `npc_trainer_template`, table is empty!

If you can supply a solution for this It would be greatly appreciated. :)

Link to comment
Share on other sites

Look like you have DB strcuture not compatible with mangos. I don't known how you can have recently added

`npc_trainer_template` without this field. You can re-apply 10867_01_mangos_npc_trainer_template.sql (with removed first guard line) as quick fix. But must attempt understand source of problem for future, because it from some your side wrong data...

Link to comment
Share on other sites

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. Privacy Policy Terms of Use