Base table or view not found laravel - Running scheduler cron

Question

while running php artisan eventnotification:mail in command, it throws below error
"SQLSTATE[42S02]: Base table or view not found: 1146 Table "

My appserviceprovider.php

public function boot() {
    $rolesList = $this->getRolesList();
    View::share("rolesListArr", $rolesList);
}

My cron job:

protected function schedule(Schedule $schedule)
{
    $schedule->command('eventnotification:mail')->everyMinute();

}

How can i fix the " [Illuminate\Database\QueryException] SQLSTATE[42S02]: Base table or view not found: 1146 Table "

for creating a notification you run this command ....php artisan make:notification email — Ali, Nov 15 '18 at 09:31
yes that has been created.. while running "php artisan eventnotification:mail", it shows the error, which i have mentioned — Dhana Balan, Nov 15 '18 at 09:36
i think there is no command like this. what do you want to achieve with this coammand? — Ali, Nov 15 '18 at 09:46
i have created notification email, and i try to run in command prompt. — Dhana Balan, Nov 15 '18 at 10:03
You can't run it in command prompt. check this how notication works. https://laravel.com/docs/5.7/notifications — Ali, Nov 15 '18 at 10:05

Ismoil Shifoev · Answer 1 · 2018-11-28T08:36:41.023

0

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)  {
    // ...
});

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

edited Nov 28 '18 at 08:36

answered Nov 15 '18 at 08:59

Ismoil Shifoev

thanks for your immediate response.. could you please elaborate your answer – Dhana Balan Nov 15 '18 at 09:11
for me , its was in the boot method of the app service provider as i set up a view::share() and i have already changed the database. – Ismoil Shifoev Nov 28 '18 at 08:33

1 Answers1