WordPress.org

Ready to get started?Download WordPress

Forums

Better Delete Revision
[resolved] Remove Page revisions ? (5 posts)

  1. lecaramel
    Member
    Posted 3 years ago #

    Hi,

    First of all, thank you for your hard work on the plugin.

    I have a question: it seems to work only on the post revisions and its related content. But what about the pages? I'm working on CMS websites with a lot of pages and a way to clean the revisions would be great too :)

    Thanks!

    http://wordpress.org/extend/plugins/better-delete-revision/

  2. It should work on the pages too, but I'm not sure what query the plugin runs. Technically, posts and pages are the same thing, and so are their revisions.

    If it doesn't work for you, run this query either via phpMyAdmin or the MySQL command line:

    DELETE a,b,c
    FROM wp_posts a
    LEFT JOIN wp_term_relationships b ON (a.ID = b.object_id)
    LEFT JOIN wp_postmeta c ON (a.ID = c.post_id)
    WHERE a.post_type = 'revision'
  3. lecaramel
    Member
    Posted 3 years ago #

    I remember that I did it manually in a blog through a SQL querry and it was a different one for the page than post. I have to find it as I really need it on a blog :)

  4. It's no different. I use that query on several blogs. The pages are also stored in the wp_posts table, they're just categorized a little bit differently than posts, but their revisions are handled the same as posts.

  5. Galerio
    Member
    Plugin Author

    Posted 3 years ago #

    Hi,

    Yes, the plugin removes revision of both posts and pages so you can use it and make your life easier.

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic