Discuz! info: MySQL Query Error

dn001 2009-06-08 16:36:20

Time: 2008-1-25 10:24am
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, m.xspacestatus, mf.nickname, mf.site,
mf.icq, mf.qq, mf.yahoo, mf.msn, mf.taobao, mf.alipay, mf.location, mf.medals, mf.avatar, mf.avatarwidth,
mf.avatarheight, 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='149216' AND p.invisible='0' ORDER BY dateline LIMIT 0, 25
Error: Table '.players[Table]posts' is marked as crashed and last (automatic?) repair failed
Errno.: 144

Similar error report has beed dispatched to administrator before.

解决办法：
如果您的服务器是独立主机强烈建议使用命令行方式进行修复:
修复前将mysql服务停止。
如果是Win主机，打开命令行方式，然后进入到mysql的/bin目录。
执行myisamchk -r d:mysqldatadiscuz*.MYI
其中d:mysqldatadiscuz换成您的数据库所在路径。
如果是类Unix主机，直接使用myisamchk -r 数据库目录*.MYI
即可。