Get 2024 Templates Mega Bundle!19 Bootstrap HTML, Vue & React Templates + 3 Vector Sets
Get for 99$

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


Text formatting options
Submit
Here's a how to add some HTML formatting to your comment:
  • <pre></pre> for JS codes block
  • <pre lang="html"></pre> for HTML code block
  • <pre lang="scss"></pre> for SCSS code block
  • <pre lang="php"></pre> for PHP code block
  • <code></code> for single line of code
  • <strong></strong> to make things bold
  • <em></em> to emphasize
  • <ul><li></li></ul>  to make list
  • <ol><li></li></ol>  to make ordered list
  • <h3></h3> to make headings
  • <a></a> for links
  • <img> to paste in an image
  • <blockquote></blockquote> to quote somebody
  • happy  :)
  • shocked  :|
  • sad  :(

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 update


Remove 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 migrate


These 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


Text formatting options
Submit
Here's a how to add some HTML formatting to your comment:
  • <pre></pre> for JS codes block
  • <pre lang="html"></pre> for HTML code block
  • <pre lang="scss"></pre> for SCSS code block
  • <pre lang="php"></pre> for PHP code block
  • <code></code> for single line of code
  • <strong></strong> to make things bold
  • <em></em> to emphasize
  • <ul><li></li></ul>  to make list
  • <ol><li></li></ol>  to make ordered list
  • <h3></h3> to make headings
  • <a></a> for links
  • <img> to paste in an image
  • <blockquote></blockquote> to quote somebody
  • happy  :)
  • shocked  :|
  • sad  :(
Text formatting options
Submit
Here's a how to add some HTML formatting to your comment:
  • <pre></pre> for JS codes block
  • <pre lang="html"></pre> for HTML code block
  • <pre lang="scss"></pre> for SCSS code block
  • <pre lang="php"></pre> for PHP code block
  • <code></code> for single line of code
  • <strong></strong> to make things bold
  • <em></em> to emphasize
  • <ul><li></li></ul>  to make list
  • <ol><li></li></ol>  to make ordered list
  • <h3></h3> to make headings
  • <a></a> for links
  • <img> to paste in an image
  • <blockquote></blockquote> to quote somebody
  • happy  :)
  • shocked  :|
  • sad  :(