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

 找回密码
 立即注册

QQ登录

只需一步,快速开始

搜索

数据库常见错误信息和解决方法

[复制链接]
huaa 发表于 2007-10-27 02:34:07 | 显示全部楼层
Discuz! info: MySQL Query Error

User: huaa
Time: 2007-10-27 2:29am
Script: /index.php

SQL: SELECT uid, username, groupid, invisible, action, lastactivity, fid FROM [Table]sessions ORDER BY uid DESC LIMIT 500
Error: Record has changed since last read in table '[Table]sessions'
Errno.: 1020

Similar error report has beed dispatched to administrator before.





Discuz! info: MySQL Query Error

Time: 2007-10-27 9:23pm
Script: /index.php

SQL: SELECT s.sid, s.styleid, s.groupid='6' AS ipbanned, s.pageviews AS spageviews, s.lastolupdate, s.seccode, m.uid AS discuz_uid, m.username AS discuz_user, m.password AS discuz_pw, m.secques AS discuz_secques,
m.adminid, m.groupid, m.groupexpiry, m.extgroupids, m.email, m.timeoffset, m.tpp, m.ppp, m.posts, m.digestposts,
m.oltime, m.pageviews, m.credits, m.extcredits1, m.extcredits2, m.extcredits3, m.extcredits4, m.extcredits5,
m.extcredits6, m.extcredits7, m.extcredits8, m.timeformat, m.dateformat, m.pmsound, m.sigstatus, m.invisible,
m.lastvisit, m.lastactivity, m.lastpost, m.newpm, m.accessmasks, m.xspacestatus, m.editormode, m.customshow
FROM [Table]sessions s, [Table]members m
WHERE m.uid=s.uid AND s.sid='oc3K8G' AND CONCAT_WS('.',s.ip1,s.ip2,s.ip3,s.ip4)='218.85.170.96' AND m.uid='23'
AND m.password='e52dac5da75c93cf821cb40935a43f51' AND m.secques=''
Error: Record has changed since last read in table 's'
Errno.: 1020

有的电脑只显示空白页面.

[ 本帖最后由 huaa 于 2007-10-27 21:22 编辑 ]
回复

使用道具 举报

chr673673673 发表于 2007-11-8 08:57:37 | 显示全部楼层
资料恢复时  SS 的表前缀修改为 supe_     会改成以前的
然后出现

Discuz! info: MySQL Query Error

User: admin
Time: 2007-11-7 8:31pm
Script: /bbs/admincp.php

SQL: DROP TABLE IF EXISTS chenrong673.supe_ads
Error: DROP command denied to user 'chenrong67'@'localhost' for table 'supe_ads'
Errno.: 1142

怎么解决
回复

使用道具 举报

chr673673673 发表于 2007-11-8 08:58:57 | 显示全部楼层
资料备份前   把SS表前缀改成supe_   再备份  是不是就可以了?
回复

使用道具 举报

透视 发表于 2007-11-8 13:58:07 | 显示全部楼层
顶!!
回复

使用道具 举报

yaki520 发表于 2007-11-9 11:53:59 | 显示全部楼层
Discuz! info: MySQL Query Error


Time: 2007-11-9 11:52am
Script: /space.php

SQL: SELECT * FROM [Table]spacecaches WHERE uid='1'
Error: Table '.\ki54\[Table]spacecaches' is marked as crashed and should be repaired
Errno.: 145

Similar error report has beed dispatched to administrator before.

我出现这样的错误,能否修复,就是打开会员空间的时候出现的,谢谢!
回复

使用道具 举报

38377715 发表于 2007-12-16 10:55:37 | 显示全部楼层
Current template pack do not have a necessary language file 'templates.lang.php' or have syntax error!

这个是什么问题
回复

使用道具 举报

安琪安琪 发表于 2008-3-13 20:22:50 | 显示全部楼层
Discuz! info: Can not connect to MySQL server

Time: 2008-3-13 8:22pm
Script: /index.php

Error: Access denied for user 'username'@'srv96.one.com' (using password: NO)
数据库帐户密码不对,请联系空间商

Similar error report has beed dispatched to administrator before.


求助!!
回复

使用道具 举报

浪漫女孩 发表于 2008-3-15 18:17:57 | 显示全部楼层
学习了!!!!!!!!!!!!!!!!!!!!!!!
回复

使用道具 举报

w156445045 发表于 2008-4-8 18:47:44 | 显示全部楼层
学习了...
回复

使用道具 举报

快乐在兑现 发表于 2008-4-10 00:02:47 | 显示全部楼层
顶顶。。
回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2024-11-24 09:50 , Processed in 0.033390 second(s), 5 queries , Gzip On, Redis On.

Powered by Discuz! X3.4

Copyright © 2001-2023, Tencent Cloud.

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