Fix SQL Error: GROUP BY incompatible with sql_mode=only_full_group_by

MySQL 5.7.5+ changed the GROUP BY behavior. So in this and future versions GROUP BY would not work in same way as it used to be before.

So to make GROUP BY feature working like before follow these details:

Note: First of all to follow these steps you must need to have root access to your server.

If you want to disable error sql_mode=only_full_group_by  […]

How to remove index.php from codeigniter in UBUNTU?

This tutorial will show you that how to remove index.php from codeigniter in UBUNTU or how to enable url rewriting.

Step 1 :

Add this in htaccess file

Step 2 :

Remove index.php in codeigniter config

Step 3 :

Allow overriding htaccess in Apache Configuration (Command)

and edit the file & change to

for www folder

Step 4 :

Enabled apache mod rewrite (Command)

Step 5 :

Restart Apache (Command)

Source […]