hi,
i have buy your script and i wanne use the laravel but i get a error : SQLSTATE[42000] : Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes (Connection: mysql, SQL: alter table `permissions` add unique `permissions_name_guard_name_unique`(`name`, `guard_name`))
can you help me whit this ?
thanks
Hi Gerrit van
There's an update from the Laravel Permission library. To resolve the issue, please follow these steps:
Update the package:
composer update
php artisan vendor:publish --provider="Spatie\Permission\PermissionServiceProvider"
php artisan migrate
hi,
thanks its works now, do forget that the people olso have to set in the database file te set the engine to 'engine' => 'InnoDB',
thanks
and its Metronic v9
what i have done :
*set in databese.php the 'engine' to 'engine' => 'InnoDB',
* del the file permission.php and than do php artisan vendor:publish --provider="Spatie\Permission\PermissionServiceProvider"
* and now i get : Access to undeclared static property Spatie\Permission\PermissionRegistrar::$pivotPermission
at database\migrations\2023_06_11_075700_create_permission_tables.php:54
thanks