Discuz!官方免费开源建站系统

 找回密码
 立即注册

QQ登录

只需一步,快速开始

搜索

求助,2.5F版升级到4.1出现错误

[复制链接]
newtt 发表于 2006-8-10 22:15:00 | 显示全部楼层 |阅读模式
升级过程中没有出现错误提示,只是在打开网页时提示:

Discuz! info: MySQL Query Error

Time: 2006-8-10 10:24pm
Script: /bbs/index.php

SQL: SELECT nextrun FROM cdb_crons WHERE available>'0' AND nextrun>'1155219852' ORDER BY nextrun LIMIT 1
Error: Table 'bbs.cdb_crons' doesn't exist
数据表缺失,请恢复备份数据

An error report has been dispatched to our administrator.
 楼主| newtt 发表于 2006-8-10 22:20:06 | 显示全部楼层
这个解决了   找到4.1安装文件里建立crons表的脚本   
但又有新问题了:

Discuz! info: MySQL Query Error

Time: 2006-8-10 10:31pm
Script: /bbs/index.php

SQL: SELECT ph.title, ph.code, p.identifier FROM cdb_plugins p
LEFT JOIN cdb_pluginhooks ph ON ph.pluginid=p.pluginid AND ph.available='1'
WHERE p.available='1' ORDER BY p.identifier
Error: Table 'bbs.cdb_pluginhooks' doesn't exist
数据表缺失,请恢复备份数据

An error report has been dispatched to our administrator.
回复

使用道具 举报

 楼主| newtt 发表于 2006-8-10 22:23:26 | 显示全部楼层
哈哈   搞定
回复

使用道具 举报

 楼主| newtt 发表于 2006-8-10 23:35:45 | 显示全部楼层
Time: 2006-8-10 11:46pm
Script: /bbs/admincp.php

SQL: SELECT s.sid, s.styleid, s.groupid='6' AS ipbanned, m.uid AS discuz_uid, m.username AS discuz_user, m.password AS discuz_pw, m.adminid, m.groupid, m.email, m.timeoffset,m.tpp, m.ppp, m.credit, m.timeformat, m.dateformat, m.signature, m.invisible, m.lastvisit, m.lastactivity as user_lastactivity, m.lastpost, m.newpm, m.accessmasks, m.regdate FROM cdb_sessions s, cdb_members m WHERE m.uid=s.uid AND s.sid='C0O3Rt' AND CONCAT_WS('.',s.ip1,s.ip2,s.ip3,s.ip4)='218.58.32.207' AND m.uid='1' AND m.password='ee950e47d2a4a5c6d94055ef7ef24195' AND m.secques='5efe2236'
Error: Unknown column 'm.credit' in 'field list'
程序文件跟数据库有冲突,请使用正确的程序文件上传上去覆盖

An error report has been dispatched to our administrator.
回复

使用道具 举报

 楼主| newtt 发表于 2006-8-10 23:39:51 | 显示全部楼层
Discuz! info: MySQL Query Error

Time: 2006-8-10 11:51pm
Script: /bbs/admincp.php

SQL: SELECT s.sid, s.styleid, s.groupid='6' AS ipbanned, m.uid AS discuz_uid, m.username AS discuz_user, m.password AS discuz_pw, m.adminid, m.groupid, m.email, m.timeoffset,m.tpp, m.ppp, m.credit, m.timeformat, m.dateformat, m.signature, m.invisible, m.lastvisit, m.lastactivity as user_lastactivity, m.lastpost, m.newpm, m.accessmasks, m.regdate FROM cdb_sessions s, cdb_members m WHERE m.uid=s.uid AND s.sid='C0O3Rt' AND CONCAT_WS('.',s.ip1,s.ip2,s.ip3,s.ip4)='218.58.32.207' AND m.uid='1' AND m.password='ee950e47d2a4a5c6d94055ef7ef24195' AND m.secques='5efe2236'
Error: Table 'bbs.cdb_members' doesn't exist
数据表缺失,请恢复备份数据

An error report has been dispatched to our administrator.


又变了   晕
回复

使用道具 举报

 楼主| newtt 发表于 2006-8-11 09:13:09 | 显示全部楼层
discuz.php : You have an error in your SQL syntax near 'cdb_favorites FROM cdb_favorites LEFT JOIN cdb_forums USING(fid) WHERE cdb_favor' at line 1 - DELETE cdb_favorites FROM cdb_favorites LEFT JOIN cdb_forums USING(fid) WHERE cdb_favorites.fid>0 AND cdb_forums.fid ...

回复

使用道具 举报

 楼主| newtt 发表于 2006-8-11 09:20:28 | 显示全部楼层
Discuz! info: MySQL Query Error

User: Tristan
Time: 2006-8-11 9:21am
Script: /bbs/discuz.php

SQL: DELETE cdb_favorites FROM cdb_favorites LEFT JOIN cdb_forums USING(fid) WHERE cdb_favorites.fid>0 AND cdb_forums.fid IS NULL
Error: You have an error in your SQL syntax near 'cdb_favorites FROM cdb_favorites LEFT JOIN cdb_forums USING(fid) WHERE cdb_favor' at line 1
Errno.: 1064
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

手机版|小黑屋|Discuz! 官方站 ( 皖ICP备16010102号 )star

GMT+8, 2025-1-9 20:01 , Processed in 0.037058 second(s), 4 queries , Gzip On, Redis On.

Powered by Discuz! X3.4

Copyright © 2001-2023, Tencent Cloud.

快速回复 返回顶部 返回列表