EQEmulator Forums - zone_flags table missing in my DB

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Support::General Support (https://www.eqemulator.org/forums/forumdisplay.php?f=598)

- - zone_flags table missing in my DB (https://www.eqemulator.org/forums/showthread.php?t=40297)

Krran

12-26-2015 08:27 PM

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?

dpjaf4t

12-28-2015 09:43 AM

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.

Krran

12-29-2015 02:48 PM

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.

Krran

12-29-2015 08:26 PM

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.

dpjaf4t

12-31-2015 10:58 AM

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.

All times are GMT -4. The time now is 09:57 AM.