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

[WingNutt]

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

[joligario]

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

[WingNutt]

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*

[hayward6]

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.

[WingNutt]

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.