Base table or view not found during migration

Question

I am running exiting laravel project in homestead. When run php artisan migrate get the error.

Here is full error.

In Connection.php line 664:

  SQLSTATE[42S02]: Base table or view not found: 1146 Table 'forum.chanel' doesn't exist (SQL: select * from `chanel`)  


In Connection.php line 326:

  SQLSTATE[42S02]: Base table or view not found: 1146 Table 'forum.chanel' doesn't exist

This is my chanel table

public function up()
    {
        Schema::create('chanels', function (Blueprint $table) {
            $table->increments('id');
            $table->string('title');
            $table->string('slug');
            $table->timestamps();
        });
    }

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

Why i getting the error and how can i solve this error?

Get the error when run composer update

database name is forum – Shunhra Sarker Mar 31 '19 at 06:23 — Shunhra Sarker, Mar 31 '19 at 06:23
check name and order of your migration – Sohel0415 Mar 31 '19 at 06:29 — Sohel0415, Mar 31 '19 at 06:29
All are like before i run the project – Shunhra Sarker Mar 31 '19 at 06:41 — Shunhra Sarker, Mar 31 '19 at 06:41

score 0 · Answer 1 · answered Mar 31 '19 at 06:26

0

You need to check your migration table to see if this migration was already run in the past, it is commong that developers change the code after they run the migration.

Or, you might have some even / interception that is running the query select * from chanel just before the migration running, and it making the migration to fail.

answered Mar 31 '19 at 06:26

Avi Fatal

1,550
8
8

You are right, But i can't finding the problem and solution – Shunhra Sarker Mar 31 '19 at 06:41
if its not in production you need to roll back all migrations and migrate again. – Avi Fatal Mar 31 '19 at 06:47

Vipertecpro · Answer 2 · 2019-03-31T06:45:49.730

0

It looks like you're model name and table name are not in sync, Before this remove all tables from DB it could be problem or migration arrangement in migrations table run composer dumpa then

Try updating your model by specifying $table name,

class Chanel extends Model{
    public $table = "chanels";

edited Mar 31 '19 at 06:45

answered Mar 31 '19 at 06:41

Vipertecpro

3,056
2
24
43

Can you please remove all tables from db then migrate again, it is also the case when you're seeding any table data before it's existence. – Vipertecpro Mar 31 '19 at 06:47

score 0 · Answer 3 · answered Mar 31 '19 at 06:50

First need to fresh migration type below command

php artisan migrate:fresh

then run new model with migration file with below command

php artisan make:model chanel -m

with this command auto create a migration file and model file edit migration file location in {your app}\database\migrations

  $table->string('title');
  $table->string('slug');

added above line into public function up(){ // code }

now run migration type below code

php artisan migrate

I this this will help you

no artsan command working. my database is fresh. no table exist — Shunhra Sarker, Mar 31 '19 at 07:04

Base table or view not found during migration

3 Answers3