Did I kill my loot tables? and how do I fix?
 

Ok... so I was working on a "black zone" problem when somehow or another I seem to have killed my loot tables !!! lol

When I start server with login (I run standalone w/ no internet) I get this message.

[MySQL Error] 1054: Unknown column 'lootdrop
_entries.minlevel' in 'field list' SELECT lootdrop.id, lootdrop_entries.item_id, lootdrop_entries.item_charges, etc etc etc and it goes on listing everything in the lootdrop_entries table in my peq folder.... the only thing I noticed is that the names its trying to load when i hit 'start server' are spelled a little different... like using an underscore when the table uses a "."

Any ideas how to fix? Ive tried to remove EQEMU and redownload, that made it worse. Then I copied my last known good copy of the EQEmu dirrectory to overwrite any odd settings I may have changed and still no good.

no clue here...

WingNutt

Looks like you updated your binaries or database without doing the other.

hmmmm how on earth do I either update both? or reinstall the old lol

Ok... uninstalled my SQL editor (Came with EQEmu) and removed EQEmu and will reinstall... see what happens. *fingers crossed*

How did you make out? Always best to do a full database backup before doing anything. You can always drop the broken database and re-source the backup.

Well the reinstall did restore it all to some kind of default for me... thats better than no loot at all hahaha so far it seems to be working well.