数据库常见错误信息和解决方法集中讨论贴

Discuz! info: MySQL Query Error

User: 月影寻风
Time: 2008-6-14 5:19pm
Script: /admincp.php

SQL: SELECT COUNT(*) FROM [Table]virtualforums WHERE status=1 AND type='forum'
Error: Table 'a0614094537.[Table]virtualforums' doesn't exist
数据表缺失,请恢复备份数据

Similar error report has beed dispatched to administrator before.

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

怎么解决？啥意思

Discuz! info: MySQL Query Error

Time: 2008-6-16 2:36pm
Script: /forumdisplay.php

SQL: DELETE FROM [Table]sessions WHERE sid='CDipWA' OR lastactivity<(1213598208-) OR ('0'<>'0' AND uid='0') OR (uid='0' AND ip1='170' AND ip2='82' AND ip3='223' AND ip4='170' AND lastactivity>1213598208-60)
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 ') OR ('0'<>'0' AND uid='0') OR (uid='0' AND ip1='170' AND ip2='82' AND ip3='223'' at line 1
Errno.: 1064

Can not write to cache files, please check directory ./forumdata/ and ./forumdata/cache/ .
每次打开网站时就会显示这个,刷新一下就能正常显示,这是什么问题,怎么解决呀?我都重装好多次了,这个问题还没有解决............................

俺是菜鸟，初学dz，只能先说谢谢!

爬一下身心健康,好帖子

斑竹 我们站的帖子突然出现这个问题 前15页回复浏览都是正常的
一翻到16页 或者以后就出现错误提示  
谢谢帮忙解答一下该如何解决问题吧  麻烦了

Warning: mysql_query() [function.mysql-query]: Unable to save result set in F:\wwwroot\testg2000\wwwroot\include\db_mysql.class.php on line 66

Discuz! info: MySQL Query Error

User:
Time: 2008-6-20 5:23pm
Script: /viewthread.php

SQL: SELECT p.*, m.uid, m.username, m.groupid, m.adminid, m.regdate, m.lastactivity, 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.email, m.gender, m.showemail, m.invisible, mf.nickname, mf.site,
mf.icq, mf.qq, mf.yahoo, mf.msn, mf.taobao, mf.alipay, mf.location, mf.medals,
mf.sightml AS signature, mf.customstatus, mf.spacename
FROM [Table]posts p
LEFT JOIN [Table]members m ON m.uid=p.authorid
LEFT JOIN [Table]memberfields mf ON mf.uid=m.uid
WHERE p.tid='3323' AND p.invisible='0' ORDER BY dateline LIMIT 280, 10
Error: Table '[Table]posts' is marked as crashed and should be repaired
Errno.: 1194

Similar error report has beed dispatched to administrator before.

请哪位大虾能指点下    怎么修改6.1版的用户名

我把论坛后台的templates文件夹删掉了三个...怎么办啊?

後台的 系統錯誤記錄 有很多行這個, 有時論壇更會好慢, 不知有沒有關係?
rss.php : MySQL server has gone away - INSERT INTO cdb_rsscaches (lastupdate, fid, tid, dateline, forum, author, subject, description)

之前有del了一堆user, 結果明明只有幾萬人, 但是當新開user account 時, uid 會由幾千萬開始, 這個會不會是原因?

文件及目录属性



Warning: dir(E:\wwwroot\emcchina\wwwroot\bbs\./forumdata/logs) [function.dir]: failed to open dir: No such file or directory in E:\wwwroot\emcchina\wwwroot\bbs\admin\tools.inc.php on line 781

Fatal error: Call to a member function read() on a non-object in E:\wwwroot\emcchina\wwwroot\bbs\admin\tools.inc.php on line 782


这是怎么回事。。