Wpsweep Shows 176 more posts than there are. Any ideas please Lester?

  • Resolved carlbradbrook

    (@carlbradbrook)


    7 years, 9 months ago

    Hi Lester,

    I am using wp sweep to clean up my data base.

    Wpsweep says there are 233 posts BUT I counted and there
    are only 5 posts and 52 pages making a total of 57.

    Any ideas how to check on the actual number of posts
    as I have trashed and deleted many over a few years
    I’m thinking perhaps the trashed posts are still in the database
    and if so how would i delete them?

    Many thanks !
    Carl ??

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author Lester Chan

    (@gamerz)

    Your count is inaccurate. The plugin queries directly from the database. So some posts are invisible to you.

    You can check the query from the plugin code directly https://github.com/lesterchan/wp-sweep/blob/master/wp-sweep.php#L273

    Thread Starter carlbradbrook

    (@carlbradbrook)

    Hi Lester
    Thanks for getting back to me!

    How do I go about finding and deleting those old posts from the database
    as they are not showing at all in the wordpress dashboard?

    Appreciate your instructions

    Many thanks!
    Carl ??

    Plugin Author Lester Chan

    (@gamerz)

    You can’t. Is either you trust WP-Sweep to delete all for you, or you have to use PHPMyAdmin and inspect the database wp_posts yourself.

    Thread Starter carlbradbrook

    (@carlbradbrook)

    I did click the sweep button on the posts but they are still showing 233 post after I did the sweep.

    When I go to php my admin what is the table that the posts are normally in?

    It sounds like I have to delete manually.

    Many thanks for your help!
    Carl ??

    Plugin Author Lester Chan

    (@gamerz)

    Some plugins use custom post type as well so that might be the reason why.

    You can check the table wp_posts.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Wpsweep Shows 176 more posts than there are. Any ideas please Lester?’ is closed to new replies.