Tengo un extraño problema con Eloquent que estoy tratando de hacer lo siguiente:

$this->node = \DB::table('permission')
                ->select('permission.id',
                         'object.name as object_name',
                         'permission.created_at',
                         'object.id as object_id')
                ->join('object', 'object.id', '=', 'permission.object_id')
                ->join('action', 'action.id', '=', 'permission.action_id')
                ->where('permission.person_id', $this->person['id'])
                ->groupBy('permission.object_id')
                ->orderBy('permission.created_at', 'desc')
                ->paginate(5);

Marco Laravel informar un error:

QueryException en Connection.php línea 761: SQLSTATE [42000]: Error de sintaxis o infracción de acceso: 1055 'permission.id' no está en GROUP BY (SQL: seleccionepermission.id, object.name comoobject_name, permission.created_at, object.id comoobject_id depermission unir internamenteobject enobject.id = permission.object_id unir internamenteaction enaction.id = permission.action_id dóndepermission.person_id = 1 grupo porpermission.object_id ordenar porpermission.created_at desc límite 5 offset 0)

He agregado una función de depuración elocuenteDB :: escuchar enAppServiceProvider:

use Illuminate\Support\Facades\DB;
use Illuminate\Support\ServiceProvider;

class AppServiceProvider extends ServiceProvider
{
    /**
     * Bootstrap any application services.
     *
     * @return void
     */
    public function boot()
    {
        //
         DB::listen(function ($query) {

            echo "<pre>";
            print_r($query->sql);
            echo "</pre>";

            // $query->sql
            // $query->bindings
            // $query->time
        });
    }
    ...

Y sí imprime esta consulta SQL:

select  `permission`.`id`, 
        `object`.`name` as `object_name`, 
        `permission`.`created_at`, 
        `object`.`id` as `object_id` 
from `permission` 
inner join `object` on `object`.`id` = `permission`.`object_id` 
inner join `action` on `action`.`id` = `permission`.`action_id` 
where `permission`.`person_id` = 1 
group by `permission`.`object_id` 
order by `permission`.`created_at` desc 
limit 5 offset 0

Que es válido enMySQL mediantePhpMyAdmin y aquí está el resultado de la consulta:Aun así, probé enmysql comando directamente y funciona bien, mirasalida de mysql:

¿Alguna idea?

Gracias