i have a error
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
Replies (3)
Hi Gerrit van
There's an update from the Laravel Permission library. To resolve the issue, please follow these steps:
Update the package:
composer updateRemove the old migration file:
Delete the file named *_create_permission_tables.php.
Publish the updated migration file:
Run the command:
php artisan vendor:publish --provider="Spatie\Permission\PermissionServiceProvider"Now, try running the migration again with:
php artisan migrateThese steps should resolve the error you're encountering.
Best regards,
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
