You have an error in your SQL syntax; check the manual that

[Thomaskanto]

Hey

I am trying to create this database but I get an error:

"Error
SQL query:

CREATE TABLE `ds_comment_threads` (

`thread_id` INT( 11 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
`image_id` INT( 11 ) UNSIGNED NOT NULL DEFAULT '0',
`thread_status` ENUM( 'queued', 'approved', 'disabled' ) NOT NULL DEFAULT 'queued',
`updated` TIMESTAMP( 14 ) NOT NULL ,
`created` TIMESTAMP( 14 ) NOT NULL DEFAULT '00000000000000',
PRIMARY KEY ( `thread_id` ) ,
KEY `thread_status` ( `thread_status` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1;

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 '(14) NOT NULL,
`created` timestamp(14) NOT NULL default '00000000000000',
PR' at line 5 "

Could anybody please tell me where the problem is??

[Thorsten]

Hi,

this is not a phpMyFAQ table.

bye
Thorsten