WordPress Database Error

  • dlloyd

    (@dlloyd)


    19 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

Viewing 6 replies - 1 through 6 (of 6 total)
  • Thread Starter dlloyd

    (@dlloyd)

    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

    Kassad

    (@kassad)

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

    Shocker

    (@shocker)

    Hello i’ve the same problem on my site: https://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 ?

    vkaryl

    (@vkaryl)

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

    Sorry!

    Thread Starter dlloyd

    (@dlloyd)

    Thanks Kassad and vakryl for your responses

    Dave

    vkaryl

    (@vkaryl)

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

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘WordPress Database Error’ is closed to new replies.