Hello there! Thanks for visiting pradeepgeorge.com. My name is Pradeep George. Over the last 17 years I am working with software products and marketing.  My area of specialization includes development of marketing strategies, online marketing, project management and strategic & tactical planning. My latest interests are in developing sites in Drupal and

Bulk Delete of Unapproved Comments in Drupal 7

  • Posted on: 13 January 2013
  • By: Pradeep George

When you allow comments in your blog post or page, often you will be spammed with thousands of comments from spammers. One way to reduse it to use module like CAPTCHA.
IF you already have thousands of comments to your posts and would like to remove all the un approved comments here is the method.

1. Enable the PHP format in your site
2. Create a new content page and add the following code

db_query('DELETE FROM comment WHERE status = 0');

Export Outlook 2011 mails to Mac mail without any third party applications - applicabale Lion & Mountain lion

  • Posted on: 14 September 2012
  • By: Pradeep George

If you are using Outlook 2011 on your mac and would like to transfer your existing data to MAC mail programme, follow the steps shon below.

1. Create a new folder in Finder

2. Open Outlook and click and drag each folder into the new finder folder you have created. Note: You will need to expand the trees so you drag each folder rather than just master folders.

3. Open Mail.

4. Select the Inbox. Go File/Import Mailboxes and select the last option “Files in m.box format.” Click Continue.

How to solve the Blank page issue with MAMP PRO and DRUPAL

  • Posted on: 16 February 2012
  • By: Pradeep George

I have recently upgraded to MAMP PRO 2 and to my surprise some of the sites I was working with started showing a blank page locally even though the online version is working fine. After spending some hours in research, I have found the solution. It was basically because of the PHP memory limit.

If you add the following code in your index.php file , it will show the error OR  you could open MAMP PRO >>log>>Apache and check the logs. I got the following error

Lion Hosts file bug/issue

  • Posted on: 21 December 2011
  • By: Pradeep George

If you are working with website development or want to block or redirect access to specific domains, you have probably edited the system file /etc/hosts like me. I have recemtly upgraded to Lion and to my astonishment, I found that the entries in the hosts file is anymore considered. After a lot of checking around, this is what worked for me.

1. If you don't have the program TextWrangler (Free text editor for Mac), go ahead and install it.