Pradeep George's blog

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.

How to find your lost or misplaced iPhone, iPad or Mac

  • Posted on: 22 November 2011
  • By: Pradeep George

With the IOS5 and the iCloud service, it is very easy to find you lost or misplaced  iPhone, iPad or Mac.

All you need is to download and update the latest IOS 5.x on your iPhone, iPad or Mac, while rebooting, it will promt whether you want to "Set up iCloud", say Yes, don't worry it won't cost you anything. Sign in with your Apple ID and follow the onscreen instructions.

Once you have completed the iCloud setup, it will prompt whether you want to sign up for "Find My iPhone.". Say "Yes", I can assure you someday it is going be very handy.

Pages