WordPress.org

Ready to get started?Download WordPress

Forums

WordPress Database Error (7 posts)

  1. dlloyd
    Member
    Posted 8 years ago #

    Hi,

    I seem to have broken my database. When I log in to WP and go to the manage tab, all of my previous posts have vanished and I get the following message:-

    WordPress database error: [Got error -1 from table handler]
    SELECT DISTINCT * FROM wp_posts WHERE 1=1 AND post_date_gmt <= '2006-02-25 15:43:59' AND (post_status = "publish") GROUP BY wp_posts.ID ORDER BY post_date DESC LIMIT 0, 3

    If I go to the actual WP Blog, the same message is right at the top of the page and all the posts have vanished.

    Does anyone know how to fix this?

    Thanks
    Dave

  2. dlloyd
    Member
    Posted 8 years ago #

    Update on the above.

    This has now changed slightly to error 28:-

    WordPress database error: [Got error 28 from table handler]
    SELECT DISTINCT * FROM wp_posts WHERE 1=1 AND post_date_gmt <= '2006-02-25 16:08:59' AND (post_status = "publish") GROUP BY wp_posts.ID ORDER BY post_date DESC LIMIT 0, 3

    Dave

  3. Kassad
    Member
    Posted 8 years ago #

    It means that temp dirs are filled on disks at host.
    Contact them if you can or you should wait till they fix it.

  4. Shocker
    Member
    Posted 8 years ago #

    Hello i've the same problem on my site: http://www.acidwarez.net and i got the next error:

    WordPress database error: [Got error 28 from table handler]
    SELECT DISTINCT * FROM wp_posts WHERE 1=1 AND post_date_gmt <= '2006-02-25 20:42:59' AND (post_status = "publish") AND post_status != "attachment" GROUP BY wp_posts.ID ORDER BY post_date DESC LIMIT 0, 10

    The temp dir is cleaned every day and the problem persist ... Any solution for this big error ?

  5. vkaryl
    Member
    Posted 8 years ago #

    It really is a hosting problem. We can't help you with it here, your host will have to fix it.

    Sorry!

  6. dlloyd
    Member
    Posted 8 years ago #

    Thanks Kassad and vakryl for your responses

    Dave

  7. vkaryl
    Member
    Posted 8 years ago #

    Well, wish we could help.... good luck, and let us know if your host gets things resolved, okay?

Topic Closed

This topic has been closed to new replies.

About this Topic