在本机上:装Discuz!EXP 2.0.1,用官方给的转换程序,把DV7.1.0ACC转到DZ4.1.0,调试一切正常。然后从论坛后台“资料备份”为MySQL4.0.x,上传到DZ官方虚拟主机上。
在主机上:从论坛后台“资料恢复”,顺利恢复。问题来了,只要添加新的东西就出现Discuz! info: MySQL Query Error提示。如下,红字为我的描述,等号条隔开各种出错情况:
我知道后台升级数据库可以解决部分问题。但是,请教各位,能否避免上传后出现此类问题??就是跟在本地一样能正常使用,谢谢!
第二次回复帖子
Discuz! info: MySQL Query Error
User: 新月奇明
Time: 2006-6-13 6:14pm
Script: /post.php
SQL: INSERT INTO cdb_posts (fid, tid, first, author, authorid, subject, dateline, message, useip, invisible, anonymous, usesig, htmlon, bbcodeoff, smileyoff, parseurloff, attachment)
VALUES ('13', '2871', '0', '新月奇明', '2', '', '1150193688', '测试测试测试测试', '222.79.63.113', '0', '0', '1', '0', '-1', '-1', '', '0')
Error: Duplicate entry '0' for key 1
Errno.: 1062
An error report has been dispatched to our administrator.
=====================================
发表话题
Discuz! info: MySQL Query Error
User: 新月奇明
Time: 2006-6-13 6:17pm
Script: /post.php
SQL: INSERT INTO cdb_threads (fid, readperm, price, iconid, typeid, author, authorid, subject, dateline, lastpost, lastposter, displayorder, digest, blog, poll, attachment, subscribed, moderated)
VALUES ('13', '0', '0', '0', '0', '新月奇明', '2', '测试测试', '1150193872', '1150193872', '新月奇明', '0', '0', '0', '0', '0', '0', '0')
Error: Duplicate entry '0' for key 1
Errno.: 1062
An error report has been dispatched to our administrator.
=====================================
添加论坛
Discuz! info: MySQL Query Error
User: 新月奇明
Time: 2006-6-14 9:35am
Script: /admincp.php
SQL: INSERT INTO cdb_forums (fup, type, name, status, allowsmilies, allowbbcode, allowimgcode, allowblog, allowtrade)
VALUES ('25', 'forum', '新论坛名称', '1', '1', '1', '1', '1', '3')
Error: Duplicate entry '0' for key 1
Errno.: 1062
Similar error report has beed dispatched to administrator before.
=====================================
添加特殊用户组
Discuz! info: MySQL Query Error
User: 新月奇明
Time: 2006-6-14 9:39am
Script: /admincp.php
SQL: INSERT INTO cdb_usergroups (type, grouptitle, stars, color, groupavatar, allowvisit, readaccess, allowpost, allowsigbbcode)
VALUES ('special', '再好级', '9', '', '', '1', '1', '1', '1')
Error: Duplicate entry '0' for key 1
Errno.: 1062
Similar error report has beed dispatched to administrator before.
=====================================
[ 本帖最后由 不太行 于 2006-6-16 07:45 编辑 ] |