The MU forums have moved to

Limit Post Revisions - reloaded (11 posts)

  1. gnetworkau
    Posted 14 years ago #

    I have been on the "Limit Post Revisions" journey for the last few days, no joy yet. After extensive searches and trials, I must assume the standard approach to Limit Post Revisions doesn't work any longer, in Wordpress MU 2.8.2.
    I want to have NO Post Revisions, and tried both the following suggestions:
    Add to wp-config.php:
    define(’WP_POST_REVISIONS’, false);
    define(’WP_POST_REVISIONS’, 0);

    Neither worked, and Post Revisions kept happily coming...
    I did however manage to completely clean up all old post revisions and associated entries, reducing database size by 70%!!
    I used the following SQL command for each blog, insert the blog ID number for {ID}, worked a treat:

    DELETE a,b,c
    FROM wp_{ID}_posts a
    LEFT JOIN wp_{ID}_term_relationships b ON (a.ID = b.object_id)
    LEFT JOIN wp_{ID}_postmeta c ON (a.ID = c.post_id)
    WHERE a.post_type = 'revision'

    So, do I need to constantly clean up old Post Revisions as above, or is there a NEW way to DISABLE Post Revisions?

  2. iamfriendly
    Posted 14 years ago #

    I'm absolutely certain there must be an 'automatic' way to do this, however, if there isn't, you could always write a really basic plugin which utilises your bit of SQL above...could get it to grab a list of all of the blog ID's, then do a foreach loop.

    Could have it run using a cron script, perhaps, or when you tell it to (via pressing a button or some such).

    I assume you've tried this plugin, though -

  3. gnetworkau
    Posted 14 years ago #

    are you running it on 2.8.2?

    I will reload db and try it.

  4. gnetworkau
    Posted 14 years ago #

    dropped it in mu-plugins, did nothing.

  5. gnetworkau
    Posted 14 years ago #


    it looks like it works!

  6. gazouteast
    Posted 14 years ago #

    went looking for that limit post revisions plugin and got ....

    Sorry, we can't find the content you're looking for at this URL. Please try selecting a menu item from above or to the side of this message to get where you'd like to go.

    I'm REALLY hoping that this basic requirement has not been completely ignored by WPMU and punted to a 3rd-party who then makes you pay for it?

    I never wanted and have never used any of the post revisions functionality on any of my sites, and was far happier before it was introduced - all it does is cause database bloat, additional queries, and further slow down of the admin side. Ditch the entire function says I.


  7. tdjcbe
    Posted 14 years ago #

    Just worked for me. You're clicking on that pale yellow box along the right hand side that says "click here to download this free content" right?

  8. andrea_r
    Posted 14 years ago #

    And no, the devs aren't going to deliberately punt something to a for-pay setup. you have read or listened to anything by matt, right?

  9. gazouteast
    Posted 14 years ago #

    Sorry - I forgot to insert the smiley - it was tongue in cheek

    (I knew that such a function could not have been punted out to a paid service, as it is a WordPress function and that would be breaking the license - was just surprised to get a not found message on wpmudev)

  10. tdjcbe
    Posted 14 years ago #

    Again, the download link worked fine for me.

  11. gazouteast
    Posted 14 years ago #

    Just worked for me - must have been internet choking during the aftermath of the Bangkok riots - we had a lot of connectivty & speed issues last week.

About this Topic

  • Started 14 years ago by gnetworkau
  • Latest reply from gazouteast