WordPress.org

Forums

Database error: [Got error 28 from table handler] (8 posts)

  1. thegreatzandrini
    Member
    Posted 10 years ago #

    I recently upgraded my WordPress, and for some reason I couldn't log in via Internet Explorer. I've been using Safari, but I tried again today to login using IE and it worked! but for some reason, now all of my entries are gone! I get this error:

    Database error: [Got error 28 from table handler]
    SELECT DISTINCT * FROM wp_posts WHERE 1=1 AND post_date_gmt <= '2005-01-26 03:58:59' AND (post_status = "publish") GROUP BY wp_posts.ID ORDER BY post_date DESC LIMIT 5

    What do I do? Can I import them from a database backup, (and if so, how?) or do I have to reinstall, or what? how did this happen?
    thanks,
    Zandra

  2. 7milesdown
    Member
    Posted 10 years ago #

    Did you backup? Just clear the mysql tables then reapply your backup.

  3. Mark (podz)
    Support Maven
    Posted 10 years ago #

    Error 28 - email your host - it's their problem, not yours.

  4. James Huff
    Volunteer Moderator
    Posted 10 years ago #

  5. protechs
    Member
    Posted 10 years ago #

    It appears I have the same problem (different specifics) as a previous poster. Everything was fine, then I went to view the blog and I got this error:

    Database error: [Got error 28 from table handler]
    SELECT * FROM wp_posts WHERE 1=1 AND (post_status = "publish" OR post_author = 1 AND post_status != 'draft') GROUP BY wp_posts.ID ORDER BY post_date DESC LIMIT 15
    No posts found.

    I have NO idea what to do now.

    Anyone read "database" ease. I can go and view each post individually if I go to edit comments and "view post" and they're fine. It just won't organize them to edit posts or view the blog at all - nothing displays but some color and the error message at the top.

    ???

  6. James Huff
    Volunteer Moderator
    Posted 10 years ago #

    Again, this is something that your webhost needs to fix.

    http://codex.wordpress.org/Answers-Trouble_Shooting#Error_28

  7. protechs
    Member
    Posted 10 years ago #

    What do I tell them they need to do. I had to hand-hold the last time when they upgraded their php version, and send them your comments. Should I send them the link above?

    http://codex.wordpress.org/Answers-Trouble_Shooting#Error_28

    Thank you.

  8. protechs
    Member
    Posted 10 years ago #

    They were having general problems....
    It appears they repaired it.

    Thank you again.

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags

No tags yet.