Quote:
Originally Posted by Abronsyth
Okay, I'm having this error:
CREATE TABLE `newscomments` (
`id` INT( 5 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`newsID` INT( 5 ) NOT NULL DEFAULT 'None',
`userID` INT( 5 ) NOT NULL DEFAULT 'None',
`comment` VARCHAR( 300 ) NULL DEFAULT NULL ,
`date` VARCHAR( 30 ) NULL DEFAULT NULL
) ENGINE = MYISAM
MySQL said: Documentation
#1067 - Invalid default value for 'newsID'
Any ideas?
|
Did you write "None" instead of selecting 'None' from the list? If it's not that, you can try running it directly and removing the default part:
Code:
CREATE TABLE `[your_prefix_here]_newscomments` (
`id` INT( 5 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`newsID` INT( 5 ) NOT NULL,
`userID` INT( 5 ) NOT NULL,
`comment` VARCHAR( 300 ) NULL DEFAULT NULL ,
`date` VARCHAR( 30 ) NULL DEFAULT NULL
) ENGINE = MYISAM
This is by clicking on the "SQL" tab. Like here:
http://i.imgur.com/VGRaF82.png