SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'payments' already exists (SQL: create table `payments`

table 'users' already exists mysql
migration table already exists
base table or view already exists: 1050 table telescope_entries
doctrine dbal driver pdoexception sqlstate 42s01 base table or view already exists 1050
a createjobstable migration already exists
relation already exists laravel
php artisan migrate:reset
column already exists laravel migration

When I migrate a table I see this error,

SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'payments' already exists (SQL: create table payments

<?php

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

class CreatePaymentsTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('payments', function (Blueprint $table) {
            $table->increments('id');
            $table->integer('user_id')->unsigned();
            $table->foreign('user_id')->references('id')->on('users')->onDelete('cascade');
            $table->string('resnumber');
            $table->string('course_id')->default('vip');
            $table->string('price');
            $table->boolean('payment')->default(false);
            $table->timestamps();
        });
    }

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

Error

If you want to recreate the table, run php migrate:rollback first to delete the existing one. This command will run the down() method in the migration.

Then run php migrate to create the table again.

Laravel 5.5 Error Base table or view already exists: 1050 Table , I Solved My Problem Myself by Changing My create_users_table.php <?php use Illuminate\Support\Facades\Schema; use  SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'users' already exists. create_jobs_table.php. use Illuminate\Database\Schema\Blueprint; use Illuminate\Database\Migrations\Migration; class CreateJobsTable extends Migration { /** * Run the migrations.

If you are on Laravel 5.5 you can do php artisan migrate:fresh. This command will drop all tables und then create them again. I hope it helps.

SQLSTATE[42S01]: Base table or view already exists: 1050 , SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'users' already exists #1116. Closed. Moix1 opened this issue on May 23,  SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'users' already exists (SQL: create table users (id int unsigned not null auto_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

If you have table in DB and dont want migrate create it, you can ignore it by check Schema::hasTable before create

    public function up()
{
    if(Schema::hasTable('products')) return;       //add this line to migration file
    Schema::create('products', function (Blueprint $table) {
        $table->increments('id');
        $table->timestamps();

    });
}

Base table or view already exists: 1050 Table 'users' already exists , SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'users' already exists (SQL: create table users ( id int unsigned not null aut 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

In my case after php migrate:rollback resulted in Nothing to rollback and didn't solve. Because 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' already 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');
}

SQLSTATE42S01 Base table or view already exists 1050 Table , SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'users' already exists. Why error? As the error is explicit, the table “users” already exist in our  10 MOST Amazing Epoxy Resin and Wood River Table ! Awesome DIY Woodworking Projects and Products - Duration: 16:55. WOOD Presents! Recommended for you

first make php artisan migrate:rollback; then go to php my admin panel and drop the remaining table. then do php artisan migrate:fresh it will work :-)

Laravel 5.8 solving first time migrations errors, if there were no any changes in Magento code (according to the question it just suddenly occurred for no reason), please contact your host,  *[Illuminate\Database\QueryException] 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, role_id int unsigned not null, name varchar(191) not null, email varchar(50) not null, username varchar(191) not null, pas sword varchar(191

Error message "Base table or view already exists , CDbCommand failed to execute the SQL statement: SQLSTATE[42S01]: Base table or view already exists: 1050 Table '`limesurvey2`.`lime_plugins`' already  SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'job_posts' already exists. When I run php artisan migrate:status, the job_posts table is the only one that shows as not ran, even though it clearly already has been ran.

i have problem with migration when i use php artisan migrate show , [PDOException] SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'users' already exists. // I can not see the other tables except the user table in  SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'character_f itting_items' already exists (SQL: create table `character_fitting_items` ( `fitting_id` bigint not null, `type_id` int not null, `flag` int not null,

Update failed: Failed: SQLSTATE[42S01]: Base table or view , Update failed: Failed: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'reaction_user_track' already exists: RENAME TABLE  docker-compose exec phpfpm /var/www/laravel/artisan migrate Illuminate\Database\QueryException : SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'posts' already exists (SQL: create table `posts` (`id` int unsigned not null auto_increment primary key, `title` varchar(255) not null, `created_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci')

Comments
  • do you have payments table already, share snapshot of all tables also ?
  • this may due to some table remain in the database so you may delete them and the problem will be solved