what's wrong when i try to migrate?

Question

I just start to learn laravel as an online course and do all instructions step by step behind the instructor but when I try to make migrate I get an error and doesn't migrate to database. what's wrong?

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, 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)

In Connection.php line 449:

SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'users' already exists

you have to provide the error and the code used, otherwise, there is no way we can help you — ᴄʀᴏᴢᴇᴛ, May 28 '18 at 15:39
there is screenshot attachment show the error https://i.stack.imgur.com/lLMOR.png — Mohamed El-Farghaly, May 28 '18 at 15:51
Possible duplicate of [Laravel Migration table already exists but i want to add new not the older](https://stackoverflow.com/questions/26077458/laravel-migration-table-already-exists-but-i-want-to-add-new-not-the-older) — ᴄʀᴏᴢᴇᴛ, May 28 '18 at 15:59

score 0 · Answer 1 · answered May 28 '18 at 15:52

0

Go to your data base and delete the table users and then re-do : php artisan migrate

answered May 28 '18 at 15:52

Mohcin Bounouara

593
4
18

i did that but invain – Mohamed El-Farghaly May 28 '18 at 15:59
Mmm okay you can try this: php artisan migrate:refresh – Mohcin Bounouara May 28 '18 at 16:07
As the same problem as well as Nothing to rollback. – Mohamed El-Farghaly May 28 '18 at 16:12

score 0 · Answer 2 · answered May 29 '18 at 09:07

you need refresh your database this error becouse users table in your DB please Go to your terminal and run this commend

php artisan migrate:refresh

or go to your phpmyadmin and drop your tables on DB to run your migrations from scratch using this commend after drop your DB

 php artisan migrate

congratulations ;)

score 0 · Answer 3 · answered Nov 26 '18 at 20:54

0

Delete Users table(all tables excepted migration if there is an entry in migration table truncate migration table)
run composer dump command.
run php artisan migrate.

enjoy :)

answered Nov 26 '18 at 20:54

mukul khanna

13
6

what's wrong when i try to migrate?

3 Answers3