| 订阅 | 在线投稿
分享
 
 
 

Discuz! info: MySQL Query Error

来源:互联网  宽屏版  评论
2008-05-31 20:24:09

本文为【Discuz! info: MySQL Query Error】的汉字拼音对照版显示拼音

Discuz! info: MySQL Query Error

User: http://www.11players.net/

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

LEFT JOIN

LEFT JOIN

WHERE p.tid='149216' AND p.invisible='0' ORDER BY dateline LIMIT 0, 25

Error: Table '.\players\

Errno.: 144

Similar error report has beed dispatched to administrator before.

jiejuebanfa

ruguonindefuwuqishidulizhujiqiangliejianyi使shiyongminglingxingfangshijinxingxiufu:

xiufuqianjiangmysqlfuwutingzhi

ruguoshiWinzhujidakaiminglingxingfangshiranhoujinrudaomysqlde/binmulu

zhixingmyisamchk -r d:\mysql\data\discuz\*.MYI

qizhongd:\mysql\data\discuz\huanchengnindeshujukusuozailujing

ruguoshileiUnixzhujizhijie使shiyongmyisamchk -r shujukumulu\*.MYI

jike

原文
 
Discuz! info: MySQL Query Error User: http://www.11players.net/ 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:\mysql\data\discuz\*.MYI 其中d:\mysql\data\discuz\换成您的数据库所在路径。 如果是类Unix主机,直接使用myisamchk -r 数据库目录\*.MYI 即可。
󰈣󰈤
 
 
 
>>返回首页<<
 
 热帖排行
 
 
 
静静地坐在废墟上,四周的荒凉一望无际,忽然觉得,凄凉也很美
©2005- 王朝网络 版权所有