Log in

View Full Version : SQL Error in newly downloaded data


nosfentora
02-25-2009, 12:45 PM
Just pulled the db from the svn and am getting an error on load_player.sql - specifically in 'rule_values.sql'

the code is

SET FOREIGN_KEY_CHECKS=0;
CREATE TABLE `rule_values` (
`ruleset_id` tinyint(3) unsigned NOT NULL default '0',
`rule_name` varchar(64) NOT NULL default '',
`rule_value` varchar('1'0) NOT NULL default '',
PRIMARY KEY (`ruleset_id`,`rule_name`),
KEY `ruleset_id` (`ruleset_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


what should

`rule_value` varchar('1'0) NOT NULL default '',

be?

Also - what is the correct order to install a fresh db?
peqdb_1129RevXXX.sql
load_player.sql
load_bots.sql
?
(it's been a while since i've started from scratch)

AneXus
03-05-2009, 12:19 AM
`rule_value` varchar('1'0) NOT NULL default '',

should be

`rule_value` varchar('10') NOT NULL default '',


And I believe its source load_player.sql, then load_bots.sql, then the peq.sql

nosfentora
03-05-2009, 09:24 AM
Thanks AneXus.