Having issues getting zones to load.

[shawnluc]

Been searching around, and I have come across a few posts with people having similar issues, but none of them posting what the did to fix the issue.

I am able to see my server in the login list. I can login and create a char, but get zone unavailable when I try to zone into the server.

Here is my log when I execute the start.bat.

[Debug] Starting Log: logs/eqemu_debug_world_1124.log
[Debug] [WORLD__INIT] Loading server configuration..
[Debug] [WORLD__INIT] Log settings loaded from log.ini
[Debug] [WORLD__INIT] CURRENT_WORLD_VERSION:EQEMu 0.7.0
[Debug] [WORLD__INIT] Connecting to MySQL...
[Status] Starting Log: logs/eqemu_world_1124.log
[Status] Using database 'peq' at localhost:3306
[Debug] [WORLD__INIT] Starting HTTP world service...
[Debug] [WORLD__HTTP] Loaded mime types from mime.types
[Debug] [WORLD__INIT] Loading variables..
[Debug] [WORLD__INIT] Loading zones..
[Debug] [WORLD__INIT] Clearing groups..
[Debug] [WORLD__INIT] Clearing temporary merchant lists..
[Debug] [WORLD__INIT] Loading items..
[Status] EMuShareMem loaded
[Status] Loading items from database: count=54307
[Debug] [WORLD__INIT] Loading guilds..
[Debug] [RULES__CHANGE] Loading rule set 'default' (2)
[Debug] [WORLD__INIT] Loaded default rule set 'default'
[Debug] [WORLD__INIT] Loading EQ time of day..
[Error] Starting Log: logs/eqemu_error_world_1124.log
[Error] Could not load EQTime file eqtime.cfg
[Debug] [WORLD__INIT_ERR] Unable to load eqtime.cfg
[Debug] [WORLD__INIT] Loading launcher list..
[Debug] [WORLD__INIT] Reboot zone modes ON
[Debug] [WORLD__INIT] Deleted 0 stale player corpses from database
[Debug] [WORLD__INIT] Deleted 0 stale player backups from database
[Debug] [WORLD__INIT] Zone (TCP) listener started.
[Debug] [WORLD__INIT] Client (UDP) listener started.
[Debug] [NET__IDENTIFY] Registered patch 6.2
[Debug] [NET__IDENTIFY] Registered patch Titanium
[Debug] [NET__IDENTIFY] Registered patch Anniversary
[Debug] [NET__IDENTIFY] Registered patch Live
[Debug] [WORLD__LS] Connecting to login server...
[Debug] [WORLD__LS] Connected to Loginserver: eqemulator.net:5998
[Debug] [WORLD__ZONE] New TCP connection from 127.0.0.1:1879
[Debug] [WORLD__CONSOLE] New launcher from 127.0.0.1:1879
[Debug] [WORLD__LAUNCH] Adding pending launcher 1
[Debug] [WORLD__LAUNCH] Launcher Identified itself as 'zone'. Loading zone

[Debug] [WORLD__LAUNCH] Removing pending launcher 1. Adding zone to active

[Debug] [WORLD__LAUNCH] zone: dynamic_01 reported state STARTED (1 starts)
[Debug] [WORLD__LAUNCH] zone: dynamic_01 reported state STOPPED (1 starts)
[Debug] [WORLD__LAUNCH] zone: dynamic_01 reported state STARTED (2 starts)
[Debug] [WORLD__LAUNCH] zone: dynamic_01 reported state STOPPED (2 starts)
[Debug] [WORLD__LAUNCH] zone: dynamic_01 reported state STARTED (3 starts)
[Debug] [WORLD__LAUNCH] zone: dynamic_01 reported state STOPPED (3 starts)
[Debug] [WORLD__CLIENT] New connection from 192.168.0.2:1170
[Debug] [NET__IDENT_TRACE] 192.168.0.2:1170: First opcode 0x4dd0 did not ma
xpected 0x2792
[Debug] [NET__IDENT_TRACE] 192.168.0.2:1170: Tried patch 6.2_world, and it
ot match.
[Debug] [NET__IDENT_TRACE] 192.168.0.2:1170: First opcode 0x4dd0 did not ma
xpected 0x2ec9
[Debug] [NET__IDENT_TRACE] 192.168.0.2:1170: Tried patch 6.2_zone, and it d
t match.
[Debug] [NET__IDENT_TRACE] 192.168.0.2:1170: First opcode matched 0x4dd0 an
gth matched 464
[Debug] [NET__IDENTIFY] Identified stream 192.168.0.2:1170 with signature T
um_world
[Debug] [WORLD__CLIENT] New client from 192.168.0.2:1170
[Debug] [WORLD__CLIENT] lucasserver: Logged in. Mode=(CharSel)
[Debug] [WORLD__CLIENT] lucasserver: LS Account #101328
[Debug] [WORLD__LAUNCH] zone: dynamic_01 reported state STARTED (4 starts)
[Debug] [WORLD__LAUNCH] zone: dynamic_01 reported state STOPPED (4 starts)
[Debug] [WORLD__LAUNCH] zone: dynamic_01 reported state STARTED (5 starts)
[Debug] [WORLD__LAUNCH] zone: dynamic_01 reported state STOPPED (5 starts)
[Debug] [WORLD__LAUNCH] zone: dynamic_01 reported state STARTED (6 starts)
[Debug] [WORLD__LAUNCH] zone: dynamic_01 reported state STOPPED (6 starts)
[Debug] [WORLD__CLIENT] lucasserver: Attempting autobootup of freportw (9)
[Debug] [WORLD__CLIENT_ERR] lucasserver: No zoneserver available to boot up
[Debug] [WORLD__LAUNCH] zone: dynamic_01 reported state STARTED (7 starts)
[Debug] [WORLD__CLIENT] lucasserver: Attempting autobootup of cabeast (106)
[Debug] [WORLD__CLIENT_ERR] lucasserver: No zoneserver available to boot up
[Debug] [WORLD__LAUNCH] zone: dynamic_01 reported state STOPPED (7 starts)
[Debug] [WORLD__LAUNCH] zone: dynamic_01 reported state STARTED (8 starts)
[Debug] [WORLD__LAUNCH] zone: dynamic_01 reported state STOPPED (8 starts)

[shawnluc]

This is the error I get when I try to execute the zone.exe manually.

C:\>cd eqemu

C:\EQemu>zone
[Debug] Starting Log: logs/eqemu_debug_zone_3308.log
[Debug] [ZONE__INIT] Loading server configuration..
[Debug] [ZONE__INIT] Log settings loaded from log.ini
[Debug] [ZONE__INIT] Connecting to MySQL...
[Status] Starting Log: logs/eqemu_zone_3308.log
[Status] Using database 'peq' at localhost:3306
[Debug] [ZONE__INIT] CURRENT_ZONE_VERSION: EQEMu 0.7.0
[Debug] [ZONE__INIT] Log settings loaded from ./log.ini
[Debug] [ZONE__INIT] Mapping Incoming Opcodes
[Debug] [ZONE__INIT] Loading Variables
[Debug] [ZONE__INIT] Loading zone names
[Debug] [ZONE__INIT] Loading items
[Status] EMuShareMem loaded
[Debug] [ZONE__INIT] Loading npc faction lists
[Status] Loading NPC Faction Lists from database...
Error in DBLoadNPCFactionLists query2 'SELECT id, primaryfaction, ignore_primary
_assist from npc_faction' #1054: Unknown column 'ignore_primary_assist' in 'fiel
d list'
Error: EMuShareMem: DLLLoadNPCFactionLists: !cbDBLoadNPCFactionLists
[Debug] [ZONE__INIT_ERR] Loading npcs faction lists FAILED!

C:\EQemu>

[shawnluc]

Lastly my eqemu_config.xml

<?xml version="1.0">
<server>
<world>
<shortname>LucasServer</shortname>
<longname>LucasServer-Legit</longname>

<!-- Only specify these two if you really think you need to. -->
<address>X.X.X.X</address>
<localaddress>192.168.0.4</localaddress>

<!-- Loginserver information. -->
<loginserver>
<host>eqemulator.net</host>
<port>5998</port>
<account></account>
<password></password>
</loginserver>

<!-- Sets the shared key used by zone/launcher to connect to world -->
<key>some long random string</key>

<!-- Enable and set the port for the HTTP service. -->
<http port="9080" enabled="true" mimefile="mime.types" />
</world>

<!-- Database configuration, replaces db.ini. -->
<database>
<host>localhost</host>
<port>3306</port>
<username>root</username>
<password>********</password>
<db>peq</db>
</database>
</server>

[sfisque]

