Skip to main content

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