# sqlite3.OperationalError: no such column: x

**Code:** `SQLite no such column` · **Category:** SQL · **Seen on:** SQL

SQLite can’t find the column — missing migration, typo, or a string written in double quotes.

## Meaning

In SQLite, double quotes mean identifiers; a value in double quotes that doesn’t match a column becomes “no such column”.

## Common causes

- String values in double quotes
- Column added in code but not migrated
- Typo

## Quick fix

1. Use single quotes for strings
2. Run migrations
3. Inspect the table: PRAGMA table_info(t)

## Detailed fix by platform

### SQL

1. `PRAGMA table_info(users);`

## How to diagnose

1. **Column** — Exists?
2. **Quotes** — Double-quoted value?

---
Source: [WhatIsMyError](https://whatismyerror.com/errors/sql/sqlite-no-such-column)