Importing Database

[ALEJO]

i downloaded a backup from my forum an then tryed to import (via mysql) the files to a fresh installed forum, but got this.

Code Select Expand

Error

consulta SQL:

CREATE TABLE `smf_log_digest` (
id_topic mediumint( 8 ) unsigned NOT NULL default '',
id_msg int( 10 ) unsigned NOT NULL default '',
note_type varchar( 10 ) NOT NULL default 'post',
daily smallint( 3 ) unsigned NOT NULL default 0,
exclude mediumint( 8 ) unsigned NOT NULL default 0
) TYPE = MYISAM ;

MySQL ha dicho: Documentación
#1067 - Invalid default value for 'id_topic'

[jerm]

What's your SMF version and your mySQL version?

[Rumbaar]

Some versions of mySQL have issue with null values of a default value.  Try manually changing default '', values to default '0', and see how you go.