NEED HELP WITH RESTORING BACKUP FILES!

[Azsman]

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!

Error

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!?!

[metallica48423]

odd.  try default 0 or removing the default '' altogether

[Panzer-]

ID_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.