In the new version 3.7 when trying to add roles and dynamic permissions the following error is generated:
Migrating: 2020_10_15_000000_create_roles_permissions_tables
Illuminate\Database\QueryException
SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes (SQL: alter table model_has_permissions
add index model_has_permissions_model_id_model_type_index
(model_id
, model_type
))
at F:\Project\beta\vendor\laravel\framework\src\Illuminate\Database\Connection.php:671
667| // If an exception occurs when attempting to run a query, we’ll format the error
668| // message to include the bindings with SQL, which will make this exception a
669| // lot more helpful to the developer instead of just the database’s errors.
670| catch (Exception $e) {
671| throw new QueryException(
672| $query, $this->prepareBindings($bindings), $e
673| );
674| }
675|
1 F:\Project\beta\vendor\laravel\framework\src\Illuminate\Database\Connection.php:464
PDOException::(“SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes”)
2 F:\Project\beta\vendor\laravel\framework\src\Illuminate\Database\Connection.php:464
PDOStatement::execute()
Windows 10, Laragon 5.0, php 7.4.19, mysql 5.7.33