5.4w+
社区成员
- 主页
- 问答
100分求助：谁见过如下mysql出错信息？如何解决？
在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
无效的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
...全文
请发表友善的回复…
发表回复
q3boy 2002-07-06
表损坏了。
用repair table命令修复
或用myisamchk -r thread.MYD程序修复
用repair table命令修复
或用myisamchk -r thread.MYD程序修复
nne998 2002-07-04
用
REPAIR TABLE 'tablename'
修复表。
REPAIR TABLE 'tablename'
修复表。
_Shakespeare 2002-07-03
楼上说的有道理
另外 thread.sticky=0 AND sticky=0是什么意思？
另外 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
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