Laravel : Syntax error or access violation: 1055 Error

November 10, 2019 Harinder Singh

To fix we can update the database.php file. file path config\database.php

open the file and goto the mysql section and update strict to false.

'strict' => false

1	'strict' => false

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

'mysql' => [
       ...
       ....
       'strict' => true,
       'modes' => [
            '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'
        ],
 ]

'mysql' => [

...

....

'strict' => true,

'modes' => [

'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'

]

enable the ONLY_FULL_GROUP_BY

Was this post helpful?

Let us know if you liked the post. That’s the only way we can improve.

Yes0

No0

Post Views: 349

Harinder Singh

My name is Harinder Singh and I specialize in Software industry. I consider myself as a life learner. I love learning new concepts, embracing new ideas and reading and searching for innovation.