Thread: V 0.0.10 ^-^
View Single Post
  #10  
Old 04-29-2007, 01:07 AM
Kayot
Discordant
 
Join Date: Sep 2006
Location: Subsection 185.D354 C.12
Posts: 346
Default

mamba666 - Have you tried updating your DB's to the PEQ CVS? Cave dudes DB is old, and by old I mean it's missing sevearal thousand entrys.

I checked the scheme of the newest PEQ database and rulesflag is in there.


Code:
CREATE TABLE account (
  id int(11) NOT NULL auto_increment,
  `name` varchar(30) NOT NULL default '',
  charname varchar(64) NOT NULL default '',
  sharedplat int(11) NOT NULL default '0',
  `password` varchar(50) NOT NULL default '',
  `status` int(5) NOT NULL default '0',
  lsaccount_id int(11) unsigned default NULL,
  gmspeed tinyint(3) unsigned NOT NULL default '0',
  revoked tinyint(3) unsigned NOT NULL default '0',
  minilogin_ip varchar(32) NOT NULL default '',
  hideme tinyint(4) NOT NULL default '0',
  rulesflag tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (id),
  UNIQUE KEY `name` (`name`),
  UNIQUE KEY lsaccount_id (lsaccount_id)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;
Also, mwmdragon, are you using Mysql 4.0? That error is about the input of the mysql command being messed up because the connector libabry is for 4.1+
__________________
If at first you don't succeed destroy all evidence that you ever tried.

God doesn't give second chances... Hell, he sets you up the first time.
Reply With Quote