laravel 8 - Syntax error or access violation: 1071 Specified key was too long - BugOverflow https://muszak.eu/community/bugoverflow/laravel-8-syntax-error-or-access-violation-1071-specified-key-was-too-long/ muszak.eu Forum dyskusyjne pl-PL Sun, 08 Mar 2026 13:54:38 +0000 wpForo 60 Odpowiedź na: laravel 8 - Syntax error or access violation: 1071 Specified key was too long https://muszak.eu/community/bugoverflow/laravel-8-syntax-error-or-access-violation-1071-specified-key-was-too-long/#post-905 Mon, 02 Aug 2021 10:09:26 +0000
  • edit config/database.php
  • inside "mysql" object find
  • 'engine' => null,
  • modify this line
  • 'engine' => 'InnoDB ROW_FORMAT=DYNAMIC',
  • or
  • 'engine' => 'InnoDB',

    •  

    ]]>     BugOverflow mrmucha https://muszak.eu/community/bugoverflow/laravel-8-syntax-error-or-access-violation-1071-specified-key-was-too-long/#post-905     laravel 8 - Syntax error or access violation: 1071 Specified key was too long https://muszak.eu/community/bugoverflow/laravel-8-syntax-error-or-access-violation-1071-specified-key-was-too-long/#post-904 Mon, 02 Aug 2021 10:07:18 +0000 SQLSTATE: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes (SQL: alter table `users` add unique `users_email_unique`(`email`))]]> BugOverflow mrmucha https://muszak.eu/community/bugoverflow/laravel-8-syntax-error-or-access-violation-1071-specified-key-was-too-long/#post-904