SQLSTATE[42000]: Error de sintaxis o infracción de acceso: 1055 ‘nozha.reservations.id’ no está en el ejemplo de código GROUP BY

Ejemplo: error de sintaxis o infracción de acceso: 1055 ‘database.table.id’ no está en GROUP BY

Short answer : 
==================
1. In configdatabase.php --> "mysql" array

2. Set 'strict' => false to disable all.

=---------------- or ----------------------------=
You can leave 'strict' => true and add modes to "mysql" option in

'mysql' => [
       ...
       ....
       'strict' => true,
       'modes' => [
            //'ONLY_FULL_GROUP_BY', // Disable this to allow grouping by one column
            'STRICT_TRANS_TABLES',
            'NO_ZERO_IN_DATE',
            'NO_ZERO_DATE',
            'ERROR_FOR_DIVISION_BY_ZERO',
            'NO_AUTO_CREATE_USER',
            'NO_ENGINE_SUBSTITUTION'
        ],
 ]
 
Detailed answer :
==================
You may not need to disable all strict options ... Kindly have a look on this
answer about this issue. 
Link : https://github.com/laravel/framework/issues/14997#issuecomment-242129087

---

---

Utiliza Nuestro Buscador