EQEmulator Forums - I cant figure out whats going wrong.

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Archive::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=617)

- - I cant figure out whats going wrong. (https://www.eqemulator.org/forums/showthread.php?t=11669)

I cant figure out whats going wrong.

I try to insert the account name in the mysql DB with

Code:

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

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.

Quote:

#
# 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);