SQLSTATE[42000]: Syntax error or access violation: 1055

Created at 11-Jan-2021, By samar

SQLSTATE[42000]: Syntax error or access violation: 1055

With this article, we will examine several different instances of how to solve the "SQLSTATE[42000]: Syntax error or access violation: 1055".

  • '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'
     ],
     ]
    
    In config\database.php --> "mysql" array Set 'strict' => false to disable all

Back to code snippet queries related laravel

If you like what you are reading, please consider buying us a coffee ( or 2 ) as a token of appreciation.

Buy Me A Coffee

Don't forget to share this article! Help us spread the word by clicking the share button below.

We appreciate your support and are committed to providing you valuable and informative content.

We are thankful for your never ending support.