最近幾天,在儲存草稿時,第一次儲存是可以的,但當第二次要儲存時,並沒有跳出儲存成功的訊息,且當轉成定稿發表時,會出現更新錯誤。
查了一下sql_error.log,出現了許多如下列的訊息:
14-03-2007 20:13:07 ERROR - The following query =
SELECT v.id AS id, d.id AS field_id, v.field_value AS field_value,
d.field_name AS field_name, d.field_type AS field_type,
d.field_description AS field_description,
v.article_id AS article_id, v.blog_id AS blog_id
FROM lt_custom_fields_values v
RIGHT OUTER JOIN lt_custom_fields_definition d
ON v.article_id = 1071 AND v.field_id = d.idgenerated the following error message =
Table '.\lifetype\lt_custom_fields_values' is marked as crashed and should be repaired
C:\AppServ\www\lifetype\class\logger\logger\logger.class.php(157): patternlayout.format
C:\AppServ\www\lifetype\class\logger\logger\logger.class.php(137): logger.log
C:\AppServ\www\lifetype\class\dao\model.class.php(146): logger.error
C:\AppServ\www\lifetype\class\dao\model.class.php(462): customfieldsvalues.execute
C:\AppServ\www\lifetype\class\dao\customfields\customfieldsvalues.class.php(131): customfieldsvalues.delete
C:\AppServ\www\lifetype\class\dao\articles.class.php(1021): customfieldsvalues.removearticlecustomfields
C:\AppServ\www\lifetype\class\dao\articles.class.php(968): articles.updatearticlecustomfields
C:\AppServ\www\lifetype\class\dao\commentscommon.class.php(307): articles.updatearticle
C:\AppServ\www\lifetype\class\dao\trackbacks.class.php(160): commentscommon.deletecomment
C:\AppServ\www\lifetype\plugins\validatetrackback\pluginvalidatetrackback.class.php(170): trackbacks.deletetrackback
C:\AppServ\www\lifetype\plugins\validatetrackback\pluginvalidatetrackback.class.php(74): pluginvalidatetrackback.validate
C:\AppServ\www\lifetype\class\plugin\pluginmanager.class.php(344): pluginvalidatetrackback.process
C:\AppServ\www\lifetype\class\action\addtrackbackaction.class.php(155): pluginmanager.notifyevent
C:\AppServ\www\lifetype\class\controller\controller.class.php(310): addtrackbackaction.perform
C:\AppServ\www\lifetype\index.php(51): blogcontroller.process
C:\AppServ\www\lifetype\trackback.php(19): include_once
根據其中一行
Table '.\lifetype\lt_custom_fields_values' is marked as crashed and should be repaired
應該是指資料庫裡的table損毀了,於是先利用phpmyadmin想試著修復,但發現該table找不到修復資料表的地方,只出現下列的訊息:
錯誤
SQL 語法:
SHOW INDEX FROM `lt_custom_fields_values` ;
MySQL 傳回:
#145 - Table '.\lifetype\lt_custom_fields_values' is marked as crashed and should be repaired
接著便搜尋了論壇裡有類似相關的文章,大部分的人都是提到用repair table的指令去修復。
但我的問題來了,使用mysql命令列的方式進入後,我輸入了
mysql>repair table lt_custom_fields_values
可是它只停在
->|
想請問,我接著該如何去修復它呢?是它會自動修復嗎?還是必須下指令?該下何指令?
很抱歉!因為是第一次遇到如此的情形,不知該如何處理下去,看了官方的英文說明,可是實在不懂耶。