For some reason whenever I run any php artisan
command I get an error saying one of my tables doesn't exist. This is true, I'm starting on a new database. What I can't figure out is why on earth artisan needs to use this table? The error that shows up is:
[Illuminate\Database\QueryException]
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'happylister.categories' doesn't exist (SQL: select * from `categories` order by `name` asc)
[PDOException]
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'happylister.categories' doesn't exist
I just can't figure out for the life of me where that query is coming from - even just using php artisan
generates this error. I first noticed this when I tried to run php artisan migrate
to set up the tables, which of course failed. Then I noticed ALL php artisan
commands fail.
And yes, Artisan does use database to check some stuff under the hood.
It happens to me as well. Someone suggested that it might happen because of a seeder or a console command that is trying to use a missing table and the suggested solution is to comment the command or seeder in Kernel/Seeder. PS: I tried that but it didn't work.
Just fixed it. I was making a model select in the AppServiceProvider boot() function. The table for it was not created yet.
Sign in to participate in this thread!
The Laravel portal for problem solving, knowledge sharing and community building.
The community