[問題]SQL Error : 1030 Got error 127

[ericshih]

架設主機作業系統：Windows 2000 Pro
●快速架站程式：appserv-win32-2.2.0.exe
●您的上網方式：ADSL
●您安裝的程式：Apache + php + MySql
●您的 phpBB2 版本：phpBB (2.0.4)。
●錯誤代碼：代碼: [ code ]SQL Error : 1030 Got error 127 from table handler [ /code ]

SELECT f.*, p.post_time, p.post_username, u.username, u.user_id FROM (( phpbb_forums f LEFT JOIN phpbb_posts p ON p.post_id = f.forum_last_post_id ) LEFT JOIN phpbb_users u ON u.user_id = p.poster_id ) ORDER BY f.cat_id, f.forum_order

Line : 165
File : /XXX/site/public_html/forum/index.php

1.無法看見訪客的的貼文。
2.查看訪客IP位址，一樣出現錯誤。

從GOOGLE上搜尋已找到解決方法，再此分享！

至phpmyadmin --> select database (don't click on the table itself!) --> "SQL" --> "Run SQL query", enter::
Code:
REPAIR table phpbb_forums, phpbb_posts, phpbb_users;

--> Go.


修正完後會出現成功修正的地方。

Table Op Msg_type Msg_text
phpbb.phpbb_forums repair status OK
phpbb.phpbb_posts repair info Wrong bytesec: 0-0-0 at 34988; Skipped
phpbb.phpbb_posts repair warning Number of rows changed from 1134 to 1133
phpbb.phpbb_posts repair status OK
phpbb.phpbb_users repair status OK