Wordpress Plugins

Uploading Files Fast Quick Tip

Sep 28th

Posted by Mohsin Rasool in Quick Tips

No comments

When you are regularly blogging online, you may need some stuff to upload to your site time to time.

Like a plug-in which needs to be installed manually. You need to FTP the files of that plug-in to the plugins’ directory before you can activate it.

Here is a quick tip to save your time and frustration:

Where possible upload .zip file and then Unzip on the server!

This will save you 75% time of uploading and 99% time of brain work & tension. Because it is always easier to upload one file (no matter what size) than to upload many many tiny files.

Also in case of interruption you do not  need to worry what file is done and what needs to be re-uploaded..as you are dealing with just ONE file it is easier to manage.

That is for today a Quick tip :)

, , ,

How to Delete All Those Spam Comments

Sep 26th

Posted by Mohsin Rasool in Comment Spam

No comments

This is very risky to leave your WordPress blog open for all comment spam without adding any anti comment spam plugins.

This was the case with the blog which a client of us have, it had about 4000 spam comments, and it was going to take ages to delete them all from WordPress dashboard. So they came to us for the help.

We deleted all those about 4000 spam comment using little query operation at database level from phpmyadmin. I want to share the same process with you.

1. You need to login to your hosting panel and access PhpMyAdmin to access your database for that blog.

2. When you are there, select your blog’s database and then click SQL tab and run the following query:

DELETE FROM wp_comments WHERE comment_approved = 0

3. Wow within milliseconds all spam comment junk is gone.

Deleted rows: 3994 (Query took 0.1472 sec)

Now go to your wordpress blog and see all pending(spam) comments are gone. Now you please add some anti spam plugins to stop this thing happening again. I recommend you activate built-in plugin for comment spam called akismet. And add any other anti spam plugin you may like.

, ,