Server status Locked

[jayfromtholuxe]

Originally Posted by joligario

Looks like you don't have any of the client opcode files in your server root.

Looks like that was definitely an issue I had to fix. I was assuming that eqemu would find the files automatically in the place they are in the repo:

root@redacted:~/eqemu# find . -name 'patch_*' | grep -v EQExtractor2
./utils/patches/patch_6.2.conf
./utils/patches/patch_SoF.conf
./utils/patches/patch_SoD.conf
./utils/patches/patch_RoF.conf
./utils/patches/patch_Titanium.conf
./utils/patches/patch_Underfoot.conf

Copying all utils/patches/patch_* files to the base eqemu directory got rid of that error. Thanks!

The server is still listed as Locked even after I copied these files and restarted the daemon. However, I'm now able to connect to it with Titanium and Underfoot clients and create a character -- kinda. When I finalize the creation, it says Entering Mines of Gloomingdeep, pauses for 10-20 seconds, and then pops up 2 error boxes simultaneously atop the character creation screen that say:

"Your personalized tutorial is still loading. Please click Enter World again in a few seconds."

... and ...

"That zone is unavailable."

Waiting even a few minutes doesn't seem to allow me to zone in.

This appears in the log:

[12.22. - 23:07:18] Start zone query: SELECT x,y,z,heading,zone_id,bind_id FROM start_zones WHERE player_choice=10 AND player_class=14 AND player_deity=396 AND player_race=5

[12.22. - 23:07:18] Found starting location in start_zones
[12.22. - 23:09:11] SoF Start zone query: SELECT x,y,z,heading,bind_id FROM start_zones WHERE zone_id=189 AND player_class=14 AND player_deity=396 AND player_race=5

For some reason, my start_zones table doesn't have records for the query that gets generated. When I run that query from the log file in a mysql shell, I get the following:

mysql> SELECT x,y,z,heading,bind_id FROM start_zones WHERE zone_id=189 AND player_class=14 AND player_deity=396 AND player_race=5;
Empty set (0.00 sec)

mysql> select * from start_zones where zone_id=189;
Empty set (0.00 sec)

mysql> select count(*) from start_zones;
+----------+
| count(*) |
+----------+
|      411 |
+----------+
1 row in set (0.00 sec)

The race I was creating (in this case a High Elf) has seemingly correct start_zone entries:

mysql> select distinct zone.long_name from start_zones, zone where start_zones.player_race=5 and zone.zoneidnumber = start_zones.start_zone;
+-------------------+
| long_name         |
+-------------------+
| Northern Felwithe |
| Southern Felwithe |
+-------------------+
2 rows in set (0.01 sec)

I'll dig into this a bit more tomorrow morning. If anyone has seen this issue before, I'd love to know the trick to get past this. Also, the issue with the server appearing Locked still remains.

EDIT: I should also add that I'm explicitly choosing Felwithe in the character creation screen too.