100分求助:谁见过如下mysql出错信息?如何解决?

snowwin88 2002-07-03 06:06:08
在vBulletin 2.2.6里数据库发生错误:

无效的SQL:
SELECT

thread.threadid
FROM thread
WHERE thread.forumid = 13
AND thread.sticky=0
AND thread.visible=1
AND lastpost >= 1023098502 AND sticky=0

ORDER BY sticky DESC, lastpost DESC
LIMIT 0,25
mysql数据库错误: Got error 127 from table handler

mysql数据库错误号: 1030

时间: Wednesday 03rd of July 2002 06:01:42 PM
脚本: http://oao.dns2go.com/vbb/vbb/forumdisplay.php?s=0ffa5012cc7822ea06a8c3afd3110eed&forumid=13
涉及: http://oao.zuasoft.com/vbb/index.php?s=0ffa5012cc7822ea06a8c3afd3110eed
...全文
30 点赞 收藏 4
写回复
4 条回复
切换为时间正序
请发表友善的回复…
发表回复
q3boy 2002-07-06
表损坏了。
用repair table命令修复
或用myisamchk -r thread.MYD程序修复
回复
nne998 2002-07-04


REPAIR TABLE 'tablename'

修复表。
回复
_Shakespeare 2002-07-03
楼上说的有道理
另外 thread.sticky=0 AND sticky=0是什么意思?
回复
lurel 2002-07-03
SELECT

thread.threadid
FROM thread
WHERE thread.forumid = 13
AND thread.sticky=0
AND thread.visible=1
AND lastpost >= 1023098502 AND sticky=0

ORDER BY sticky DESC, lastpost DESC
LIMIT 0,25
这条sql语句有误,应该是

SELECT

thread.threadid
FROM thread
WHERE thread.forumid ='13'
AND thread.sticky='0'
AND thread.visible=1
AND lastpost >= '1023098502' AND sticky='0'

ORDER BY sticky DESC, lastpost DESC
LIMIT 0,25
回复
发动态
发帖子
MySQL
创建于2007-09-28

5.4w+

社区成员

MySQL相关内容讨论专区
申请成为版主
社区公告
暂无公告