• I logged onto my site to see this today:
    WordPress database error: [Got error 28 from table handler]
    SELECT DISTINCT * FROM wp_posts WHERE 1=1 AND post_date_gmt <= '2006-08-12 18:22:59' AND (post_status = "publish" OR post_author = 1 AND post_status != 'draft' AND post_status != 'static') AND post_status != "attachment" GROUP BY wp_posts.ID ORDER BY post_date DESC LIMIT 0, 10

    I’ve gone into phpMyAdmin and cleared the available caches, but the error remains. I saw in the help that this mean the server cache needs to be cleared, but NONE of my other blogs are affected… it’s just this Word Press blog.

    Anyone know what else I can do?

Viewing 12 replies - 1 through 12 (of 12 total)
  • Thread Starter brandon206

    (@brandon206)

    OK.. I cleared the posts through truncation, but NOW I can’t get my links to show up on my home page… yet they’re all still listed in the admin control page.

    Thread Starter brandon206

    (@brandon206)

    And yes, I already looked at that help.

    Why is this an issue for WordPress and none of my other programs that do blogs?

    its not a WP issue, its a MySQL issue. And instead of ass-uming its a WP problem, I reccommend the same query on Google.

    https://www.google.com/search?hl=en&q=Got+error+28+from+table+handler&btnG=Google+Search

    “Results 1 – 10 of about 928,000 for Got error 28 from table handler. (0.31 seconds) “

    hmmm.. must not be a WP thing eh?

    You needed to go into phpmyadmin and repair your WP tables, and if you had read the very first post that was returned from that search (that you claimed to have looked at) you would have read that straight-away.

    Thread Starter brandon206

    (@brandon206)

    No need to be an ass. I simply asked, because I’ve been running other blog programs for months with no such problems. If the cache was full then that would affect ALL tables and databses, no?

    Besides that, I DID repair all my tables, before I even posted the initial message and it didn’t work.

    We’ll see what my host says. I sent a request for the cache to be cleared.

    Brandon,

    Don’t worry about whooami, he is just a little prick, running around trying to make himself feel better by attempting to make you feel stupid. Don’t let him. Good observation on your part about how he was acting…

    Whooami… you gonna grow up anytime soon?

    nice trolling post, splanters.

    @ brandon206 : you said “..cleared the available caches”, perhaps thats another term for repairing the db, in which case my apologies are due.

    whooami,

    Whatever dude. I’ll troll or do whatever if it’ll get you to stop being a prick to newbies. Amazing as it may seem, but not everyone has your level of knowledge with wordpress, php and the like… Could be some people have actual lives away from the computer, but who knows, right except you, right?

    Ok, I’ve said my peace with you. No sense wasting anymore of my time.

    Thread Starter brandon206

    (@brandon206)

    I cleared the database caches, but not the server cache. However, my host did so and I’m back up… though I lost A LOT of data (mainly pages)

    That’s too bad, Brandon. It’s a good idea in future to backup your database on a daily basis if you input a lot, or at least A: weekly; B: any time you make some major change.

    Did you think to check with your host to see if they had a more recent backup that you could use? Might get back a little of your data. Also, you could check the google cache of your pages to see if you can get the text.

    Thread Starter brandon206

    (@brandon206)

    I’m not too worried, because I’m still setting things up how I like, so the pages were to get an idea of what I wanted, but had very little information on them.

    The ones that had a lot of information I designed in an HTML designer, so i have them saved in that format and can simply upload them again. phew!

    I have noticed some changes to the sidebar (which looks like it went to the original format) and the page links (which are now alphabatized, but not in ‘page order’ listing)… but the rest of my links and data is still there.

    I back up my other blog weekly, daily if I do some heavy posting, so I’ll probably do the same when I get this one up and running how I like.

    That’s good! Glad things are more or less copacetic…. Post back if you need something else, ‘kay?

Viewing 12 replies - 1 through 12 (of 12 total)
  • The topic ‘[Got error 28 from table handler]’ is closed to new replies.