Go Back   EQEmulator Home > EQEmulator Forums > Support > Support::Windows Servers

Support::Windows Servers Support forum for Windows EQEMu users.

Reply
 
Thread Tools Display Modes
  #1  
Old 10-21-2020, 07:36 PM
WingNutt
Fire Beetle
 
Join Date: Dec 2019
Posts: 19
Default 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
Reply With Quote
  #2  
Old 10-21-2020, 07:47 PM
joligario's Avatar
joligario
Developer
 
Join Date: Mar 2003
Posts: 1,490
Default

Looks like you updated your binaries or database without doing the other.
Reply With Quote
  #3  
Old 10-21-2020, 07:52 PM
WingNutt
Fire Beetle
 
Join Date: Dec 2019
Posts: 19
Default

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*
Reply With Quote
  #4  
Old 11-02-2020, 05:53 PM
hayward6
Forum Guide
 
Join Date: Jul 2005
Posts: 468
Default

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.
__________________
Sayin Silverwolf
Server Op of The Sandbox (Non-Legit)
Reply With Quote
  #5  
Old 11-03-2020, 11:45 PM
WingNutt
Fire Beetle
 
Join Date: Dec 2019
Posts: 19
Default

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.
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 03:26 PM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3