SQLSTATE[42S02] Base table or view not found

1. About the error
2. Why do I see this error
3. Solution
4. Run your migrations
5. Confirm you're on the right database
6. Check the model's table name

#About the error

In Laravel the message reads:

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'my_app.users' does not exist

The query is valid SQL, but the table it names isn't present in the database you're connected to.

#Why do I see this error

• Your migrations haven't run, so the table was never created.
• You're connected to the wrong database (wrong DB_DATABASE, or a fresh/empty database).
• The table name has a typo, or you renamed it without updating the model's $table.
• A migration failed halfway and the table was rolled back or never committed.

#Solution

#Run your migrations

The most common fix, especially on a fresh checkout or a new environment:

php artisan migrate

To check what has and hasn't run:

php artisan migrate:status

On a development database you can rebuild everything from scratch:

php artisan migrate:fresh

Be careful: migrate:fresh drops every table first. Never run it against a database with data you care about.

#Confirm you're on the right database

Verify your connection settings point where you think they do:

DB_DATABASE=my_app

Then check the table really exists there:

SHOW TABLES FROM my_app;

If the value changed recently, clear any cached config so Laravel reads the new one:

php artisan config:clear

#Check the model's table name

If Eloquent guesses the wrong table name, set it explicitly:

class Customer extends Model
{
    protected $table = 'customers';
}

See environment variables in Laravel for how the connection is configured.