laravel-vue-cms icon indicating copy to clipboard operation
laravel-vue-cms copied to clipboard

artisan migrate --seed pops this up

Open streetmedic opened this issue 5 years ago • 0 comments

PS C:\Program Files (x86)\Ampps\www\laravel> php artisan migrate --seed Migration table created successfully.

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

at C:\Program Files (x86)\Ampps\www\laravel\vendor\laravel\framework\src\Illuminate\Database\Connection.php:664 660| // If an exception occurs when attempting to run a query, we'll format the error 661| // message to include the bindings with SQL, which will make this exception a 662| // lot more helpful to the developer instead of just the database's errors. 663| catch (Exception $e) {

664| throw new QueryException( 665| $query, $this->prepareBindings($bindings), $e 666| ); 667| } 668|

Exception trace:

1 PDOException::("SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes") C:\Program Files (x86)\Ampps\www\laravel\vendor\laravel\framework\src\Illuminate\Database\Connection.php:458

2 PDOStatement::execute() C:\Program Files (x86)\Ampps\www\laravel\vendor\laravel\framework\src\Illuminate\Database\Connection.php:458

Please use the argument -v to see more details. PS C:\Program Files (x86)\Ampps\www\laravel>

I have tried everything to get this fixed i checked my php.ini all is goos . ive run clear cache and config cache

Ive updated composer still not working

streetmedic avatar Dec 11 '19 06:12 streetmedic