CODEWITHSUNDEEP
phplaraveldatabase-migration
totymedli
totymedli

Reputation: 31182

Laravel's Artisan says nothing to migrate

I installed migrations with php artisan migrate:install then created a migration with the php artisan migrate:make create_teams_table command. Now I try to run them with the following command that I made according to the official documentation:

php artisan migrate --path=app/foo/migrations/2014_01_21_143531_create_teams_table.php

This gives me the following on the console:

Nothing to migrate.

The migrations table in the database is empty and the new table isn't created neither. I don't understand why the documentation says foo in the path. What does foo mean and where does it comes from? First I tought that the path is wrong because of the foo thing and as I know the path is relative to the app folder so I changed it to app/database/migrations but it doesn't work. I also tried a lot of other path combination but none of them worked.

Did I entered the wrong path? In this case shouldn't the console show some other kind of helpfull message? What does foo mean? How can I run my migration?

Upvotes: 53

Views: 146751

Answers (14)

Alexey Avdeev
Alexey Avdeev

Reputation: 1

If you have this problem and you are using Laravel Sail, then try restarting/recreating your containers after you created migration files. Helped for me.

Upvotes: 0

DeviOus
DeviOus

Reputation: 21

What's happening here is the filename for the migration is cached, and so even though you are changing the migration file, it is not seeing any changes, and so thinks there is nothing to migrate.

There's two ways to fix this:

You can change the file name slightly from from 2014_01_21_143531_create_teams_table.php to 2014_01_21_143532_create_teams_table.php (incrementing the number by 1) and then run php artisan migrate...

or

You can run php artisan optimize:clear to flush the cache and then run php artisan migrate:fresh to do a fresh migration.

Hope this helps!

Upvotes: 1

kichu_kishore
kichu_kishore

Reputation: 49

All you need to do is refresh the migration

    php artisan migrate:refresh --path=app/foo/migrations/2014_01_21_143531_create_teams_table.php

Upvotes: 2

aaryaa9978
aaryaa9978

Reputation: 81

use

php artisan migrate:fresh

it would refresh your database and run your all migrations again

Note:, don't do this in production, it will wipe your all your data. so before running this command do have a backup of your data. in fact, have backup data whenever you are touching database in production.

Upvotes: 3

gasgen
gasgen

Reputation: 369

At least in Laravel 7, you have to add ".php" at the end of the name of the migration.

Example:

php artisan migrate --path=database/migrations/yyyy_mm_dd_table_name.php

Hope this answer help somebody.

Upvotes: 1

Vahid Amiri
Vahid Amiri

Reputation: 11127

You don't need to move the migration file anywhere, just change its filename; for example, increase time integer and then run the migrate command with the path pointing to the migration. e.g: php artisan migrate --path="database/migrations/2019_07_06_145857_create_products_table.php"

Upvotes: 18

Marc Zinni Arranz
Marc Zinni Arranz

Reputation: 1

In my case, i just had to delete a row from my migrations table and then execute

php artisan migrate --path=app/foo/migrations/2014_01_21_143531_create_teams_table.php

Upvotes: 0

anurag dhiwar
anurag dhiwar

Reputation: 111

need to delete 2014_01_21_143531_create_teams_table of migrations table.

  1. go to database(phpmyadmin)
  2. open your database name. 3.open migrations table.
  3. delete the 2014_01_21_143531_create_teams_table row

Upvotes: 11

user3474053
user3474053

Reputation: 679

Try this:

First:

php artisan migrate:reset

Rolled back: 2014_03_28_142140_user_table

Nothing to rollback.

second:

php artisan migrate

Migrated: 2014_03_28_142140_user_table

check the database.

Upvotes: 67

Ras
Ras

Reputation: 197

For anyone who still cannot migrate their database:

Assume you have a file to migrate abc_migrate.php.

Firstly put your file inside the new folder named abc_folder. Then, enter this command php artisan migrate --path=database/migrations/abc_folder/.

You don't have to add file name at last of the directory path.

Done. Hope it helps.

Upvotes: 6

jminkler
jminkler

Reputation: 748

The path argument is for creating a migration for example:

 php artisan migrate:make create_user_table --path=app/database/migrations/user_migrations/

But it is not documented to use while running the migrations, as it was in prior versions of laravel.

Dropping the --path argument should work in your case

Upvotes: 10

Nɪsʜᴀɴᴛʜ ॐ
Nɪsʜᴀɴᴛʜ ॐ

Reputation: 2914

The problem arises if the migrations table in the database is empty. So the solution is open up the tinker from the composer

$ php artisan tinker
>>> Schema::drop('users')
>>> Schema::drop('password_resets')
>>> Schema::drop('orders')
>>> exit
php artisan migrate

Here is the result of the above commands executed

nishanth@localhost:~/Desktop/html/hutch$ php artisan migrate

In Connection.php line 647: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'users' alre ady exists (SQL: create table users (id int unsigned not null auto_incr ement primary key, name varchar(255) not null, email varchar(255) not n ull, 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' alre ady exists

nishanth@localhost:~/Desktop/html/hutch$ php artisan migrate:rollback
Nothing to rollback.
nishanth@localhost:~/Desktop/html/hutch$ php artisan tinker
Psy Shell v0.8.17 (PHP 7.1.20-1+ubuntu16.04.1+deb.sury.org+1 — cli) by Justin Hileman
>>> Schema::drop('users')
=> null
>>> Schema::drop('password_resets')
=> null
>>> Schema::drop('orders')
=> null
>>> exit
Exit:  Goodbye.
nishanth@localhost:~/Desktop/html/hutch$ php artisan migrate
Migrating: 2014_10_12_000000_create_users_table
Migrated:  2014_10_12_000000_create_users_table
Migrating: 2014_10_12_100000_create_password_resets_table
Migrated:  2014_10_12_100000_create_password_resets_table
Migrating: 2018_08_18_071213_create_orders_table
Migrated:  2018_08_18_071213_create_orders_table
nishanth@localhost:~/Desktop/html/hutch$

Also define the method down(), if it doesn't exist.
Otherwise, it'll show

SQLSTATE[42S02]: Base table or view not found: 1051 Unknown table 'XYZ.ABC' (SQL: drop table ABC)

/**
  * Reverse the migrations.
  *
  * @return void
  */
public function down()
{
    Schema::dropIfExists('ABC');
}

Upvotes: 0

Jan Żankowski
Jan Żankowski

Reputation: 8971

What helped me:

php artisan config:cache
php artisan migrate

Upvotes: 11

AntonNiklasson
AntonNiklasson

Reputation: 1749

That foo thing is just an example. Laravel will look for migrations to run in app/database/migrations on default. Try removing that --path parameter and see if it works.

Upvotes: 21

Related Questions