World.exe : Zone not found in database..

[Irreverent]

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]

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

silly custom tables..

Missed goallists...

[Irreverent]

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]

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

[Irreverent]

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]

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]

Originally Posted by Irreverent

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.

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

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]

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]

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]

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