Laravel : Syntax error or access violation: 1055 Error

by

Short answer

In config\database.php –> "mysql" array

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.

More Related Contents:

  1. Laravel 5.1, Return response to user, then excute some code [closed]
  2. Laravel combined OR AND Solution
  3. Laravel 5 – How to access image uploaded in storage within View?
  4. How to pass data to all views in Laravel 5?
  5. Laravel Check If Related Model Exists
  6. How to Get the Query Executed in Laravel 5? DB::getQueryLog() Returning Empty Array
  7. How can I convert many statement mysql to laravel eloquent?
  8. Laravel: How to Get Current Route Name? (v5 … v7)
  9. Laravel Model with Two Primary Keys update [duplicate]
  10. Laravel: How can I change the default Auth Password field name?
  11. No Application Encryption Key Has Been Specified
  12. Access denied for user ‘homestead’@’localhost’ (using password: YES)
  13. How to change / Custom password field name for Laravel 4 and Laravel 5 user authentication [duplicate]
  14. How to execute Stored Procedure from Laravel
  15. How to fix the “Base table or view not found: 1146” error when running ‘php artisan migrate’ command?
  16. How to redirect back to form with input – Laravel 5
  17. Laravel Socialite: InvalidStateException
  18. Laravel 5.4 on PHP 7.0: PDO Exception – Could not find driver (MySQL)
  19. Prevent Browser’s Back Button Login After Logout in Laravel 5
  20. Laravel – How to get current user in AppServiceProvider
  21. How to set the default value of an attribute on a Laravel model [duplicate]
  22. Difference between Eloquent\Model::get() and all()
  23. required_if Laravel 5 validation
  24. Login only if user is active using Laravel
  25. laravel 5.3 new Auth::routes()
  26. Laravel changing timezone not reflecting the correct time
  27. How to remove /public/ from a Laravel URL
  28. Error 405 (Method Not Allowed) Laravel 5
  29. Unit Test Laravel’s FormRequest
  30. find in set in laravel ? example

Leave a Comment