How To Turn Off Post Revision In WordPress 2.6

One of the irritating feature for me in WordPress 2.6 is the post revision. I am the only author of my blog and hence this feature is useless to me.

Just in case you are wondering how post revision works, whenever a post is edited, a new row will be created in wp_posts table. Hence if your posts or pages got edited 10 times, you will have 10 new rows in wp_posts table.

In no time your wp_posts table will be filled up and the post ID will be huge.

To turn off this feature, add this following code to wp-config.php:

define('WP_POST_REVISIONS', false);

You can also delete all post revisions by running this query in phpMyAdmin:

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'  

Be sure to backup your database first before performing any queries in phpMyAdmin.

*UPDATE* Auto Saves does not create a revision of the post.

*UPDATE 2* Updated SQL query from Andrei Neculau as the previous query does not delete from wp_postmeta and wp_term_relationships tables.

*UPDATE 3* There is a proper way of cleaning up Post Revisions as mentioned by kitchin in Deleting Post Revisions: do NOT use the a,b,c JOIN code you see everywhere. I like his method more than the SQL query above.

1 Star2 Stars3 Stars4 Stars5 Stars (177 votes, average: 4.20 out of 5)

Lester Chan’s WordPress Plugins July 2008 Update

Here is my July 2008 WordPress plugins update containing all my 15 WordPress plugins. All of them should work on WordPress 2.5 as well as WordPress 2.6. It is not tested for any version below that.

In general, most of the updates are bug fixes. These updates in theory should be able to work till WordPress 2.7 when it comes out end of this year.

My new semester will begin on 2nd week August 2008, and hence I will be busy with my school work. So no updates to my plugins will be out till the end of this year unless it is a critical bug or a security issue.

Be sure to read the readme.html and checkout the changelog for more information and most importantly NOTE THE TABS AT THE TOP

WP-Ban 1.31
» Readme/Changelog
» Download Mirror #1
» Download Mirror #2
» Support Forum

WP-DBManager 2.31
» Readme/Changelog
» Download Mirror #1
» Download Mirror #2
» Support Forum

WP-DownloadManager 1.31
» Readme/Changelog
» Demo
» Download Mirror #1
» Download Mirror #2
» Support Forum

WP-EMail 2.31
» Readme/Changelog
» Demo
» Download Mirror #1
» Download Mirror #2
» Support Forum

WP-PageNavi 2.31
» Readme/Changelog
» Demo
» Download Mirror #1
» Download Mirror #2
» Support Forum

WP-PluginsUsed 1.31
» Readme/Changelog
» Demo
» Download Mirror #1
» Download Mirror #2
» Support Forum

WP-Polls 2.31
» Readme/Changelog
» Demo
» Download Mirror #1
» Download Mirror #2
» Support Forum

WP-PostRatings 1.31
» Readme/Changelog
» Demo
» Download Mirror #1
» Download Mirror #2
» Support Forum

WP-PostViews 1.31
» Readme/Changelog
» Demo
» Download Mirror #1
» Download Mirror #2
» Support Forum

WP-Print 2.31
» Readme/Changelog
» Demo
» Download Mirror #1
» Download Mirror #2
» Support Forum

WP-RelativeDate 1.31
» Readme/Changelog
» Demo
» Download Mirror #1
» Download Mirror #2
» Support Forum

WP-ServerInfo 1.31
» Readme/Changelog
» Download Mirror #1
» Download Mirror #2
» Support Forum

WP-Sticky 1.31
» Readme/Changelog
» Demo
» Download Mirror #1
» Download Mirror #2
» Support Forum

WP-Stats 2.31
» Readme/Changelog
» Demo
» Download Mirror #1
» Download Mirror #2
» Support Forum

WP-Useronline 2.31
» Readme/Changelog
» Demo
» Download Mirror #1
» Download Mirror #2
» Support Forum

If you like or love my plugins a lot, do consider making a donation to me. My Paypal email address is lesterchan AT gmail DOT com. Thank you =D

1 Star2 Stars3 Stars4 Stars5 Stars (84 votes, average: 4.19 out of 5)

WordPress 2.6 Release

http://wordpress.org/development/2008/07/wordpress-26-tyner/trackback/

WordPress 2.6 has been released.

Here are some new features of WordPress 2.6:

  • Post Revisions: Wiki-like tracking of edits
  • Press This!: Post from wherever you are on the web
  • Shift Gears: Turbo-speed your blogging
  • Theme Previews: See it before your audience does
  • Word count
  • Image captions under your image
  • Bulk management of plugins
  • A completely revamped image control to allow for easier inserting, floating, and resizing. It’s now fully integrated with the WYSIWYG
  • Drag-and-drop reordering of Galleries
  • Plugin update notification bubble
  • Customizable default avatars
  • You can now upload media when in full-screen mode
  • Remote publishing via XML-RPC and APP is now secure (off) by default
  • Full SSL support in the core, and the ability to force SSL for security
  • You can now have many thousands of pages or categories with no interface issues
  • Ability to move your wp-config file and wp-content directories to a custom location, for “clean” SVN checkouts
  • Select a range of checkboxes with “shift-click.”
  • You can toggle between the Flash uploader and the classic one
  • A number of proactive security enhancements, including cookies and database interactions
  • Stronger better faster versions of TinyMCE, jQuery, and jQuery UI

2.6 is pretty much identical to 2.5 from a plugin and theme compatibility point of view, so upgrades from 2.5 should be pretty painless. The 2.5 branch will no longer be maintain so everyone is encouraged to upgrade.

» Download WordPress 2.6

PS: The current version of my plugins should work well with WordPress 2.6 except WP-DownloadManager. Nevertheless, I will release updates to all of them tomorrow.

1 Star2 Stars3 Stars4 Stars5 Stars (18 votes, average: 4.06 out of 5)