EQEmulator Forums - World.exe : Zone not found in database..

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

- Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)

- - World.exe : Zone not found in database.. (https://www.eqemulator.org/forums/showthread.php?t=26778)

Irreverent

11-15-2008 11:29 AM

World.exe : Zone not found in database..

I just did the updates to 166, but no one can get to a zone. It says zone not found, sending to arena...but then it can't find that either.

Any help please!

Irreverent

11-15-2008 11:31 AM

Nevermind, see what happens when you do something by hand...

silly custom tables..

Missed goallists...

Irreverent

11-15-2008 11:34 AM

Nevermind...that didn't work either. But don't see any other error logs...

zone table does have the new fields insttype and shutdowndelay

Irreverent

11-15-2008 12:07 PM

Figured out what to do, reading more in forums..found the /util stuff in the read only directory...not easy! :)

Irreverent

11-15-2008 12:14 PM

Well, got into the game in the arena...but tried to zone to PoK and the zone shut down...

log has

"activity for non-existant task (12, 1) while loading activities..."

looking at the activities table, there is duplicate tasks for 12? Going to try to delete those rows.

Irreverent

11-15-2008 12:49 PM

Ok, I'm at a loss.

I can load up most zones, but a zone like PoK crashes...

I'm guessing its the task system? Was there a task master in PoK?

Angelox

11-15-2008 01:18 PM

Quote:

Originally Posted by Irreverent (Post 160017)

Looks like you may not have some tables up to date - remember, if you restored characters from an old backup before you ran these;

Code:

ALTER table character_ ADD column `instZflagNum` int(10) unsigned NOT NULL default '0';

ALTER table character_ ADD column `instZOrgID` int(11) NOT NULL default '0';

ALTER TABLE `character_` ADD `lfp` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0';

ALTER TABLE `character_` ADD `lfg` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0';

Things like getting sent to Arena on login will happen (if you get in at all).
Run the lines again (after restore), just incase.

Irreverent

11-15-2008 02:39 PM

I have those done...I can get into other zones...just not PoK for some reason. :(

Might be other zones as well that have the issue.

I did have to upgrade my perl too with this latest verion...so now I have two perl versions installed. Does that cause any problems or do they overlay?

trevius

11-16-2008 05:40 AM

Might wanna try deleting your task related tables and then rerunning the SQL for them again. Make sure you have ran all of the sql files in the /utils/sql/svn directory.

Irreverent

11-16-2008 08:03 PM

Just started from scratch, had notes of all the custom things i did...and it worked. Now finding all the ones i forgot to take notes on...heh

All times are GMT -4. The time now is 08:54 AM.