SMF Support > SMF 2.0.x Support
Backup SQL error :(
(1/1)
Hammarby:
Query:
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
Error occured at:2008-05-23 12:52:25
Line no.:3081
Error Code: 1067 - Invalid default value for 'id_topic'
Query:
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
Error occured at:2008-05-23 12:53:14
Line no.:3081
Error Code: 1067 - Invalid default value for 'id_topic'
Query:
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
Error occured at:2008-05-23 12:56:17
Line no.:3081
Error Code: 1067 - Invalid default value for 'id_topic'
Query:
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
Error occured at:2008-05-23 13:05:39
Line no.:3081
Error Code: 1067 - Invalid default value for 'id_topic'
Query:
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
Error occured at:2008-05-23 13:09:33
Line no.:3081
Error Code: 1067 - Invalid default value for 'id_topic'
Query:
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
Error occured at:2008-05-23 13:12:52
Line no.:3081
Error Code: 1067 - Invalid default value for 'id_topic'
Query:
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
Error occured at:2008-05-23 13:14:33
Line no.:3081
Error Code: 1067 - Invalid default value for 'id_topic'
Query:
CREATE TABLE `smf_log_digest` (
id_topic mediumint(8) unsigned NOT NULL '',
id_msg int(10) unsigned NOT NULL '',
note_type varchar(10) NOT NULL 'post',
daily smallint(3) unsigned NOT NULL default 0,
exclude mediumint(8) unsigned NOT NULL default 0
) TYPE=MyISAM
Error occured at:2008-05-23 13:16:16
Line no.:3081
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''',
id_msg int(10) unsigned NOT NULL '',
note_type varchar(10) NOT NULL 'pos' at line 2
Query:
CREATE TABLE `smf_log_digest` (
id_topic mediumint(8) unsigned NOT NULL'',
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
Error occured at:2008-05-23 13:18:53
Line no.:3081
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''',
id_msg int(10) unsigned NOT NULL default '',
note_type varchar(10) NOT N' at line 2
Query:
CREATE TABLE `smf_log_digest` (
id_topic mediumint(8) unsigned NOT NULL default 0'',
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
Error occured at:2008-05-23 13:20:32
Line no.:3081
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''',
id_msg int(10) unsigned NOT NULL default '',
note_type varchar(10) NOT N' at line 2
Query:
CREATE TABLE `smf_log_digest` (
id_topic mediumint(8) unsigned NOT NULL default 0'',
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
Error occured at:2008-05-23 13:21:14
Line no.:3081
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''',
id_msg int(10) unsigned NOT NULL default '',
note_type varchar(10) NOT N' at line 2
Query:
CREATE TABLE `smf_log_digest` (
id_topic mediumint(8) unsigned NOT NULL '',
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
Error occured at:2008-05-23 13:22:15
Line no.:3081
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''',
id_msg int(10) unsigned NOT NULL default '',
note_type varchar(10) NOT N' at line 2
Query:
CREATE TABLE `smf_log_digest` (
id_topic mediumint(8) unsigned NOT NULL default 1'',
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
Error occured at:2008-05-23 13:23:08
Line no.:3081
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''',
id_msg int(10) unsigned NOT NULL default '',
note_type varchar(10) NOT N' at line 2
Query:
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
Error occured at:2008-05-23 13:23:44
Line no.:3081
Error Code: 1067 - Invalid default value for 'id_topic'
Query:
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
Error occured at:2008-05-23 13:24:14
Line no.:3081
Error Code: 1067 - Invalid default value for 'id_topic'
I get this when i try backup the SQL databse i have. any one knows why?
DonGiovanni:
I bold you missing
id_topic mediumint(8) unsigned NOT NULL default 0'',
That's in every table that contains id_topic
H:
Remove the create section for smf_log_digest and use the following instead :)
--- Code: ---#
# Table structure for table `log_digest`
#
CREATE TABLE smf_log_digest (
id_topic mediumint(8) UNSIGNED NOT NULL,
id_msg int(10) UNSIGNED NOT NULL,
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;
--- End code ---
This problem is sometimes caused by backing up and restoring from different mysql versions :)
I've moved this to support as it isn't an SMF bug
Navigation
[0] Message Index
Go to full version