|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Archive::Windows Servers Archive area for Windows Servers's posts that were moved here after an inactivity period of 90 days. |
02-01-2004, 02:46 AM
|
Fire Beetle
|
|
Join Date: Jun 2003
Posts: 2
|
|
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
|
|
|
|
02-01-2004, 04:33 AM
|
Dragon
|
|
Join Date: Jan 2004
Location: LasShithole, NV
Posts: 520
|
|
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);
|
__________________
Perfect quote from another site: it's immature pricks who refuse to read the numerous stickies in every forum pointing out what to do and what not to do that get flamed. Grow up and learn to do your fucking homework before opening your cake hole, junior. EQEmu doesn't like you anymore, and that's why you're getting errors. So go away.
__________________
|
|
|
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
All times are GMT -4. The time now is 12:35 AM.
|
|
|
|
|
|
|
|
|
|
|
|
|