search

jeremykenedy / laravel-material-design

Laravel 5.6 on Material Design Lite 1.3 with user authentication, registration with email confirmation, social media authentication, password recovery, and captcha protection. This makes full use of Controllers for the routes, templates for the views, and makes use of middleware for routing. Uses laravel ORM modeling and has CRUD (Create Read Update Delete) functionality for all tasks. Quick setup, can be done in 5 minutes. It will take longer to obtain your Facebook, Twitter, and Google Plus API Keys than it will to set this up.
https://mdl.consultjeremy.com
MIT License
261 stars 108 forks source link

DB Migration Failed for Xampp #6

Closed kjhatis closed 7 years ago

kjhatis commented 7 years ago

Will You Share the MySQL file ? I getting this error during php artisan migrate

[Illuminate\Database\QueryException] SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes ( L: alter table users add unique users_name_unique(name))

[Doctrine\DBAL\Driver\PDOException] SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes

[PDOException] SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes

jeremykenedy commented 7 years ago

There is an .env.example file. This is very specific to your environment and not this project. You need to adjust your sql constraints or the seed file.

jeremykenedy commented 7 years ago

You may need to also adjust the migration file to specify the max length of the columns for your instance.