Problems after updating SQL

vales · #1 05-09-2009, 08:48 PM

If you have customized stuff, maybe not. It depends on what you modified. But since you do have a backup, if you source all of the files in the correct order, then there should be no problems. But since you did source everything differently, the tables may not match up and you'll get errors - I dunno. The best thing to do is try.

As for the "zone unavailable" error, it's because there's no extra zones being launched. You need at least 2 zones in order to zone into the next one. If you only launch one zone, you can't zone into another since it can't transfer you.

Under your launcher table in mysql, it should say zone 5 or something similar. That means it's telling the eqlauncher to launch 5 dynamic zones.

Since you sourced the files backwards, you basically have a naked database with no data populated in the fields. At this point I would really recommend doing it the correct way. You already have a backup, so there really isn't anything to lose at this point.

neiv2 · #2 05-09-2009, 09:03 PM

Quote:

As for the "zone unavailable" error, it's because there's no extra zones being launched. You need at least 2 zones in order to zone into the next one. If you only launch one zone, you can't zone into another since it can't transfer you.

The launcher table shows 5 zones, and eqlaunch.exe actually does launch 5 zones (I can see them during world startup). Once it gets to the LS and I log in, the server screen shows that the world is "locked(down)." I can bypass this and get to the char sel screen, but when I attempt to enter the world, I get the "zone unavailable" message.

I will try to redo the entire update sequence.

vales · #3 05-11-2009, 02:58 PM

Are your ports open for the zones?

neiv2 · #4 05-12-2009, 12:19 AM

I have open eqemu 7000 thru 7010, and 9000. I assume those are correct.

vales · #5 05-12-2009, 02:56 AM

Quote:

Originally Posted by neiv2

I have open eqemu 7000 thru 7010, and 9000. I assume those are correct.

3306 for mysql and 5999 for the login server (or whatever you set it to in the config files) should be opened as welll.

If the server is locked down, then that means the zones aren't booting properly. Since you're bypassing it to get in, then that means there's something wrong with your configuration - firewall or otherwise.