Support the ongoing development of Laravel.io →
Installation Database

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.

Last updated 3 years ago.
0
  1. Check if the database is really called happylister
  2. Check in your .env file or config/database.php that you're really connecting to the database happylister and not another one
0

And yes, Artisan does use database to check some stuff under the hood.

0

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.

0

Just fixed it. I was making a model select in the AppServiceProvider boot() function. The table for it was not created yet.

0

Sign in to participate in this thread!

Eventy

Your banner here too?

gnack gnack Joined 4 Feb 2014

Moderators

We'd like to thank these amazing companies for supporting us

Your logo here?

Laravel.io

The Laravel portal for problem solving, knowledge sharing and community building.

© 2025 Laravel.io - All rights reserved.