SMF Support > SMF 2.0.x Support

Importing Database

(1/1)

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: ---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'
--- End code ---

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.

Navigation

[0] Message Index