Super Sale Limited Time 50% OFF for All-Access Plans
Save 50% Now
Light
Dark
System
Ask  Question

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

user
Gerrit van 1 year ago
Laravel Datatables
3 Answers
Text formatting options
Submit
Click any option to insert into your comment. Select text first to wrap it.
  • **text** to make things bold
  • *text* to emphasize
  • ### Heading to make headings
  • [link text](url) for links
  • ![alt text](image-url) to paste in an image
  • - item to make a list
  • 1. item to make an ordered list
  • > quote to quote somebody
  • `code` for single line of code
  • ```js ... ``` for JS code block
  • ```html ... ``` for HTML code block
  • ```scss ... ``` for SCSS code block
  • ```php ... ``` for PHP code block
  • --- for a horizontal rule
  • happy  :)
  • shocked  :|
  • sad  :(

Replies (3)

user
Faizal Author 1 year ago

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,


user
Gerrit van 1 year ago

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


user
Gerrit van 1 year ago

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
Click any option to insert into your comment. Select text first to wrap it.
  • **text** to make things bold
  • *text* to emphasize
  • ### Heading to make headings
  • [link text](url) for links
  • ![alt text](image-url) to paste in an image
  • - item to make a list
  • 1. item to make an ordered list
  • > quote to quote somebody
  • `code` for single line of code
  • ```js ... ``` for JS code block
  • ```html ... ``` for HTML code block
  • ```scss ... ``` for SCSS code block
  • ```php ... ``` for PHP code block
  • --- for a horizontal rule
  • happy  :)
  • shocked  :|
  • sad  :(
Text formatting options
Submit
Click any option to insert into your comment. Select text first to wrap it.
  • **text** to make things bold
  • *text* to emphasize
  • ### Heading to make headings
  • [link text](url) for links
  • ![alt text](image-url) to paste in an image
  • - item to make a list
  • 1. item to make an ordered list
  • > quote to quote somebody
  • `code` for single line of code
  • ```js ... ``` for JS code block
  • ```html ... ``` for HTML code block
  • ```scss ... ``` for SCSS code block
  • ```php ... ``` for PHP code block
  • --- for a horizontal rule
  • happy  :)
  • shocked  :|
  • sad  :(