Database Laravel 8 Laravel 9 Laravel 10 Laravel 11 Laravel 12

Unknown Column Error in Laravel - How to Fix

This error occurs when querying or inserting data with a column name that doesn't exist in the database table.

The Error

Error Message 
SQLSTATE[42S22]: Column not found: 1054 Unknown column

Common Causes

  1. 1 Column doesn't exist in table
  2. 2 Typo in column name
  3. 3 Migration not run after adding column
  4. 4 Model $fillable referencing non-existent column
  5. 5 Using wrong table alias in query

Solutions

1

Run pending migrations

Bash 
php artisan migrate
2

Check which columns exist

Bash 
php artisan tinker
>>> Schema::getColumnListing('posts')
3

Create migration to add missing column

Bash 
php artisan make:migration add_status_to_posts_table --table=posts

// In migration up() method
$table->string('status')->default('draft');
4

Check for typos in your query

PHP 
// Wrong
Post::where('staus', 'published')->get();

// Correct
Post::where('status', 'published')->get();

Need Help With Your Laravel Project?

I specialize in building custom Laravel applications, process automation, and SaaS development. Whether you need to eliminate repetitive tasks or build something from scratch, let's discuss your project.

Schedule Free Consultation View My Work

Currently available for 2-3 new projects

Hafiz Riaz

About Hafiz

Full Stack Developer from Italy. I build web applications with Laravel and Vue.js, and automate business processes. Creator of ReplyGenius, StudyLab, and other SaaS products.

View Portfolio

Related Errors

Database

SQLSTATE 42S02 Table Not Found in Laravel - Fix

SQLSTATE[42S02]: Base table or view not...

Database

Migration Failed in Laravel - How to Debug and Fix

Migration table not found / Migration fa...

Database

Laravel Database Connection Refused Error - Fix

SQLSTATE[HY000] [2002] Connection refuse...