Tag Archives: Laravel reported an error when creating a data table

[Solved] Laravel Create Data Table Error: Syntax error or access violation: 1071 Specified key was too long

1. Scene

  • Version:Laravel 5.7
  • Project downloaded from github, installed locally.

1. Create a new database
2. Execute the data table generation command in the project root directory (non-public directory) , and an php artisan migrateerror is reported:Syntax error or access violation: 1071 Specified key was too long

2. Screenshot of error reporting

  • The migrations table was successfully generated
  • An error was reported when generating the user table
  • So there are 2 tables in the database, migrations and user table

3. Solution

  • Open app/prpvider/appserviceprovider.php file
  • Find the boot() method
  • Set the default length of the string: Schema::defaultStringLength(191);
  • The screenshot is as follows:

4. Re-execute PHP artisan migrate again

  • The error message is as follows:
  • Delete the migrations and user tables in conflict.
  • execute again: php artist migrate the data table is created successfully, as shown in the following figure: