WordPress.org

Ready to get started?Download WordPress

Forums

Revision Cleaner
Delete related entries (3 posts)

  1. Lemmy
    Member
    Posted 1 year ago #

    Wouldn't it be a good idea to delete the related entries, as described here in the top answer:

    http://wordpress.org/extend/plugins/revision-cleaner/

  2. Zhuo
    Member
    Plugin Author

    Posted 1 year ago #

    What kind of the "related entries" that should be deleted?
    I'm feel confused

  3. Lemmy
    Member
    Posted 1 year ago #

    Sorry, the link got lost. See here:
    http://wordpress.stackexchange.com/questions/23522/wordpress-site-causing-lots-of-server-io

    term_relationships and postmeta entries are also deleted.

    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'

    By the way, I tired switching off the multi-user option in your plugin and it was not saved - it was ticked again when I reloaded the page. (WordPress 3.5.1, Buddypress 1.6.4)

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic