laravel-vue-cms
laravel-vue-cms copied to clipboard
artisan migrate --seed pops this up
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