跟新论坛缓存出错

跟新论坛缓存出现下面错误提示信心


我知道是数据表结构有问题

希望高手能够帮忙想能怎么解决呢？

Discuz! info: MySQL Query Error

User: 比比特
Time: 2006-1-17 2:39pm
Script: /admincp.php

SQL: SELECT a.tid, a.attachment, p.subject FROM cdb_attachments a LEFT JOIN cdb_posts p USING(pid) WHERE p.fid IN() and a.filetype='image/pjpeg' ORDER BY aid DESC LIMIT 0, 15
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 ') and a.filetype='image/pjpeg' ORDER BY aid DESC LIMIT 0, 15' a
Errno.: 1064

Similar error report has beed dispatched to administrator before.

修复一下数据库试试

mysqlcheck -u root -p -r xxx （数据库名）

WHERE p.fid IN()
那个括号里面本来应该有值的,现在没有值,所以语法错误了~~