Support » Plugins » wpblacklist caused error – all posts gone

  • I installed wpblacklist, following the directions exactly. And suddenly all the posts are gone (posts, not comments) and I get this error message:

    Database error: [Got error 28 from table handler]
    SELECT DISTINCT * FROM wp_posts WHERE 1=1 AND post_date_gmt <= ‘2004-12-30 21:24:59’ AND (post_status = “publish”) GROUP BY wp_posts.ID ORDER BY post_date DESC LIMIT 20

    I deactivated the plugin and that did nothing, so I removed it completely. But I still have the problem. Please help!

Viewing 7 replies - 1 through 7 (of 7 total)
  • Mark (podz)

    (@podz)

    Support Maven

    Error 28:
    This is a MySQL error and has nothing to do with WordPress directly. You should probably contact your host about it. Some users have reported that running a “repair table� command in phpMyAdmin fixed the problem.

    If it has nothing to do with WordPress, why did it happen when I installed the plugin?

    Mark (podz)

    (@podz)

    Support Maven

    Error 28 really is nothing whatsoever to do with WP – honest.

    Moderator James Huff

    (@macmanx)

    Volunteer Moderator 🚀

    For more evidence, try searching these forums for your error.

    I tried a repair and got this:

    Repairing Database
    jcarey_AliasJaneDoe is now being repaired.

    jcarey_AliasJaneDoe.blacklist
    error : 28 when fixing table
    error : Can’t copy datafile-header to tempfile, error 9
    status : Operation failed
    jcarey_AliasJaneDoe.wp_categories OK
    jcarey_AliasJaneDoe.wp_comments OK
    jcarey_AliasJaneDoe.wp_linkcategories OK
    jcarey_AliasJaneDoe.wp_links OK
    jcarey_AliasJaneDoe.wp_optiongroup_options OK
    jcarey_AliasJaneDoe.wp_optiongroups OK
    jcarey_AliasJaneDoe.wp_options OK
    jcarey_AliasJaneDoe.wp_optiontypes OK
    jcarey_AliasJaneDoe.wp_optionvalues OK
    jcarey_AliasJaneDoe.wp_post2cat OK
    jcarey_AliasJaneDoe.wp_postmeta OK
    jcarey_AliasJaneDoe.wp_posts OK
    jcarey_AliasJaneDoe.wp_users OK

    —–

    The one that’s giving the error says blacklist. Clearly I caused it by installing the plugin. I’m confused now.

    Mark (podz)

    (@podz)

    Support Maven

    The Error28 and how to handle it has been around before Blacklist happened along.

    Email your host with all the details and tell them to fix it, but it is a system error that has not been caused by WP.

    Okay, I’ve been reading the error 28 threads and better understand it now. Thanks. And since I’m not using anywhere near all my space, I guess it’s on my host’s end. I’ve e-mailed them.

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘wpblacklist caused error – all posts gone’ is closed to new replies.