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 02-25-2009, 12:45 PM
nosfentora
Discordant
 
Join Date: Oct 2004
Location: In a house
Posts: 377
Default SQL Error in newly downloaded data

Just pulled the db from the svn and am getting an error on load_player.sql - specifically in 'rule_values.sql'

the code is
Code:
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
Code:
`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)
Reply With Quote
  #2  
Old 03-05-2009, 12:19 AM
AneXus
Fire Beetle
 
Join Date: Mar 2007
Posts: 3
Default

Code:
`rule_value` varchar('1'0) NOT NULL default '',
should be
Code:
 `rule_value` varchar('10') NOT NULL default '',
And I believe its source load_player.sql, then load_bots.sql, then the peq.sql

Last edited by AneXus; 03-05-2009 at 08:21 AM.. Reason: Forgot to put Code brackets...
Reply With Quote
  #3  
Old 03-05-2009, 09:24 AM
nosfentora
Discordant
 
Join Date: Oct 2004
Location: In a house
Posts: 377
Default

Thanks AneXus.
Reply With Quote
Reply

Thread Tools
Display Modes

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:48 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