Help with Empty Zones (not all,though)

[venecha]

I've tried to search for this on the forums already, but haven't seen a post with this specific issue yet.

I'm having an issue on my server where both Veeshan's Peak and the Great Divide are empty. I've tried clearing the timers and restarting the server. Tried to force a repop of the zone, but still nothing.

Both zones used to work. A couple of weeks ago I updated to Rev 1549 (from 1410). I did source all the sql changes that were in the sql folder, but can't think of any of them that might have impacted these zones.

Has anyone else had this issue? Any ideas on where else I can look?

Thanks for any advice!

[cylynex2]

Having the same issue after going from 1535 to 1589 w/bots, except for me it is hollowshade moore and grimling forest, so far. Maybe more.

edit: Just checked my VP, it is also empty now.

[Irreverent]

Actually, mine are too...

plus there is a HUGE bug with spells too. Its been committed, just need someone to compile and post the binaries.

[cylynex2]

I see 1591 is up there now, will that fix the empty zone problem? I think it is db related though...Anyone who knows more about it have any ideas?

[cylynex2]

I tried using a backup of my older db, but that changed nothing. It must be something in the code. Quite a few zones are showing no mobs at all now.

[cylynex2]

It was a database issue. I put in a fresh copy of the peq1589 db, sourced in all my custom stuff, and everything's working again.

I tried it with 1589 compiled both with and without bots, and it works both ways.

[Irreverent]

I can't just load a database from scatch...so does someone know what might of made some zones load and some not?

[trevius]

plus there is a HUGE bug with spells too. Its been committed, just need someone to compile and post the binaries.

The zone crash issue with spells has been fixed as of Rev1592 FYI. Not sure what would cause empty zones, but I can only imagine that it is due to missing SQL. You can probably check your logs and see what is causing NPCs not to load.

[venecha]

Thanks for all the replies! Which logs would show the NPC's not loading? (would it be a zone log?)

I was pretty careful about making sure I had the updated sql. But I'll check again. I also can't reload by db from scratch.

EDITED: One more thing...the SQL updates are in ..\projecteqemu\trunk\EQEmuServer\utils\sql\svn, correct? I went through those again and had them all applied. The only thing I can think of is that it was a code rev issue with the rev I had. I downlaoded 1596, but am having something odd with the perlparser.cpp file. The text is all grey (inactive). Is it supposed to be this way?

Thanks!
Venecha

[venecha]

For those who may be having trouble with this, here is what I did to fix it. (There are some values missing in the spawn_condition_values table if you didn't re-source the db or maybe missed something like I probably did ;) )

I deleted all the data from the spawn_condition_values table

DELETE FROM spawn_condition_values


Then ran the query below.

INSERT INTO `spawn_condition_values` VALUES (1,1,'burningwood',0),(1,0,'commons',0),(1,0,'cora thus',0),(1,1,'dawnshroud',0),(1,0,'eastwastes',0) ,(1,1,'greatdivide',0),(1,1,'hollowshade',0),(1,0, 'kithicor',0),(1,0,'lakerathe',0),(1,1,'lfaydark', 0),(1,1,'mischiefplane',0),(1,1,'northkarana',0),( 1,0,'poeartha',0),(1,1,'poearthb',0),(1,0,'pofire' ,0),(1,0,'poinnovation',0),(1,1,'potactics',0),(1, 0,'potimeb',0),(1,1,'qey2hh1',0),(1,1,'rathemtn',0 ),(1,0,'riwwi',0),(1,1,'sleeper',0),(1,0,'sncremat ory',0),(1,0,'snlair',0),(1,0,'snplant',0),(1,0,'s npool',0),(1,1,'southkarana',0),(1,0,'veeshan',0), (2,0,'burningwood',0),(2,1,'commons',0),(2,1,'cora thus',0),(2,0,'dawnshroud',0),(2,0,'hollowshade',0 ),(2,1,'kithicor',0),(2,1,'lakerathe',0),(2,0,'mis chiefplane',0),(2,0,'northkarana',0),(2,0,'poearth a',0),(2,1,'pofire',0),(2,0,'poinnovation',0),(2,0 ,'potimeb',0),(2,0,'qey2hh1',0),(2,0,'rathemtn',0) ,(2,1,'riwwi',0),(2,0,'sleeper',0),(2,0,'snlair',0 ),(2,0,'snplant',0),(2,0,'southkarana',0),(2,1,'ve eshan',0),(3,1,'corathus',0),(3,0,'hollowshade',0) ,(3,1,'pofire',0),(3,0,'potimeb',0),(4,1,'corathus ',0),(4,0,'hollowshade',0),(4,0,'potimeb',0),(5,1, 'corathus',0),(5,0,'hollowshade',0),(5,0,'potimeb' ,0),(6,0,'corathus',0),(6,0,'hollowshade',0),(6,0, 'potimeb',0),(7,0,'corathus',0),(7,0,'potimeb',0), (8,0,'corathus',0),(8,0,'potimeb',0),(9,1,'corathu s',0),(9,0,'potimeb',0),(10,1,'corathus',0),(10,0, 'potimeb',0),(11,1,'corathus',0),(12,1,'corathus', 0);


Hope This helps someone!
Venecha

[Irreverent]

Ooops, yea...forgot to post that fix when I figured it out the same day.

[venecha]

*chortle* No worries! I'm just glad it is working again (it was driving me nuts I couldn't figure it out :P)