this is incompatible with sql_mode=only_full_group_by on Laravel

Posted 8 years ago - updated 8 years ago laravel mysql

Edit config/database.php and check strict => false

In strict mode:

sql_mode='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'

otherwise:

sql_mode='NO_ENGINE_SUBSTITUTION'