php artisan db:seed not working

[muhammadumar11]

Illuminate\Database\QueryException : SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'users' already exists (SQL: create table users (id int unsigned not null auto_increment primary key, name varchar(255) not null, email varchar(255) not null, email_verified_at timestamp null, password varchar(255) not null, remember_token varchar(100) null, created_at timestamp null, updated_at timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci')

at D:\xampp\htdocs\laravel\roles-permissions\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[42S01]: Base table or view already exists: 1050 Table 'users' already exists") D:\xampp\htdocs\laravel\roles-permissions\vendor\laravel\framework\src\Illuminate\Database\Connection.php:458

2 PDOStatement::execute() D:\xampp\htdocs\laravel\roles-permissions\vendor\laravel\framework\src\Illuminate\Database\Connection.php:458

Please use the argument -v to see more details.

[muhammadumar11]

when i hit php artisan db:seed then it shows this error

[SanthoshSiddegowda]

This means you are database already has table name 'user' .. follow this steps

1. Go to your database .. check is users table exists if exists delete the table

2. run command

php artisan migrate:refresh ( for less than v5.6)

php artisan migrate:fresh (for version above 5.7)

[Iftakharalamrizve]

php artisan dump autoload then i hope this work well