Discuz! info: MySQL Query Error
User: wingzero
Time: 2009-10-31 11:03am
Script: /bbs/index.php
SQL: SELECT a.aid, a.attachment, a.remote, t.tid, t.subject
FROM [Table]attachments a
INNER JOIN [Table]threads t ON t.tid=a.tid AND displayorder>='0'
WHERE a.readperm='0' AND a.isimage='1' AND (a.filetype IN ('image/pjpeg','image/png') OR a.attachment LIKE '%.jpg' OR a.attachment LIKE '%.png' OR a.attachment LIKE '%.jpeg') AND a.dateline>1254366219 GROUP BY a.tid
ORDER BY a.dateline DESC
LIMIT 0, 30;
Error: Got error 22 from storage engine
Errno.: 1030
Similar error report has been dispatched to administrator before.
到 http://faq.comsenz.com 搜索此错误的解决方案
论坛之前出现这个错误,后来,使用官方的tools.php工具修复下,就没事了。
但是,现在论坛所有帖子里的附件消失了。
检查了服务器那边的附件,全部存在!
现在是情况缓存也试了,修复主题也试了,就是无法恢复附件!!
纳闷啊!! |