axliumf

但我的表名是:supe_robotitems
出错如下，该怎么解决?谢谢!!!

Error: Duplicate entry '15921' for key 1
Errno.: 1062

Similar error report has beed dispatched to administrator before.

LEECHJIA

搬家的朋友们，这帖能不顶吗？？？

freddy

TMD!厉害!不顶的不男不女!

sdqc

very very 谢谢

我是肖飞

支持好帖

linsie

好东西啊

jackxx

我在备份数据库的时候出现
Discuz! info: MySQL Query Error

User: 蝴蝶风
Time: 2006-9-10 6:26pm
Script: /admincp.php

SQL: SHOW CREATE TABLE cdb_mobdom
Error: Table 'a05241635134.cdb_mobdom' doesn't exist
数据表缺失,请恢复备份数据

Similar error report has beed dispatched to administrator before.

这个是为什么啊，拜托谁告诉我啊

李际

ALTER TABLE `cdb_posts` CHANGE `pid` `pid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
按此升级数据库了，但问题还是没解决

kbc

真得很不错，我用这个解决了大问题，感谢楼主！


下面是一次全部导入的

复制内容到剪贴板

代码:

ALTER TABLE `cdb_adminnotes` CHANGE `id` `id` MEDIUMINT(8) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `cdb_advertisements` CHANGE `advid` `advid` MEDIUMINT(8) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `cdb_announcements` CHANGE `id` `id` SMALLINT(6) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `cdb_attachments` CHANGE `aid` `aid` MEDIUMINT(8) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `cdb_attachtypes` CHANGE `id` `id` SMALLINT(6) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `cdb_banned` CHANGE `id` `id` SMALLINT(6) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `cdb_bbcodes` CHANGE `id` `id` MEDIUMINT(8) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `cdb_crons` CHANGE `cronid` `cronid` SMALLINT(6) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `cdb_forumlinks` CHANGE `id` `id` SMALLINT(6) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `cdb_forums` CHANGE `fid` `fid` SMALLINT(6) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `cdb_medals` CHANGE `medalid` `medalid` SMALLINT(6) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `cdb_members` CHANGE `uid` `uid` MEDIUMINT(8) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `cdb_pluginhooks` CHANGE `pluginhookid` `pluginhookid` MEDIUMINT(8) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `cdb_plugins` CHANGE `pluginid` `pluginid` SMALLINT(6) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `cdb_pluginvars` CHANGE `pluginvarid` `pluginvarid` MEDIUMINT(8) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `cdb_pms` CHANGE `pmid` `pmid` INT(10) UNSIGNED NOT NULL DEFAULT '0' AUTO_INCREMENT;
ALTER TABLE `cdb_pmsearchindex` CHANGE `searchid` `searchid` INT(10) UNSIGNED NOT NULL DEFAULT '0' AUTO_INCREMENT;
ALTER TABLE `cdb_posts` CHANGE `pid` `pid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `cdb_profilefields` CHANGE `fieldid` `fieldid` SMALLINT(6) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `cdb_ranks` CHANGE `rankid` `rankid` SMALLINT(6) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `cdb_searchindex` CHANGE `searchid` `searchid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `cdb_smilies` CHANGE `id` `id` SMALLINT(6) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `cdb_styles` CHANGE `styleid` `styleid` SMALLINT(6) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `cdb_stylevars` CHANGE `stylevarid` `stylevarid` SMALLINT(6) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `cdb_templates` CHANGE `templateid` `templateid` SMALLINT(6) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `cdb_threads` CHANGE `tid` `tid` MEDIUMINT(8) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `cdb_threadtypes` CHANGE `typeid` `typeid` SMALLINT(6) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `cdb_usergroups` CHANGE `groupid` `groupid` SMALLINT(6) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `cdb_words` CHANGE `id` `id` SMALLINT(6) UNSIGNED NOT NULL AUTO_INCREMENT;

[ 本帖最后由 kbc 于 2006-9-28 20:06 编辑 ]

19851021

There seems to have been a problem with the database of your Discuz!
Board

Discuz! info: MySQL Query Error

Time: 2006-10-17 2:23am
Script: /register.php

SQL: INSERT INTO cdb_members (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 ('戊酸软化', 'b62577994e54c475345fb5f5f015c417', '0d43d0b8',
'0', '0', '10', '219.133.142.101', '1161022985', '1161022985',
'1161022985', '0', 1,1,2,0,0,0,0,0,0, 'qwivnhzq@kejxos.com', '0000-00-00', '0',
'0', '0', '', '', '12', '', '0', '1', '0', '+8')
Error:  Duplicate entry '戊酸软化' for key 2
Errno.:  1062

Please check-up your MySQL server and forum scripts, similar errors
will not be reported again in recent 24 hours
If you have troubles in solving this problem, please visit Discuz!
Community http://www.Discuz.net.