Go Back   EQEmulator Home > EQEmulator Forums > Support > Support::General Support

Support::General Support Post all topics here having to do with errors while trying to connect to an EQEMu server but not about the setup/running of the Server itself.

Reply
 
Thread Tools Display Modes
  #1  
Old 12-26-2015, 08:27 PM
Krran's Avatar
Krran
Sarnak
 
Join Date: Aug 2007
Location: NC, USA
Posts: 93
Default zone_flags table missing in my DB

So, I am coming back to my EQ server after 6 months-ish and I am running a setup from mid-2015. Updating to the current release did not go well, but I am fine with my current setup; updating is not a priority for my until more zones are completed.

Problem: Upon character login, I get a message saying the zone_flags table is missing and I cannot zone into places like potimeb. I am having trouble finding this table in current and past DB releases to source into my current DB. I am not sure how I even lost it, maybe in a past update attempt.

Does anyone know where this table can be found?
Reply With Quote
  #2  
Old 12-28-2015, 09:43 AM
dpjaf4t
Fire Beetle
 
Join Date: May 2010
Posts: 21
Default

This will create your zone_flags table:

Code:
CREATE TABLE `zone_flags` (
	`charID` INT(11) NOT NULL DEFAULT '0',
	`zoneID` INT(11) NOT NULL DEFAULT '0',
	PRIMARY KEY (`charID`, `zoneID`)
)
COLLATE='latin1_swedish_ci'
ENGINE=MyISAM
;
No required data in the table. Although if this table is missing, I would not be surprised if your database had other issues.
Reply With Quote
  #3  
Old 12-29-2015, 02:48 PM
Krran's Avatar
Krran
Sarnak
 
Join Date: Aug 2007
Location: NC, USA
Posts: 93
Default

Thanks!

Yes, the database has some other issues, but this one is the most crippling. I think it was preventing me from entering flagged zones (from the name).

I have been running with the same characters since early 2008 and the same bots (whenever they came out) and trying to preserve them and the things they have accumulated over the years. This has been difficult for someone who has just enough knowledge to run a server, but not enough knowledge to properly maintain or modify one.
Reply With Quote
  #4  
Old 12-29-2015, 08:26 PM
Krran's Avatar
Krran
Sarnak
 
Join Date: Aug 2007
Location: NC, USA
Posts: 93
Default

I forgot to ask, where did you find this table (short though it is)? I could not find it anywhere I looked in my backups or in new releases.
Reply With Quote
  #5  
Old 12-31-2015, 10:58 AM
dpjaf4t
Fire Beetle
 
Join Date: May 2010
Posts: 21
Default

It's in the base PEQ DB, not in any EQEMU SQL update.

You can get from there to here on keeping all the characters and bots and accumulated stuff, it's just work ... will continue with this by PM.
Reply With Quote
Reply

Tags
database, flags, login, zone

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 05:46 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