|
Discuz! info: MySQL Query
Error
User: http://www.stor.com.cn
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
即可。
|
