Deleted migration files getting executed : Laravel application

Question

I hace deleted some migration files. but when i execute php artisan migrate command, error in the old migration file is showing.

[Illuminate\Database\QueryException]
SQLSTATE[HY000]: General error: 1215 Cannot add foreign key constraint (SQL : alter table cushbu_notifications add constraint cushbu_notifications_art_id_foreign foreign key (art_id) references cushbu_arts (id) on de lete cascade)

Now i don't have migration file for cushbu_notifications, instead i created a new migration file for cushbu_user_notifications.I deleted the cushbu_notifications table from database, also the corresponding entry from migrations table.

have you tried deleting table from database?. if you delete migration file, you should also delete table from database. — DPS, Jul 27 '17 at 05:00
this answer may be relevant: [safely remove migration In laravel](https://stackoverflow.com/questions/16871413/safely-remove-migration-in-laravel) — tinystone, Dec 20 '22 at 04:46

score 3 · Accepted Answer · answered Jul 27 '17 at 05:16

3

After manually deleting migration files, clear cache by below command, and then migrate

php artisan cache:clear

then

php artisan migrate

answered Jul 27 '17 at 05:16

Gaurav Rai

900
10
23

Vishal Varshney · Answer 2 · 2017-07-27T05:02:58.383

1

remove the entry from the migration table. and also remove references if that used in another migrations file.

edited Jul 27 '17 at 05:02

answered Jul 27 '17 at 05:02

Vishal Varshney

905
6
11

i have removed, mentioned in the question – Geethu Jul 27 '17 at 05:02
also remove references if that used in another migrations file – Vishal Varshney Jul 27 '17 at 05:03
no other migration files only a single migration file exist – Geethu Jul 27 '17 at 05:04

score 1 · Answer 3 · answered Jul 27 '17 at 06:30

1

Deleting migration files manually will not remove them from the Laravel cache. You can remove them by executing this.

php artisan optimize

answered Jul 27 '17 at 06:30

Prasanna J Sharma

49
1
5

Deleted migration files getting executed : Laravel application

3 Answers3