Error map

no such table SQLite: no such table: X

SQL · layer 5, Data

Open the full error page →

Centre: this error. First ring: errors it is linked with (8). Outer ring: what those are linked with. Colours show the layer of a request each error belongs to. Click any dot to re-centre the map on it; hover to follow its connections. The centre dot opens the error page.

no such table — SQLite: no such table: X (SQL)no such tab…unable to open database — sqlite3.OperationalError: unable to open database file (SQL)unable to open data…readonly database — sqlite3.OperationalError: attempt to write a readonly database (SQL)readonly databaseSQLite no such column — sqlite3.OperationalError: no such column: x (SQL)SQLite no such colu…208 — SQL Server: Invalid object name 'x'. (Msg 208) (SQL)208collation — SQLite: no such collation sequence: X (SQL)collationtransaction — SQLite: cannot start a transaction within a transaction (SQL)transactionno column — SQLite: table X has no column named Y (SQL)no columnno such function — SQLite: no such function: X (SQL)no such functionFileNotFoundError — FileNotFoundError: [Errno 2] No such file or directory: 'data.csv' (Python)FileNotFoundErrorSQLITE_BUSY — sqlite3.OperationalError: database is locked (SQLITE_BUSY) (SQL)SQLITE_BUSYSQLite FK failed — sqlite3.IntegrityError: FOREIGN KEY constraint failed (SQL)SQLite FK failedEACCES — Linux: Permission denied (Linux)EACCESSQLite UNIQUE failed — sqlite3.IntegrityError: UNIQUE constraint failed: users.email (SQL)SQLite UNIQUE failedSQLite NOT NULL failed — sqlite3.IntegrityError: NOT NULL constraint failed: table.column (SQL)SQLite NOT NULL fai…1054 — MySQL ERROR 1054 (42S22): Unknown column in 'field list' (MySQL)105442703 — PostgreSQL: ERROR: column "x" does not exist (PostgreSQL)42703malformed database — sqlite3.DatabaseError: database disk image is malformed (SQL)malformed database1146 — MySQL ERROR 1146 (42S02): Table 'db.table' doesn't exist (MySQL)114642P01 — PostgreSQL: ERROR: relation "x" does not exist (PostgreSQL)42P01207 — SQL Server: Invalid column name 'x'. (Msg 207) (SQL)2071406 — MySQL ERROR 1406: Data too long for column (MySQL)14061005 — MySQL ERROR 1005 (HY000): Can't create table (errno: 150 "Foreign key constraint is incorrectly formed") (MySQL)10051007 — MySQL ERROR 1007 (HY000): Can't create database 'x'; database exists (MySQL)1007Deadlock — Deadlock found when trying to get lock; try restarting transaction (SQL)DeadlockLock wait timeout — Lock wait timeout exceeded; try restarting transaction (MySQL 1205) (SQL)Lock wait timeoutSQLite syntax error — sqlite3.OperationalError: near "x": syntax error (SQL)SQLite syntax error1008 — MySQL ERROR 1008 (HY000): Can't drop database 'x'; database doesn't exist (MySQL)10081051 — MySQL ERROR 1051 (42S02): Unknown table 'x' (MySQL)10511060 — MySQL ERROR 1060 (42S21): Duplicate column name 'x' (MySQL)1060ArgumentCountError — Fatal error: Uncaught ArgumentCountError: Too few arguments to function foo(), 1 passed and exactly 2 expected (PHP)ArgumentCountError42883 function — ERROR: function x(text) does not exist — No function matches the given name and argument types (PostgreSQL)42883 functionTypeError arguments — TypeError: f() takes 1 positional argument but 2 were given (Python)TypeError arguments

Directly related (8)

Two steps away (24)

FileNotFoundErrorPython

FileNotFoundError: [Errno 2] No such file or directory: 'data.csv'

Python couldn’t find the file at that path — usually because relative paths resolve from the working directory, not the script.

SQLITE_BUSYSQL

