January 31st, 2006

WordPress database error

WordPress database error: [Can't create/write to file '/tmp/#sql36b_2af2fe_0.MYI' (Errcode: 28)]
SELECT DISTINCT * FROM wp_posts WHERE 1=1 AND post_date_gmt <= '2006-01-30 09:37:59' AND (post_status = "publish" OR post_author = 1 AND post_status != 'draft' AND post_status != 'static') AND post_status != "attachment" GROUP BY wp_posts.ID ORDER BY post_date DESC LIMIT 0, 10

這一連兩天都發生以上的 error, 令 no-joe:blog 有幾個小時不能運作, 要經 web hosting 公司 Media Temple 方面 restart apache server 後方能重生, 實在令我覺得很煩, 如果明天再發生 error 我即轉 web hosting。


Share on Facebook | January 31st, 2006 |

7 Responses to “WordPress database error”

  1. Knight
    January 31st, 2006 at 9:56 pm

    如果要轉web hosting, 給我個email ? 我在作私人hosting
    knight[at]ashodin[at]gmail[dot]com

  2. 米曹
    January 31st, 2006 at 10:45 pm

    我要求的是一個月中有一天 down server 都不能接受到, 以及我有數個 domain names 要 host, 而 cs 要有很速的回應, 是不是要求很高? 其實 (mt) 已做得很好。

  3. Knight
    February 1st, 2006 at 7:29 am

    我稍微看了一下MT的價錢,那樣的價錢再加上那樣的容量,的確是無法要求多多..

  4. 米曹
    February 1st, 2006 at 7:14 pm

    講真的容量其實很平很平, 我覺得 hosting 最重要的是 stability。容量其實很次要的。

  5. Knight
    February 1st, 2006 at 8:30 pm

    有機會試試看我的主機.. 呵呵..

  6. 米曹
    February 1st, 2006 at 9:15 pm

    有機會的!

  7. jing
    June 29th, 2006 at 7:35 am

    可以請問您是怎麼在mt下安裝worDpress嗎？我不知道怎麼設定database的user權限？還是只要創建一個空的database即可？ 找不到可以設定user權限的地方謝謝

Leave a Reply