Hi! I had to reinstall smf but before i did i back up everything via the back up system supplied by smf, I'm now trying to restore everything via phpMyAdmin and i keep getting this error code!
LainaaError
SQL query:
CREATE TABLE `smf_gallery_comment` (
ID_COMMENT int( 11 ) NOT NULL AUTO_INCREMENT ,
ID_PICTURE int( 11 ) NOT NULL default '',
ID_MEMBER mediumint( 8 ) unsigned NOT NULL default 0,
approved tinyint( 4 ) NOT NULL default 0,
COMMENT text,
date int( 10 ) unsigned NOT NULL default 0,
PRIMARY KEY ( ID_COMMENT )
) TYPE = MYISAM ;
MySQL said: Documentation
#1067 - Invalid default value for 'ID_PICTURE'
Can somebody please help!?! :-[
odd. try default 0 or removing the default '' altogether
LainaaID_PICTURE int( 11 ) NOT NULL default '',
Its trying to set a default of NULL, when you specificly said NOT NULL.
As metal-licker said, remove the default'' but keep the comma at the end of the line.