Laravel : Syntax error or access violation: 1055 Error
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
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' ], ]
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
No1