php artisan migrate: Base table or view not found

hi guys sorry , I am newbie in laravel, help me.

this message appears when i type php artisan migrate

[Illuminate\Database\QueryException] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'api_prominas.pm_avaliacao_inscricao_status' doe sn't exist (SQL: alter table pm_avaliacao_inscricao_status add id int unsigned not null auto_increment primary key, add nome varchar(55) not null)

[PDOException] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'api_prominas.pm_avaliacao_inscricao_status' doe sn't exist

already tried, composer dump-autoload.

aivis

10 years ago

Best Answer

Level 14

Check your migration file, maybe you are using Schema::table, like this:

Schema::table('table_name', function ($table)  {
    // ...
});

If you want to create a new table you must use Schema::create:

Schema::create('table_name', function ($table)  {
    // ...
});

See the Laravel migration documentation for more information.

If you are using Schema::create then please provide the contents of your migration file.

9 likes

gustavojnt

10 years ago

Level 1

That's right , thank you

Please or to participate in this conversation.