Illuminate\Database\QueryException ( Specified key was too long )

[mahdirashidi]

php artisan world:init Execute migrate first, migrating... Migrating: 2017_04_08_163453_create_world_cities_locale_table Migrated: 2017_04_08_163453_create_world_cities_locale_table (80.40ms) Migrating: 2017_04_08_163453_create_world_cities_table

Illuminate\Database\QueryException

SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes (SQL: alter table world_cities add index uniq _city(country_id, division_id, name))

at vendor\laravel\framework\src\Illuminate\Database\Connection.php:678 674▕ // If an exception occurs when attempting to run a query, we'll format the error 675▕ // message to include the bindings with SQL, which will make this exception a 676▕ // lot more helpful to the developer instead of just the database's errors. 677▕ catch (Exception $e) { ➜ 678▕ throw new QueryException( 679▕ $query, $this->prepareBindings($bindings), $e 680▕ ); 681▕ } 682▕

1) vendor\laravel\framework\src\Illuminate\Database\Connection.php:471 PDOException::("SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes")

2) vendor\laravel\framework\src\Illuminate\Database\Connection.php:471 PDOStatement::execute()

[gausoft]

Hi, if you have created your database with utf8 general_ci collation, try this params :

'charset' => 'utf8',
'collation' => 'utf8_general_ci',

in config/database.php

[gausoft]

If not solved, try this solution https://blog.neversyn.com/how-to-fix-specified-key-was-too-long-issue/