Go Back   EQEmulator Home > EQEmulator Forums > Support > Support::General Support
Reload this Page Having issues getting zones to load.

Support::General Support Post all topics here having to do with errors while trying to connect to an EQEMu server but not about the setup/running of the Server itself.

Reply
 
Thread Tools Display Modes
  #1  
Old 01-30-2008, 05:01 AM
shawnluc
Fire Beetle
  
Join Date: Jan 2008
Posts: 8
Default
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>
Reply With Quote
  #2  
Old 01-30-2008, 05:03 AM
shawnluc
Fire Beetle
  
Join Date: Jan 2008
Posts: 8
Default
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>
Reply With Quote
  #3  
Old 01-30-2008, 06:54 AM
sfisque
Hill Giant
  
Join Date: Oct 2006
Posts: 248
Default
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


Quote:
Originally Posted by shawnluc View Post
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>
Reply With Quote
  #4  
Old 01-30-2008, 07:24 AM
shawnluc
Fire Beetle
  
Join Date: Jan 2008
Posts: 8
Default
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?
Reply With Quote
  #5  
Old 01-30-2008, 07:42 AM
narcberry
Sarnak
  
Join Date: Mar 2005
Location: Idaho, USA
Posts: 94
Default
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.
__________________
Thanks for answering my questions.
My Website
Reply With Quote
  #6  
Old 01-30-2008, 07:47 AM
leslamarch
Discordant
  
Join Date: Sep 2006
Location: Green Bay, WI
Posts: 436
Default
Quote:
Originally Posted by shawnluc View Post
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
Code:
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);
Reply With Quote
  #7  
Old 01-30-2008, 09:26 AM
shawnluc
Fire Beetle
  
Join Date: Jan 2008
Posts: 8
Default
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.
Reply With Quote
  #8  
Old 01-30-2008, 11:06 AM
AndMetal
Developer
  
Join Date: Mar 2007
Location: Ohio
Posts: 648
Default
Quote:
Originally Posted by cavedude View Post
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.
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.
__________________
GM-Impossible of 'A work in progress'
A non-legit PEQ DB server
How to create your own non-legit server

My Contributions to the Wiki
Reply With Quote
  #9  
Old 01-30-2008, 11:30 AM
shawnluc
Fire Beetle
  
Join Date: Jan 2008
Posts: 8
Default
Quote:
Originally Posted by AndMetal View Post
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!
Reply With Quote
  #10  
Old 10-24-2008, 01:26 AM
enkendu
Fire Beetle
  
Join Date: Nov 2002
Posts: 27
Default
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.
Reply With Quote
Reply

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Hybrid Mode Hybrid Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

   

All times are GMT -4. The time now is 04:22 AM.

EQEmulator - Archive - Top

 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3