debian server - out of ideas

[Jurevicius]

As I mentioned before, I am trying to work through getting the ax_classic working on my server. Basically getting a bunch of cannot load item errors. Realizing I am using two different versions of each, essentially a newer emu than the database.

I went through the changelog and sourced in all of the required updates since about before the latest classic db. Coming up with some duplicate returns but plenty of accepted changes.

So now the logs show it loading items properly and everything, but still not able to log in due to "that zone is unavailable" error. Looks like i've got rid of all the errors accept one. Happens every-time I hit enter world.

Zone error log:
4601 [07.16. - 22:44:56] Loading spawn groups failed.

This is probably more general of an error I imagine and could be a number of missing things due to the updates.

But, is there any place I might be able to look at to fix this one? Any tips would be a huge help!

[Shendare]

The only think I can think of at the moment regarding that error message is that Spawn groups were updated to accomodate the new instancing features in the Emu code.

Specifically, the 'spawn2' table had a 'version' field added.

Let's see... looks like it was part of 612_instance_changes.sql.

Does your spawn2 table have the 'version' field after the 'zone' field?

[Jurevicius]

Dead on that was it, I didn't have that one sourced in. I was taking the short road and importing them by phpmyadmin which on that one threw back a duplicate error and didn't finish the rest of the source. Sourcing it through command line got the rest in there.

I got logged into the game just fine, but unfortunately I looked around and none of the NPCs are popped. No errors in any of the logs so it's a Little puzzling.

I will go back again tonight and make sure all the updates got sourced in properly if that's the best way to approach it.

Thanks again