
阿舍一時沒注意,就把 VPS 給重新啟動了,結果,等重啟完成後,去打開阿舍的網站時,就出現下面這種好幾排的錯誤訊息哩 ! 阿舍一開始以為是 Drupal 的問題,結果,查了一下才知道是 MySQL 的問題來的哩 !!
* user warning: Incorrect key file for table './ayu/menu_router.MYI'; try to repair it query: SELECT * FROM menu_router WHERE path IN ('node') ORDER BY fit DESC LIMIT 0, 1 in /var/www/www.xyz.com/public_html/includes/menu.inc on line 315.
* user warning: Incorrect key file for table './ayu/menu_router.MYI'; try to repair it query: SELECT * FROM menu_router WHERE path IN ('node') ORDER BY fit DESC LIMIT 0, 1 in /var/www/www.xyz.com/public_html/includes/menu.inc on line 315.
* user warning: Incorrect key file for table './ayu/menu_router.MYI'; try to repair it query: SELECT * FROM menu_router WHERE path IN ('node') ORDER BY fit DESC LIMIT 0, 1 in /var/www/www.xyz.com/public_html/includes/menu.inc on line 315.
* user warning: Incorrect key file for table './ayu/menu_router.MYI'; try to repair it query: SELECT * FROM menu_router WHERE path IN ('node') ORDER BY fit DESC LIMIT 0, 1 in /var/www/www.xyz.com/public_html/includes/menu.inc on line 315.
* user warning: Incorrect key file for table './ayu/menu_router.MYI'; try to repair it query: SELECT * FROM menu_router WHERE path IN ('node') ORDER BY fit DESC LIMIT 0, 1 in /var/www/www.xyz.com/public_html/includes/menu.inc on line 315.
這個問題果然是太瀟灑的把電腦給關了才產生的問題,因為沒有正常關機,所以,才會造成 MySQL 的資料庫有問題,Drupal 就會找不到資料而發生錯誤了。
解決的方法不難,只要從錯誤訊息中找出有問題的資料表 ( Table ) ,然後再用 repaire table 來修復就行了,以阿舍的資料庫叫 ayu , 有問題的資料表是 memu_router 為例,就用下面的指令來複複。
mysql -u root -p
use ayu;
repare table memu_router
- Arthur Yu's blog
- 瀏覽次數: 3336
- Send to friend

發表新回應