laravel 5 migration error when run newly created mirgration file

Question

i just have created a new migration file, to insert a new column to existing table.

the file code is:

<?php

use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class AddStatusToPhoto extends Migration {

    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::table('photos', function(Blueprint $table)
        {
            $table->integer('status');
        });

    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        //
    }


}

but when i run php artisan migrate, there is an error message:

  [Illuminate\Database\QueryException]
  SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'permission_
  role' already exists (SQL: create table `permission_role` (`id` int unsigne
  d not null auto_increment primary key, `permission_id` int unsigned not nul
  l, `role_id` int unsigned not null, `created_at` timestamp default 0 not nu
  ll, `updated_at` timestamp default 0 not null) default character set utf8 c
  ollate utf8_unicode_ci)

anyone know what is the problem?

In your permission_role migration script, have to added drop table inside `down()`? — Gaurav Dave, May 04 '16 at 06:23
I noticed that permission_role table did not rollbacked , Aldo when i manually delete it , the same error still exist . — mercury, Mar 04 '17 at 19:51

score 0 · Answer 1 · edited May 23 '17 at 12:00

Your previous migration role ran only semi-successfully. This means that the table permission_role got added, but terminated early. Because of that, the migration never got marked as complete and added to the migrations table. It tries to re-run the Permissions migration file, but fails as the table already exists. You either need to add the old migration file to the database manually, or make it so it runs successfully.

It is possible to remove the code, or wrap it in an if statement.
Is there any way to detect if a database table exists with Laravel

score 0 · Answer 2 · answered May 04 '16 at 05:01

0

Make sure the table did not physically exists in the database and down() method should contain code that be able to drop that table.

answered May 04 '16 at 05:01

user6288916

1

This should be comment – ketan May 04 '16 at 05:12

score 0 · Answer 3 · answered May 04 '16 at 05:02

You should have to record first the migration raw file in migrations table by using the command "php artisan migrate" before using the command "php artisan migrate:refresh" and also you need to correct the down method.

The migrate:refresh command will first roll back all of your database migrations, and then run the migrate command. This command effectively re-creates your entire database:

php artisan migrate:refresh

php artisan migrate:refresh --seed

Refer this documentation.

i'had tried refresh but not work(and also i remember will delete all data?), finally i delete all old migration file temporarily — hkguile, May 04 '16 at 05:47

score 0 · Answer 4 · answered Aug 22 '17 at 13:18

0

put this line of code in your migrations

if(!Schema::hasTable('post')){
  Schema::create('post', function (Blueprint $table) {
            $table->increments('id');
            #etc
        });
}

answered Aug 22 '17 at 13:18

muha

27
1
6

laravel 5 migration error when run newly created mirgration file

4 Answers4