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

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

Reply
 
Thread Tools Display Modes
  #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
  #2  
Old 06-09-2005, 02:29 AM
cavedude's Avatar
cavedude
The PEQ Dude
 
Join Date: Apr 2003
Location: -
Posts: 1,988
Default

On CVS under the utils folder there is a file called 0.6.1-upgrade.sql Run that and it should fix you up. In 0.6.1 target zone IDs were changed from name to number.
Reply With Quote
  #3  
Old 06-09-2005, 05:46 AM
xealblade
Fire Beetle
 
Join Date: May 2005
Posts: 2
Default

Doh! Can't believe I forgot to source that in there. Thanks a bunch, Cavedude.
Reply With Quote
Reply


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 08:00 AM.


 

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 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3