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?