Loading spawn groups failed

[Lord of Steel]

I set up a second server on my network called test to do my development on. It is tapped into a copy of my live DB on my live server. I am using the mini login server and i am able to get to the character selection screen but no zones will load.

here are what my logs show

---------------------------------------------
[03.13. - 00:26:24] Starting Log: logs/eqemu_zone_2340.log
[03.13. - 00:26:24] Using database 'peq_test' at 192.168.1.21:3306
[03.13. - 00:26:55] Booting velketor (112:0)
[03.13. - 00:26:55] Loading spawn conditions...
[03.13. - 00:26:55] Loading static zone points...
[03.13. - 00:26:55] Loading spawn groups...
[03.13. - 00:26:59] Booting ecommons (22:0)
[03.13. - 00:26:59] Loading spawn conditions...
[03.13. - 00:26:59] Loading static zone points...
[03.13. - 00:26:59] Loading spawn groups...
[03.13. - 00:27:00] Booting ecommons (22:0)
[03.13. - 00:27:00] Loading spawn conditions...
[03.13. - 00:27:00] Loading static zone points...
[03.13. - 00:27:00] Loading spawn groups...
[03.13. - 00:27:01] Booting ecommons (22:0)
[03.13. - 00:27:01] Loading spawn conditions...
[03.13. - 00:27:01] Loading static zone points...
[03.13. - 00:27:01] Loading spawn groups...

---------------------------------------------
[03.13. - 00:26:55] Starting Log: logs/eqemu_error_zone_2340.log
[03.13. - 00:26:55] Loading spawn groups failed.
[03.13. - 00:26:59] Loading spawn groups failed.
[03.13. - 00:27:00] Loading spawn groups failed.
[03.13. - 00:27:01] Loading spawn groups failed.

---------------------------------------------
[03.13. - 00:26:24] Starting Log: logs/eqemu_quest_zone_2340.log
[03.13. - 00:26:24] Tying perl output to eqemu logs
[03.13. - 00:26:24] Creating EQEmuIO=HASH(0xce000c)
[03.13. - 00:26:24] Creating EQEmuIO=HASH(0xcd28ec)
[03.13. - 00:26:24] Loading perlemb plugins.
[03.13. - 00:26:24] Subroutine Cwd::fastcwd redefined at C:/Perl/lib/Cwd.pm line 812.
[03.13. - 00:26:24] Subroutine Cwd::getcwd redefined at C:/Perl/lib/Cwd.pm line 812.
[03.13. - 00:26:24] Subroutine Cwd::abs_path redefined at C:/Perl/lib/Cwd.pm line 812.

I had the server up on the public login server and i had the same problem. Then i read about how you can not host 2 public servers and configured things to work with the mini login.

My live server has all the port forwarding set up on the router and people can connect to it. There are no ports set up for the test server on the router.

I am attempting to connect to my test server with with my gaming PC.

The zone console window always displays 0:sleeping.

I thought it might be a latest source issue, so i copied over my project from live and compiled it. same problem.

Thought it might have been a DB issue so i sourced in the latest PEQ db file and pointed it at that. Same problem

Tried it with and without LUA, with level 10 debug logging. Same results every time.

I've been searching for an answer all night and it almost always comes down to a DB issue, but it's spotted in the logs. I can't get anything useful out of my logs.

Any help would be appreciated. Thanks.

[NatedogEZ]

How up to date is the source / database?

There is a SQL file to change the table `spawngroup` from.. 2014_02_26

If you are using an old DB with new source.. you need to update the DB

[Lord of Steel]

Thanks! that worked.