求救:
我论坛什么数据都没了,导入以前备份的sql数据.提示缺少表cdb_medals 导入不了论坛。有什么办法可以解决啊???
导入时提示的错误提示如下:
Discuz! info: MySQL Query Error
User: admin
Time: 2007-11-11 4:46pm
Script: /admincp.php
SQL: CREATE TABLE [Table]medals ( medalid smallint(6) unsigned NOT NULL auto_increment, name varchar(50) NOT NULL default '', available tinyint(1) NOT NULL default '0', image varchar(30) NOT NULL default '', use tinyint(1) NOT NULL default '0', rest mediumint(8) NOT NULL default '0', lastuser varchar(32) default '', s1 mediumint(8) NOT NULL default '0', r1 mediumint(8) NOT NULL default '0', s2 mediumint(8) NOT NULL default '0', r2 mediumint(8) NOT NULL default '0', s3 mediumint(8) NOT NULL default '0', r3 mediumint(8) NOT NULL default '0', s4 mediumint(8) NOT NULL default '0', r4 mediumint(8) NOT NULL default '0', s5 mediumint(8) NOT NULL default '0', r5 mediumint(8) NOT NULL default '0', s6 mediumint(8) NOT NULL default '0', r6 mediumint(8) NOT NULL default '0', s7 mediumint(8) NOT NULL default '0', r7 mediumint(8) NOT NULL default '0', s8 mediumint(8) NOT NULL default '0', r8 mediumint(8) NOT NULL default '0', post mediumint(8) NOT NULL default '0', credit mediumint(8) NOT NULL default '0', regday mediumint(8) NOT NULL default '0', digest mediumint(8) NOT NULL default '0', pageview mediumint(8) NOT NULL default '0', online mediumint(8) NOT NULL default '0', admin mediumint(8) NOT NULL default '0', thread mediumint(8) NOT NULL default '0', reply mediumint(8) NOT NULL default '0', PRIMARY KEY (medalid)) TYPE=MyISAM AUTO_INCREMENT=43
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 'use tinyint(1) NOT NULL default '0', rest mediumint(8) NOT NUL
Errno.: 1064 |