sqlite3.OperationalError: database is locked (SQLITE_BUSY)

Another connection holds a write lock on the SQLite file, and this one gave up waiting.

SQLite FK failedSQL

sqlite3.IntegrityError: FOREIGN KEY constraint failed

An insert/update/delete violated a foreign key in SQLite (with PRAGMA foreign_keys=ON).

EACCESLinux

Linux: Permission denied

Your user (or the service user) lacks read/write/execute permission on a file, directory or one of its parents.

SQLite UNIQUE failedSQL

sqlite3.IntegrityError: UNIQUE constraint failed: users.email

An insert/update duplicated a value in a UNIQUE or PRIMARY KEY column in SQLite.

SQLite NOT NULL failedSQL

sqlite3.IntegrityError: NOT NULL constraint failed: table.column

A NULL went into a NOT NULL column in SQLite.

1054MySQL

MySQL ERROR 1054 (42S22): Unknown column in 'field list'

The query references a column that doesn’t exist in the table (or an unquoted string being read as a column).

42703PostgreSQL

PostgreSQL: ERROR: column "x" does not exist

PostgreSQL can’t find the column — a missing migration, a case-sensitive quoted name, or a string literal written in double quote…

malformed databaseSQL

sqlite3.DatabaseError: database disk image is malformed

The SQLite file is corrupted.

1146MySQL

MySQL ERROR 1146 (42S02): Table 'db.table' doesn't exist

The query references a table that MySQL can’t find in that database.

42P01PostgreSQL

PostgreSQL: ERROR: relation "x" does not exist

The table/view isn’t found — missing migration, wrong schema, or a case-sensitive quoted name.

207SQL

SQL Server: Invalid column name 'x'. (Msg 207)

SQL Server can’t find the column — typo, missing migration, or a string in double quotes with QUOTED_IDENTIFIER ON.

1406MySQL

MySQL ERROR 1406: Data too long for column

The value is longer than the column allows (e.g. 300 characters into VARCHAR(255)), and strict mode rejects it instead of truncat…

1005MySQL

MySQL ERROR 1005 (HY000): Can't create table (errno: 150 "Foreign key constraint is incorrectly formed")

A foreign key definition is invalid — the referenced column’s type, index or charset doesn’t match.

1007MySQL

MySQL ERROR 1007 (HY000): Can't create database 'x'; database exists

CREATE DATABASE ran for a database that already exists.

DeadlockSQL

Deadlock found when trying to get lock; try restarting transaction

Two transactions waited on each other’s locks; the database killed one so the other could continue.

Lock wait timeoutSQL

Lock wait timeout exceeded; try restarting transaction (MySQL 1205)

A query waited too long for a row lock held by another transaction and gave up.

SQLite syntax errorSQL

sqlite3.OperationalError: near "x": syntax error

SQLite couldn’t parse the statement; the token after “near” is where it stopped.

1008MySQL

MySQL ERROR 1008 (HY000): Can't drop database 'x'; database doesn't exist

DROP DATABASE targeted a database that isn’t there.

1051MySQL

MySQL ERROR 1051 (42S02): Unknown table 'x'

DROP TABLE targeted a table that doesn’t exist.

1060MySQL

MySQL ERROR 1060 (42S21): Duplicate column name 'x'

A CREATE/ALTER adds a column that already exists, or a SELECT in a view/derived table produces two columns with the same name.

ArgumentCountErrorPHP

Fatal error: Uncaught ArgumentCountError: Too few arguments to function foo(), 1 passed and exactly 2 expected

A function was called with fewer arguments than it requires.

42883 functionPostgreSQL

ERROR: function x(text) does not exist — No function matches the given name and argument types

PostgreSQL found no function with that name and argument types — wrong types, missing extension, or schema not in search_path.

TypeError argumentsPython

TypeError: f() takes 1 positional argument but 2 were given

A function was called with more positional arguments than it accepts — very often a method missing `self`.