Go Back   EQEmulator Home > EQEmulator Forums > Support > Support::Windows Servers

Support::Windows Servers Support forum for Windows EQEMu users.

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 06-08-2005, 09:22 PM
xealblade
Fire Beetle
 
Join Date: May 2005
Posts: 2
Default Problem with zone_points.sql and 0.6.1-DR1?

When trying to run either Cavedude's or Suedeworthey's 0.6.1-DR1 binaries, everything seems to work fine until it goes to load a zone, which gives the error message in zoneperl:

Code:
Error 1 in LoadStaticZonePoints query 'SELECT x,y,z,target_x,target_y,target_z,
target_zone_id,heading,target_heading,number FROM zone_points WHERE zone = 
'freportn' order by number' #1054: Unknown column 'target_zone_id' in 'field list'
Looking in zone_points.sql, I see that the table is created as

Code:
CREATE TABLE zone_points (
  id int(11) NOT NULL auto_increment,
  zone char(16) NOT NULL default '',
  number tinyint(3) unsigned NOT NULL default '1',
  x float NOT NULL default '0',
  y float NOT NULL default '0',
  z float NOT NULL default '0',
  target_x float NOT NULL default '0',
  target_y float NOT NULL default '0',
  target_z float NOT NULL default '0',
  target_heading float NOT NULL default '0',
  target_zone char(16) NOT NULL default '',
  heading float NOT NULL default '0',
  keep_x tinyint(1) NOT NULL default '0',
  keep_y tinyint(1) NOT NULL default '0',
  zoneinst smallint(5) unsigned default '0',
  PRIMARY KEY  (id),
  UNIQUE KEY NewIndex (number,zone)
) TYPE=MyISAM;
Is it trying to use an older zone_points format or something? Am I going to have to edit the SQL file by hand to fix this problem?
Edit: My zone_points.sql is the latest one from CVS, I peeked into both PEQ's and Cavedude's DBs and noticed the table structure in those is identical to the one from CVS. Could I get away with just inserting that extra column and values for it, or do I need to completely redo the whole table structure to match exactly the order ZonePerl is asking for?

Last edited by xealblade; 06-09-2005 at 09:40 AM..
Reply With Quote
 


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 03:21 PM.


 

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