Laravel migrations error

Question

When I run php artisan migrate i get error B

Base table or view already exists: 1050 Table 'categories' already exists'

What is it? Why? How to find error? My categories migrations file:

<?php

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

class CategoriesTable extends Migration
{

    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('categories', function (Blueprint $table) {

            $table->increments('id');

            $table->string('title')->index();
            $table->text('description');

            $table->integer('attachment_id')->unsigned()->index();
            $table->foreign('attachment_id')->references('id')->on('attachment')->onDelete('cascade');
            $table->timestamps();
        });
    }

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

}

Sounds like that table already exists in your DB.. have you checked that it doesn't? — msturdy, Dec 02 '14 at 13:48
even if I delete the table, the error remains. is not the case — engilexial, Dec 02 '14 at 13:49
How are you deleting the table? Seems like you haven't defined the `down()` method in your migration file, so artisan won't delete that table — msturdy, Dec 02 '14 at 13:52
some of my migration triggered and tables are created. but not all — engilexial, Dec 02 '14 at 13:55
Possible duplicate of [Laravel 5.5 Error Base table or view already exists: 1050 Table 'users' already exists](https://stackoverflow.com/questions/46129270/laravel-5-5-error-base-table-or-view-already-exists-1050-table-users-already) — Nitesh Kumar Niranjan, Sep 15 '17 at 13:25

score 0 · Answer 1 · answered Dec 02 '14 at 14:25

0

In that migration file, the function drop() should be

public function down()
{
    Schema::drop('categories');
}

answered Dec 02 '14 at 14:25

Macaulay Babalola----Web Dev.

14
4

score 0 · Answer 2 · answered Dec 08 '14 at 22:59

0

It seems that you try to create existing table..

so i think you are editing the migration file that you already installed

you can drop your database and re-migrate it

php artisan migrate:reset

then

php artisan migrate

answered Dec 08 '14 at 22:59

Moamen Abdelwahed

587
7
19

Laravel migrations error

2 Answers2