SGCP DATABASE ERROR

[leadtech]

Please help me ..

I have error installing SGCP

SQL query:
CREATE TABLE  `mainnews` (
`post_id` INT( 11 ) NOT NULL AUTO_INCREMENT ,
`title` VARCHAR( 60 ) NOT NULL ,
`message` TEXT NOT NULL ,
`poster` TEXT NOT NULL ,
`date` VARCHAR( 255 ) NOT NULL ,
PRIMARY KEY (  `post_id` ) TYPE = ENGINE AUTO_INCREMENT =0;
MySQL said:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '=ENGINE AUTO_INCREMENT=0' at line 8

Thank you in advance

[Rayan]

you have to create extra db for star cp , so just create new db at ur mysql and i would suggest to make a seprate user account for it , then try to reinsatall it

[Asura]

Hi leadtech,

The correct syntax should be this...

CREATE TABLE IF NOT EXISTS `mainnews` (
`post_id` INT(11) NOT NULL auto_increment,
`title` VARCHAR(60) NOT NULL,
`message` TEXT NOT NULL,
`poster` TEXT NOT NULL,
`date` VARCHAR(255) NOT NULL,
PRIMARY KEY (`post_id`),
ENGINE=MyISAM AUTO_INCREMENT=0;