phpwind 8.7 转 X2 时遇到的麻烦，恳求帮助

1. <STRONG>XConvert info</STRONG>: MySQL Query Error
   
2. 
   
3. <B>Time</B>: 2012-3-25 2:10pm
   
4. <B>SQL</B>: CREATE TABLE X2.pre_xreports (
   
5. rid int(10) unsigned NOT NULL AUTO_INCREMENT,
   
6. step tinyint(2) unsigned NOT NULL DEFAULT '0',
   
7. errnum mediumint(8) unsigned NOT NULL DEFAULT '0',
   
8. message mediumtext NOT NULL DEFAULT '',
   
9. PRIMARY KEY (rid),
   
10. KEY step (step)
    
11. ) TYPE=MyISAM AUTO_INCREMENT=100;
    
12. <B>Error</B>: 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
    
13. <B>Errormsg.</B>: 可能原因：1.数据超长或类型不匹配；2.数据库记录重复
    
14. <B>Errno.</B>: 1064
    
15. 
    

复制代码

步骤1、重建这个表

步骤2、在转换首页哪里，关闭调试模式

PHPMYADMIN中SQL执行：

1. CREATE TABLE pre_xreports (
   
2. rid int(10) unsigned NOT NULL AUTO_INCREMENT,
   
3. 
   
4. step tinyint(2) unsigned NOT NULL DEFAULT '0',
   
5. 
   
6. errnum mediumint(8) unsigned NOT NULL DEFAULT '0',
   
7. 
   
8. message mediumtext NOT NULL DEFAULT '',
   
9. 
   
10. PRIMARY KEY (rid),
    
11. 
    
12. KEY step (step)
    
13. 
    
14. ) TYPE=MyISAM AUTO_INCREMENT=100;

复制代码