SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes (SQL: alter table `shoppingcart` add primary key `shoppingcart_identifier_instance_ primary`(`identifier`, `instance`))

bumbummen99 / LaravelShoppingcart

A simple shopping cart implementation for Laravel

MIT License

505 stars 234 forks source link

SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes (SQL: alter table `shoppingcart` add primary key `shoppingcart_identifier_instance_ primary`(`identifier`, `instance`)) #170

Closed jordantsap closed 2 years ago

jordantsap commented 2 years ago

Composer.json: "bumbummen99/shoppingcart": "^4.2", "laravel/framework": "9.11",

After composer require i published migration with php artisan vendor:publish --provider="Gloudemans\Shoppingcart\ShoppingcartServiceProvider" --tag="migrations" and migrate:fresh gives me this error

bumbummen99 commented 2 years ago

https://laravel.com/docs/9.x/migrations#index-lengths-mysql-mariadb

Please don't put errors in the ticket title...