Laravel migration error: Base table or view not found

Question

I got the following error. How can I fix it?

Base table or view not found: 1146 Table 'account_infos'

Migration

public function up()
{
    Schema::create('account_info', function (Blueprint $table) {
        $table->id();
        $table->unsignedBigInteger('users_id');
        $table->foreign('users_id')->references('id')
            ->on('users')->onDelete('cascade');
        $table->unsignedBigInteger('axis_id');
        $table->foreign('axis_id')->references('id')
            ->on('axis')->onDelete('cascade');
        $table->enum('account_type',['legal','rightful']);
        $table->timestamps();
    });
}

Do you have another migrations that reference to `account_infos`? — Lessmore, Jul 15 '21 at 22:32
Do you get the error when running migration or working with routes or ..? — Mohsen Nazari, Jul 15 '21 at 22:36
Migration is successful but gives an error message when I try to call the forms — jason bourne, Jul 15 '21 at 22:39

Meysam Zandy · Accepted Answer · 2021-07-15T22:47:30.233

4

Just add:

    protected $table='account_info';

in your model

edited Jul 15 '21 at 22:47

answered Jul 15 '21 at 22:33

Meysam Zandy

296
7
18

1

He says the error is in migration, not Model. At least this is what he says! But I think you are right somehow, he does not know where he is facing the problem!! – Mohsen Nazari Jul 15 '21 at 22:35

Laravel migration error: Base table or view not found

1 Answers1