数据库导入出现错误!

导入第一卷数据的时候出现这种情况!!
Discuz! info: MySQL Query Error

User: xing
Time: 2008-7-6 7:06pm
Script: /bbs/admincp.php

SQL: CREATE TABLE [Table]albumcla ( id int(10) unsigned NOT NULL auto_increment, parentid int(10) unsigned NOT NULL default '0', claname char(30) NOT NULL default '', uid mediumint(8) unsigned NOT NULL default '0', photoname char(100) NOT NULL default '', createtime int(10) unsigned NOT NULL default '0', updatetime int(10) unsigned NOT NULL default '0', sortid int(10) unsigned NOT NULL default '0', clatype tinyint(1) unsigned NOT NULL default '0', photocount smallint(5) unsigned NOT NULL default '0', viewtype tinyint(1) unsigned NOT NULL default '1', passwd char(16) NOT NULL default '111111', clicktimes mediumint(8) unsigned NOT NULL default '0', describe char(50) NOT NULL default '', KEY id (id), KEY uid (uid), KEY parentid (parentid), KEY viewtype (viewtype), KEY photocount (photocount), KEY sortid (sortid)) TYPE=MyISAM AUTO_INCREMENT=37
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 'describe char(50) NOT NULL default '', KEY id (id), KEY uid (
Errno.: 1064

Similar error report has beed dispatched to administrator before.

到 http://faq.comsenz.com 搜索此错误的解决方案


请高手帮我解决一下,本人十分感谢!

旧论坛还在么

这个版本是6.10的~~本来是第1卷和第4卷都有问题的,第4卷我已从论坛找到你解决的问题,按照你的方法已解决了,现在就差第1卷!

[ 本帖最后由 xing186 于 2008-7-6 19:42 编辑 ]

不要答非所问。想得到答案就把情况描述清楚，别把报错信息一贴就想省事来着。

因一个朋友从一个网站装上UC然后把数据同装一个数据库里面,导致论坛注册出现错误,随后我就备份了起来,重新安装论坛,在导入的过程,就出现以上这种情况,麻烦你帮我解决一下!

用记事本打开第一卷，找到所有cdb_alb 开头的表，把表结构段与数据部分的相关行都删掉，保存后再恢复。

已成功恢复,当在注册的时候,出现了这个问题!

Discuz! info: MySQL Query Error

Time: 2008-7-6 8:58pm
Script: /bbs/register.php

SQL: INSERT INTO [Table]members (uid, username, password, secques, gender, adminid, groupid, regip, regdate, lastvisit, lastactivity, posts, credits, extcredits1, extcredits2, extcredits3, extcredits4, extcredits5, extcredits6, extcredits7, extcredits8, email, bday, sigstatus, tpp, ppp, styleid, dateformat, timeformat, pmsound, showemail, newsletter, invisible, timeoffset)
VALUES ('6532', 'xing186', '3d9153c4f92603f5bdf40781dc711226', '', '0', '0', '10', '116.20.108.208', '1215349132', '1215349132', '1215349132', '0', 5,5,5,0,0,0,0,0,0, 'xing186@163.com', '0000-00-00', '0', '0', '0', '', '0', '0', '1', '1', '1', '0', '9999')
Error: Duplicate entry '6532' for key 1
Errno.: 1062

到 http://faq.comsenz.com 搜索此错误的解决方案

[ 本帖最后由 xing186 于 2008-7-6 20:59 编辑 ]

到phpmyadmin中把member表的uid字段起始值，设置为现在数据库中的最大uid+1.