Convert Unixtime into DateTime (Indian TimeZone) in Android

How to group by date

How to group by date

Here created is applied date and apply_count  total number of jobs applied  by user, grouped by applied date.

Getting too many requests from IP range

One day you wake up and see that your server resources are getting drained away without much increase in traffic. Than you will have to look for if your server is bombarded with requests from certain IP’s. If your website traffic is low then you can find out these problematic IP’s with naked eyes. In case your traffic is high then try saving the apache log of say 1-5 mins. Have 500-1000 samples. You can try to take sample output with tail command

Koha new installation on a 64bit machine – zebra related issues

The following is a reply I got from the Koha mailing list:

Check if you’ve got the directory


or the directory/usr/lib64/idzebra-2.0/modules

on your server. Chances are it’ll be the second option. If so, edit these four files

  • /etc/koha/zebradb/zebra-authorities.cfg
  • /etc/koha/zebradb/zebra-authorities-dom.cfg
  • /etc/koha/zebradb/zebra-biblios.cfg
  • /etc/koha/zebradb/zebra-biblios-dom.cfg

In each, change the line reading:         modulePath: /usr/lib/idzebra-2.0/modules

to    modulePath: /usr/lib64/idzebra-2.0/modules

PHP solr error

After updating php from 5.3 to php 5.4 and you are using pecl then you will start getting error

Problem: Your php solr is compiled with old version of php

yii with pecl solr extension

Pecl solr requires libxml and libcurl in order to connect with solr server. Install the basis dependencies by

Once you have basic dependencies installed. Install pecl solr by



  • Executes before and/or after a controller action executes.It can also prevent further execution of action
  • E.g. access control filter – to ensure user authentication before executing the requested action.
  • An action can have multiple filters.
  • Order Of Execution : the order they defined in the filter list.
  • A filter can prevent the execution of the action and the rest of the un-executed filters.