Database Meltdown…..help needed

  • Hello there can some one help me with this one…

    I am getting the following error message:

    WordPress database error: [Can’t open file: ‘wp_posts.MYD’. (errno: 145)]
    SELECT DISTINCT * FROM wp_posts WHERE 1=1 AND post_date_gmt <= ‘2005-11-24 10:20:59’ AND (post_status = “publish” OR post_author = 1 AND post_status != ‘draft’ AND post_status != ‘static’) GROUP BY wp_posts.ID ORDER BY post_date DESC LIMIT 0, 10

    You can see it at https://www.vinosense.com

    I’ve got into phpMYADMIN and had a peek and I’m unable to browse the wp_posts at all

    Can anyone give me some help with this as I’m stuck

    Many Thanks

    Dave

Viewing 7 replies - 1 through 7 (of 7 total)

  • Email your host’s support. That is an error only they can fix (it’s not too serious though).

    Thread Starter tehuringa

    (@tehuringa)

    Thanks for the answer…ok shall do….what shall I do…just copy the error message and send it off to them….as you can see I’m a total techonoob

    You can do – or just tell them the mysql database needs repairing and why.

    Thread Starter tehuringa

    (@tehuringa)

    Thanks agian….

    Cheers

    Dave

    Thread Starter tehuringa

    (@tehuringa)

    OK….host said they can’t help me out.

    In phpMYAdmin I can’t even open the wp_posts file to repair it…..Am I doomed????

    Any ideas how to fix it?

    Cheers

    Dave

    Thread Starter tehuringa

    (@tehuringa)

    Fixed…..hosts what do they know…pfffffffffttttttt

    Was able to repair from myphpADMIN

    Thanks

    Dave

    One year on (nearly to the day) and this post still helped me…
    My database also suddenly gave the same error – I just went to MyPHP Admin and into the MySQL database table, and selected the entry ‘wp_posts’ and selected ‘repair’ – 5 seconds later it all worked!

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Database Meltdown…..help needed’ is closed to new replies.

Tags