Laravel: 1060 Duplicate column name while running migrations

Question

I am getting the following error when running migrations:

PDOException::("SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'role_id'")

<?php

use Illuminate\Support\Facades\Schema;

use Illuminate\Database\Schema\Blueprint;

use Illuminate\Database\Migrations\Migration;

class CreateUsersTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {

        if(!Schema::hasTable('users')) {
            Schema::create('users', function (Blueprint $table) {
                $table->increments('id');
                $table->string('name');
                $table->string('email')->unique();
                $table->timestamp('email_verified_at')->nullable();
                $table->string('password');
                $table->rememberToken();
                $table->timestamps();
            });
        }

        Schema::table('users', function (Blueprint $table) {
            $table->integer('role_id')->unsigned();
            $table->string('first_name')->nullable();
            $table->string('middle_name')->nullable();
            $table->string('last_name')->nullable();
            $table->string('city')->nullable();
        });
    }

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

        Schema::table('users', function (Blueprint $table) {
        $table->dropColumn('role_id');
         });
    }
}

I have deleted most of the migrated tables as it gives duplication issues. Could that be related to my existing problem ?

why you are not running new migration file for editing the user table — Shailendra Gupta
– Shailendra Gupta, Commented Oct 29, 2018 at 7:54
seems to be you already have the table in your database, or you have already run the migration. — User123456
– User123456, Commented Oct 29, 2018 at 7:57

Kapitan Teemo · Accepted Answer · 2018-10-29 08:42:35Z

2

try running these commands in your terminal:

composer dump-autoload // updates whatever you changed in your migration
php artisan migrate:fresh // migrates migration from the start

if these doesn't not work, post your column structure so we can understand more about your problem.

answered Oct 29, 2018 at 8:42

Kapitan Teemo

2,1641 gold badge15 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Ghanasyam Suthan Over a year ago

it did not work. Now the user table is empty and i cannot loggin. Update: i have again registered as a user and the login works now.

Ghanasyam Suthan Over a year ago

Now the current situation is like before all the migrations were created. But Those all old tables exists in the editor. If i have to create all migrations fresh, it will be a waste of time for me. Could you advise me whether i could use all the existing migrations in the editor.

Ghanasyam Suthan Over a year ago

Somehow Migrations worked now without error. I didnt had to create all those old migrations from the scratch fortunately.

Kapitan Teemo Over a year ago

if you have a seeder, then use this command php artisan migrate:fresh --seed.

Collectives™ on Stack Overflow

Laravel: 1060 Duplicate column name while running migrations

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related