First, I spent a good portion of my whee early hours this morning cleaning up some Wordpress Database issues I found to be absolutely hideous. First and foremost the post revisions offered up by Wordpress now-a-days is definitely useful and an appreciated feature; but it has some serious database issues that I find really annoying.

So, let’s first disable Wordpress’s post revisions by modifying wp-config.php in your web root:

define('WP_POST_REVISIONS', false);

Just throw that code in your wp-config and we can move on to removing the revisions from the wordpress database with:

DELETE FROM wp_posts WHERE post_type = "revision";

If you’re like me, you probably renamed your table prefix in Wordpress’s config (wp-config.php), if so just adjust wp_posts to reflect your wordpress table prefix. That about does it!

Visitors love interaction, especially a personable approach at gaining their attention and spiking their interests. Increasing the overall readership of your blog revolves primarily around content, accessibility and presentation. In an attempt to gain return readers and possibly subscribers, I present the newest version of Comment Relish: Version 2.0!.

First, I am sure you can find a plug-in for Wordpress that performs this functionality as well, but I did not want to make this a “plug-in” per se, so I figured I would just give you a working snippet of code and allow you to take it from there. I needed to shorten the titles for a project I have been working on and I figured that you might find this useful as well. It is short, sweet and to the point so give it a try.

Thanks to C. Bavota from Tinker Priest Media, your suggestions and feedback; I have released a new version of comment relish! Please check out, “Comment Relish Version 2 Release.” The new release has updated features, revised and more efficient queries; and an all around face lift!

Read Comment Relish Version 2.0 Released

Visitors love interaction, especially a personable approach at gaining their attention and spiking their interests. Increasing the overall readership of your blog revolves primarily around content, accessibility and presentation. In an attempt to gain return readers and possibly subscribers, I present Comment Relish.