Life Saving SQL Queries for a WordPress Blogger

Often its very tedious and time wasting job to clean up the mess on your blog! I find it very irritating at times when several unwanted work eat up my precious time as a webmaster that I could have otherwise used for creating meaningful content to share on my blog. Various tasks that could consume your valuable time as  a blogger are:

• Cleaning up Spam / pending comments
• Removing unwanted post revisions
• Deleting pending posts created by Spam bots
• Clearing web server cache etc.
• The list simply goes on.

Optimizing Your Website with Multivariate Testing

Today’s window to grab visitor attention is shorter than ever. Your goal is to make the mission of the site abundantly clear from the start so the user sticks around. If not, you risk losing the audience to another site that catches their attention in a much shorter time frame.

How can you be certain your achieving optimum results from your website?  A tool called multivariate testing will show you how visitors are responding the design and tone of your website.

With simple multivariate testing, a website can attain a high conversion rate for: newsletter signups, sales, feed subscriptions, downloads, and many other things. More importantly, it helps keep visitors engaged on a site, enhancing their experience, lowering bounce rate, and helping with website stats and analytics.

Newsletter Signups

Fatal Error on WordPress Version 3.3: Call to undefined function is_rtl()

Soon after the roll out of the latest WordPress 3.3 version upgrade, many webmasters have been reporting a failure on the blog and the following error occurring on their WordPress Admin dashboard page: “Call to undefined function is_rtl()“

Complete Error: Fatal error: Call to undefined function is_rtl() in /public_html/wp-includes/general-template.php on line 2102

How to Mass Delete Spam Comments at once using a SQL query?

I have observed that among web masters, even though success in not so very common, the problems that they face are common! I have had many web masters seeking help when they are facing issues with Spam Comments and they are finding it difficult to keep a tab on them even after installing Akismet plugin that helps in spam identification.

Let me clarify that the problem here is not in the identification of the Spam comments, but is in mass deleting all of them at one go without crashing your Wordpress installation. Often the “empty spam” button works like a charm when there are less comments like below a count of 1000. Imagine you have an amount of 20,000 pending comments – how would you tackle such a situation to delete all the spam comments? its simple, read on..

Mass Deleting un approved comments using a SQL query

How to Fix RSS Feed Errors for WordPress

Often it happens that without any know reason your WordPress Blog Feed page stops working. Its not a bad idea to check your WordPress blog feed URL if its working. Several symptoms of  a non working Feed page are:

How to Auto Post to Facebook?

If you already know the power of Internet Marketing, you might be already knowing that this is a Million Dollar Question! Facebook can give a surprising boost to your website traffic, readership and Conversions if used in the right way. This is one Huge Social networking website with an explosive nature of spreading great information through social peers.

It is an awesome idea to convert your website visitors into fans through simple Facebook Like Boxes or by using a good Facebook landing page and have your audience stuck to the content you are always publishing. But I personally have found this as a tedious task to manually publish each and every post on to Facebook after writing it on your blog! Have you ever considered automating this part of the work? Read on..