How can i delete a migration that is not found?

Question

I have this problem

when i run php artisan migrate:refresh:

Rolling back: 2014_10_12_100000_create_password_resets_table
Rolled back:  2014_10_12_100000_create_password_resets_table (1.71ms)
Rolling back: 2014_10_12_000000_create_users_table
Rolled back:  2014_10_12_000000_create_users_table (1.76ms)
Migration not found: 2018_06_30_113500_create_comments_table <---- THIS ONE!!!
Migrating: 2014_10_12_000000_create_users_table
Migrated:  2014_10_12_000000_create_users_table (8.18ms)

I had already tried:

php artisan migrate:refresh

php artisan migrate:rollback --step=1 until I got: "Migration not found: 2018_06_30_113500_create_comments_table"

How can I delete this:

migrationfile "2018_06_30_113500_create_comments_table" ?

Did you check version history? Did someone forgot to check-in the file `2018_06_30_113500_create_comments_table`? — MaartenDev, Nov 26 '21 at 20:05
@MaartenDev this migration file belonged to a corrupt package. I have already removed the package and the git branch I tried it on no longer exists. — Maik Lowrey, Nov 26 '21 at 20:08
@MaartenDev first removed from composer.json then composer install. Then removed the entire vendor folder and composer install again. — Maik Lowrey, Nov 26 '21 at 20:10
did you try clearing the `migrations` table in the database? — MaartenDev, Nov 26 '21 at 20:11
delete just the `2018_06_30_113500_create_comments_table` row in `migrations` table. — MaartenDev, Nov 26 '21 at 20:13
Let us [continue this discussion in chat](https://chat.stackoverflow.com/rooms/239617/discussion-between-maik-lowrey-and-maartendev). — Maik Lowrey, Nov 26 '21 at 20:14
https://stackoverflow.com/questions/16871413/safely-remove-migration-in-laravel, https://stackoverflow.com/questions/44558543/remove-specific-migration-in-laravel, ... — Don't Panic, Nov 26 '21 at 22:04

score 4 · Answer 1 · edited Nov 26 '21 at 20:54

4

This can be fixed by manually removing the 2018_06_30_113500_create_comments_table record in the migrations table. You could use the following command:

DELETE FROM migrations where name = '2018_06_30_113500_create_comments_table'

edited Nov 26 '21 at 20:54

Maik Lowrey

15,957
6
40
79

answered Nov 26 '21 at 20:18

MaartenDev

5,631
5
21
33

How can i delete a migration that is not found?

I have this problem

I had already tried:

How can I delete this:

1 Answers1