我在DZ5.5中备份的数据想在DZ6.0中恢复不了。请教高手指点！
Discuz! info: MySQL Query Error
User: hontoadmin
Time: 2007-11-1 9:02pm
Script: /admincp.php
SQL: CREATE TABLE [Table]payset ( groupid int(5) unsigned NOT NULL default '0', type tinyint(1) NOT NULL default '1', enable tinyint(1) NOT NULL default '0', allowrank tinyint(1) NOT NULL default '0', allowcheck tinyint(1) NOT NULL default '0', allowview tinyint(1) NOT NULL default '0', allowforum tinyint(1) NOT NULL default '0', forum varchar(255) NOT NULL default '0,0,0,0,0,0,0,0', leaveday mediumint(8) NOT NULL default '0', group mediumint(8) NOT NULL default '0', getprice mediumint(8) NOT NULL default '0', tax mediumint(8) NOT NULL default '0', up mediumint(8) NOT NULL default '0', down mediumint(8) NOT NULL default '0', rank varchar(255) NOT NULL default '0,0,0,0,0', check varchar(255) NOT NULL default '0,0,0,0,0', well varchar(255) NOT NULL default '0,0,0,0,0', top varchar(255) NOT NULL default '0,0,0,0,0', admin varchar(255) NOT NULL default '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0', post varchar(255) NOT NULL default '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0', digest varchar(255) NOT NULL default '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0', online varchar(255) NOT NULL default '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0', pageview varchar(255) NOT NULL default '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0', KEY groupid (groupid)) ENGINE=MyISAM DEFAULT CHARSET=gbk
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 'group mediumint(8) NOT NULL default '0', getprice mediumint(8) NOT NULL default' at line 1
Errno.: 1064 |
楼主