DV8.3转DiscuzX1时出现错误,如下: Time: 2011-8-19 4:25am SQL: CREATE TABLE mtlx1.pre_xreports (
rid int(10) unsigned NOT NULL AUTO_INCREMENT,
step tinyint(2) unsigned NOT NULL DEFAULT '0',
errnum mediumint(8) unsigned NOT NULL DEFAULT '0',
message mediumtext NOT NULL DEFAULT '',
PRIMARY KEY (rid),
KEY step (step)
) TYPE=MyISAM AUTO_INCREMENT=100; Error: 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 'TYPE=MyISAM AUTO_INCREMENT=100' at line 8 Errormsg.: 可能原因:1.数据超长或类型不匹配;2.数据库记录重复 Errno.: 1064
在X1中,如果不不关闭调试模式,则显示:
XConvert info: MySQL Query Error
Time: 2011-8-20 1:42am
SQL: CREATE TABLE mtlx1.pre_xreports (
rid int(10) unsigned NOT NULL AUTO_INCREMENT,
step tinyint(2) unsigned NOT NULL DEFAULT '0',
errnum mediumint(8) unsigned NOT NULL DEFAULT '0',
message mediumtext NOT NULL DEFAULT '',
PRIMARY KEY (rid),
KEY step (step)
) TYPE=MyISAM AUTO_INCREMENT=100;
Error: 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 'TYPE=MyISAM AUTO_INCREMENT=100' at line 8
Errormsg.: 可能原因:1.数据超长或类型不匹配;2.数据库记录重复
Errno.: 1064