Delete related entries

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author Zhuo

    (@allarem)

    What kind of the “related entries” that should be deleted?
    I’m feel confused

    Thread Starter Lemmy

    (@lemmyc)

    Sorry, the link got lost. See here:
    https://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)

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Delete related entries’ is closed to new replies.