PDA

View Full Version : I cant figure out whats going wrong.


argar
02-01-2004, 02:46 AM
I try to insert the account name in the mysql DB with INSERT INTO account (id, name, charname, packencrypt, sharedplat, password, status, lsaccount_id, gmspeed, revoked) VALUES (1, 'eqemu', '', '', 0, 'eqemu', 250, NULL, 0, 0); but it says
unknown column 'revoked' in 'field list' I can get in using mini loggin but I get a 1017 error when I try to connect to the server which I guess is from the account not being in the DB

wize_one
02-01-2004, 04:33 AM
this is a snipet from my account table. you can use it if you want.
also if you are running dr2 make sure you have run 0.5.2-update.sql, or if your running dr3 make sure you have run jan24_update.sql.


#
# Table structure for table account
#

DROP TABLE IF EXISTS `account`;

CREATE TABLE `account` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(30) NOT NULL default '',
`charname` varchar(64) NOT NULL default '',
`packencrypt` blob NOT NULL,
`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',
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`),
UNIQUE KEY `lsaccount_id` (`lsaccount_id`)
) TYPE=MyISAM;


#
# Dumping data for table account
#

INSERT INTO `account` VALUES (1,'eqemu','','',5000,'eqemu',255,NULL,1,0);