SGCP DATABASE ERROR

[leadtech]

Patulong naman .. error ako sa pag install ng 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

[Petey Pablo]

switch ka nlng sa fluxCP or CeresCP.

[jhonix]

syntax error klng ata pre...eto try mo...

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` )

);