SQL Problems

Status
Not open for further replies.
Newbie Spellweaver
Joined
Mar 9, 2007
Messages
44
Reaction score
0
Help.

The File For The SQL Database Is Not Working I Keep Getting This Error

Pokle - SQL Problems - RaGEZONE Forums


I Need To Know Exactly What To Do.

Andeh
 
this is line 43 in the sql file
CREATE TABLE `characters` (
 
Im looking at it now, should find out whats wrong in a minute.

Replace the accounts section with this

-- ----------------------------
-- Table structure for accounts
-- ----------------------------
CREATE TABLE `accounts` (

`id` int(11) NOT NULL auto_increment,

`username` varchar(64) default NULL,

`password` varchar(32) default NULL,

`accesslevel` int(11) default '100',

`lastip` varchar(15) default '0.0.0.0',

`lasttime` int(11) default '0',

`lastsvr` int(11) default '0',

`lastchar` varchar(64) default NULL,

`email` varchar(100) default NULL,

`nb_donation` int(11) default '0',

`donation` varchar(255) default '0',

`active` int(11) default '1',

`active_key` varchar(255) default NULL,

`zulystorage` int(11) default '0',

`platinum` tinyint(1) default '0',

`online` tinyint(1) default '0',

`login_count` int(11) default '0',

`isSiteLogged` tinyint(1) default '0',
PRIMARY KEY (`id`))
ENGINE=InnoDB AUTO_INCREMENT=78 DEFAULT CHARSET=latin1;
 
-- ----------------------------
-- Table structure for accounts
-- ----------------------------
CREATE TABLE `accounts` (

`id` int(11) NOT NULL auto_increment,

`username` varchar(64) default NULL,

`password` varchar(32) default NULL,

`accesslevel` int(11) default '100',

`lastip` varchar(15) default '0.0.0.0',

`lasttime` int(11) default '0',

`lastsvr` int(11) default '0',

`lastchar` varchar(64) default NULL,

`email` varchar(100) default NULL,

`nb_donation` int(11) default '0',

`donation` varchar(255) default '0',

`active` int(11) default '1',

`active_key` varchar(255) default NULL,

`zulystorage` int(11) default '0',

`platinum` tinyint(1) default '0',

`online` tinyint(1) default '0',

`login_count` int(11) default '0',

`isSiteLogged` tinyint(1) default '0')
ENGINE=InnoDB AUTO_INCREMENT=78 DEFAULT CHARSET=latin1;


TRY THAT
 
Nope Nothing Seems To Want To Work

Could This Be A Problem With My Database?

EDIT: Problem Fixed Thanks For Trying To Help.

Andeh
 
Last edited:
Status
Not open for further replies.
Back