looks like you're missing a schema change. check the "changelog" file to see if there are any "sql" code fragments that you need to execute against your database to add the missing column.

== sfisque

Originally Posted by shawnluc

This is the error I get when I try to execute the zone.exe manually.

C:\>cd eqemu

C:\EQemu>zone
[Debug] Starting Log: logs/eqemu_debug_zone_3308.log
[Debug] [ZONE__INIT] Loading server configuration..
[Debug] [ZONE__INIT] Log settings loaded from log.ini
[Debug] [ZONE__INIT] Connecting to MySQL...
[Status] Starting Log: logs/eqemu_zone_3308.log
[Status] Using database 'peq' at localhost:3306
[Debug] [ZONE__INIT] CURRENT_ZONE_VERSION: EQEMu 0.7.0
[Debug] [ZONE__INIT] Log settings loaded from ./log.ini
[Debug] [ZONE__INIT] Mapping Incoming Opcodes
[Debug] [ZONE__INIT] Loading Variables
[Debug] [ZONE__INIT] Loading zone names
[Debug] [ZONE__INIT] Loading items
[Status] EMuShareMem loaded
[Debug] [ZONE__INIT] Loading npc faction lists
[Status] Loading NPC Faction Lists from database...
Error in DBLoadNPCFactionLists query2 'SELECT id, primaryfaction, ignore_primary
_assist from npc_faction' #1054: Unknown column 'ignore_primary_assist' in 'fiel
d list'
Error: EMuShareMem: DLLLoadNPCFactionLists: !cbDBLoadNPCFactionLists
[Debug] [ZONE__INIT_ERR] Loading npcs faction lists FAILED!

C:\EQemu>

[shawnluc]

Hmmm ok now im a bit confused. The guide only references sourcing the load_player.sql, and load_system.sql, but wincvs downloaded a bunch of .sql files. Do I need to source all of them?

[narcberry]

load_player.sql and load_system.sql just source all the other sql files. Last time I downloaded the db from cvs it wasn't up to date with the latest eqemu version. Find the newest .sql file in the bunch and run every sql command in the changelogs from that day on.

[leslamarch]

Originally Posted by shawnluc

Hmmm ok now im a bit confused. The guide only references sourcing the load_player.sql, and load_system.sql, but wincvs downloaded a bunch of .sql files. Do I need to source all of them?

That is Correct thats all you need to source, Those two .sql files call all the other *.sql to source.

What sfisque Was referring to is check the change log for any changes to the database Like this

Required SQL:
alter table zone add column graveyard_id float NOT NULL default '0' after safe_z;

DROP TABLE IF EXISTS `graveyard`;
CREATE TABLE `graveyard` (
  `id` int(11) NOT NULL auto_increment,
  `zone_id` int(4) NOT NULL default '0',
  `x` float NOT NULL default '0',
  `y` float NOT NULL default '0',
  `z` float NOT NULL default '0',
  `heading` float NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `zone_id` (`zone_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

insert into rule_values values(0, 'Zone:GraveyardTimeMS', 1200000);

[shawnluc]

Ok I went back and added all the code from the change log. I still seem to be getting the same error, and the dynamic zones dont want to come up.

I also noticed that im not getting a response from the login server with an external address. I wonder if this maybe part of the problem.

[AndMetal]

Originally Posted by cavedude

alter table npc_faction add column ignore_primary_assist tinyint(3) not null default 0;

Will do it, or you can use the newest version of PEQ. Both the release and CVS have that column.

Looking at the PEQ CVS, this was added in revision 1.4, which is dated Wed Sep 19 13:49:55 2007 UTC (4 months, 1 week ago). It sounds like the root of the issue stems from how the DB was sourced, or possibly which DB was sourced.

[shawnluc]

Originally Posted by AndMetal

Looking at the PEQ CVS, this was added in revision 1.4, which is dated Wed Sep 19 13:49:55 2007 UTC (4 months, 1 week ago). It sounds like the root of the issue stems from how the DB was sourced, or possibly which DB was sourced.

I think that did it. The zones are coming up now. Ill have to wait to try logging in when I get home.

Thanks everyone for all the help!

[enkendu]

Thank you for adding this little line, i spent hours trying to figure this out and this looks like it did it thank you very much, Quote:

Originally Posted by cavedude
Code:
alter table npc_faction add column ignore_primary_assist tinyint(3) not null default 0;

Will do it, or you can use the newest version of PEQ. Both the release and CVS have that column.