Sudden Database failure while editing categories

  • Resolved No_No

    (@nicolediana)


    20 years, 8 months ago

    Wow! I was happily editing category names and then navigated to this site to enter a post regarding a comment question. When I reloaded my blog, the posts were not showing. I get this error:

    WordPress database error: [Got error 28 from table handler]
    SELECT DISTINCT * FROM wp_posts WHERE 1=1 AND post_date_gmt <= ‘2005-09-13 04: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, 5

    It shows my categories in the blog and in my admin section, everything is fine except the “manage” tab. That produces the same error.

    I have no clue what to do now.

Viewing 5 replies - 1 through 5 (of 5 total)
  • Thread Starter No_No

    (@nicolediana)

    20 years, 8 months ago

    Ah, I typed the wrong info into search. I tried again and see this matter has been addressed before: http://wordpress.org/support/topic/21780

    I’ll take it from here. 🙂

    Beel

    (@beel)

    20 years, 8 months ago

    Is it from a addin to your sidebar? What do you have beneath the search form?

    Edit: “Never mind,” said Roseanne Roseannadanna

    Thread Starter No_No

    (@nicolediana)

    20 years, 8 months ago

    I found another error in the server logs and would like some clarification, if possible, to be sure this is still a mySQL issue.

    The error I see is:

    Cannot modify header information – headers already sent by (output started at /blog/wp-includes/wp-db.php:98) in Unknown on line 0

    I saw in searching for others with this problem that is has been addressed many times but in the posts I dug through, I didn’t see any that addressed the database file itself and “unknown online 0”.

    My host hasn’t responded yet (probably sleeping). I wasn’t editing templates at the time of the “crash”, just changing post categories. Don’t know what happened. 🙁

    Mark (podz)

    (@podz)

    20 years, 8 months ago

    Use your ftp client and check that all the files in /wp-admin and /wp-includes are present and the right size – download WP from here again to use in comparison. It could be that something there has gone wrong.

    Thread Starter No_No

    (@nicolediana)

    20 years, 8 months ago

    Thank you for the reply. I woke up to a reply from my host telling me nothing was wrong and when I navigated to my blog, all was well. I think I’ll do nightly backups of the DB from now on to be on the safe side.

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

The topic ‘Sudden Database failure while editing categories’ is closed to new replies.