Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

php artisan db:seed not working #17

Open
muhammadumar11 opened this issue Mar 5, 2019 · 3 comments
Open

php artisan db:seed not working #17

muhammadumar11 opened this issue Mar 5, 2019 · 3 comments

Comments

@muhammadumar11
Copy link

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
Copy link
Author

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

@SanthoshSiddegowda
Copy link

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
Copy link

php artisan dump autoload then i hope this work well

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants