[Plugin: Better Delete Revision] Remove Page revisions ?

Viewing 4 replies - 1 through 4 (of 4 total)
  • Moderator James Huff

    (@macmanx)

    15 years, 8 months ago

    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'
    Thread Starter lecaramel

    (@lecaramel)

    15 years, 8 months 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 🙂

    Moderator James Huff

    (@macmanx)

    15 years, 8 months ago

    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.

    Plugin Author Galerio

    (@galerio)

    15 years, 8 months ago

    Hi,

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

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

The topic ‘[Plugin: Better Delete Revision] Remove Page revisions ?’ is closed to new replies.