zone_flags table missing in my DB

[Krran]

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]

This will create your zone_flags table:

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]

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]

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]

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.