Framework: Base table or view already exists: 1050 Table 'users' already exists

Created on 9 Sep 2017 · 8Comments · Source: laravel/framework

Laravel Version: 5.5.3
PHP Version: 7.1
Database Driver & Version: MariaDB 10.1.26

Description:

php artisan migrate

[IlluminateDatabaseQueryException]
SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'users' already exists (SQL: create table users (id int unsigned not null aut
o_increment primary key, name varchar(255) not null, email varchar(255) not null, 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 engine = InnoDB R
OW_FORMAT=DYNAMIC)

[PDOException]
SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'users' already exists

Steps To Reproduce:

laravel new website
php artisan make:migration create_lists_table --create=lists
php artisan migrate

Problem

It Creates users table and give error but not creating lists table

Source

niteshkumarniranjan

Most helpful comment

I Solved My Problem Myself
by Changing My create_users_table.php

<?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()
    {
        Schema::dropIfExists('users');
        Schema::create('users', function (Blueprint $table) {
            $table->increments('id');
            $table->string('name');
            $table->string('email')->unique();
            $table->string('password');
            $table->rememberToken();
            $table->timestamps();
        });
    }

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

niteshkumarniranjan on 9 Sep 2017

👍14 🎉6 😕5

All 8 comments

there must be existing table 'users' already created, even before install

huglester on 9 Sep 2017

This repo is for bug tracking. Use the forums or slack channel for solving your issue

Dylan-DPC on 9 Sep 2017

I Solved My Problem Myself
by Changing My create_users_table.php

<?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()
    {
        Schema::dropIfExists('users');
        Schema::create('users', function (Blueprint $table) {
            $table->increments('id');
            $table->string('name');
            $table->string('email')->unique();
            $table->string('password');
            $table->rememberToken();
            $table->timestamps();
        });
    }

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

niteshkumarniranjan on 9 Sep 2017

👍14 🎉6 😕5

Then close the issue

Dylan-DPC on 9 Sep 2017

👎2 😄1

@niteshkumarniranjan thanks, your solution helped me too, viz, Schema::dropIfExists.