Error map
1054 MySQL ERROR 1054 (42S22): Unknown column in 'field list'
MySQL · layer 5, Data
Centre: this error. First ring: errors it is linked with (12). 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.
Directly related (12)
MySQL ERROR 1067 (42000): Invalid default value for 'created_at'
A column’s DEFAULT isn’t allowed in the current SQL mode — classically '0000-00-00 00:00:00' with NO_ZERO_DATE.
MongoDB: MongoServerError: Document failed validation (code 121)
The collection has a JSON Schema validator and the inserted/updated document doesn’t satisfy it.
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.
ORA-00904: "X": invalid identifier
A column name in the statement doesn’t exist (or is misquoted).
Column reference is ambiguous / Column 'id' in field list is ambiguous (MySQL 1052)
A column name exists in more than one joined table, so the database doesn’t know which one you mean.
MySQL ERROR 1075 (42000): Incorrect table definition; there can be only one auto column and it must be defined as a key
An AUTO_INCREMENT column isn’t indexed (or there are two auto-increment columns).
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.
MySQL ERROR 1146 (42S02): Table 'db.table' doesn't exist
The query references a table that MySQL can’t find in that database.
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…
sqlite3.OperationalError: no such column: x
SQLite can’t find the column — missing migration, typo, or a string written in double quotes.
API Error: Request failed schema validation (must NOT have additional properties / Additional properties are not allowed)
The JSON body doesn’t match the endpoint’s schema — an unknown property, wrong nesting, or a missing required object.
MySQL ERROR 1064 (42000): You have an error in your SQL syntax
MySQL couldn’t parse the query. The text after “near” shows where parsing failed.
Two steps away (34)
MySQL ERROR 1007 (HY000): Can't create database 'x'; database exists
CREATE DATABASE ran for a database that already exists.
MySQL ERROR 1008 (HY000): Can't drop database 'x'; database doesn't exist
DROP DATABASE targeted a database that isn’t there.
MySQL ERROR 1051 (42S02): Unknown table 'x'
DROP TABLE targeted a table that doesn’t exist.
PostgreSQL: ERROR: relation "x" does not exist
The table/view isn’t found — missing migration, wrong schema, or a case-sensitive quoted name.
HTTP 422 Unprocessable Content
The request is well-formed, but the data fails validation (e.g. invalid email, missing required field).
GraphQL: Cannot query field "x" on type "Y"
The query asks for a field that doesn’t exist in the server’s schema (or isn’t available on that type).
MySQL ERROR 1452: Cannot add or update a child row: a foreign key constraint fails
You inserted/updated a row whose foreign key value doesn’t exist in the referenced parent table.
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…
MySQL ERROR 1071 (42000): Specified key was too long; max key length is 767 bytes
An index on a VARCHAR is too long for the row format — classic with utf8mb4 VARCHAR(255) on MySQL 5.6/MariaDB 10.1.
SQL Server: Invalid object name 'x'. (Msg 208)
The table/view doesn’t exist in the current database or schema.
ORA-00942: table or view does not exist
Oracle can’t see the table — it doesn’t exist, is in another schema, or you lack privileges on it.
ORA-00001: unique constraint (SCHEMA.PK_X) violated
An insert/update duplicated a value in a unique or primary key constraint.
Column must appear in the GROUP BY clause / isn't in GROUP BY (MySQL 1055 only_full_group_by)
You selected a column that is neither grouped nor aggregated, so the result would be ambiguous.
ERROR: syntax error at or near "x"
PostgreSQL couldn’t parse the SQL; the token shown is where parsing failed.
ERROR: missing FROM-clause entry for table "x"
The query references a table/alias that isn’t in the FROM clause (or uses the wrong alias).
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.
SQL Server: Conversion failed when converting the varchar value 'x' to data type int. (Msg 245)
SQL Server tried to convert text to a number (often implicitly) and hit a non-numeric value.
SQL Server: Arithmetic overflow error converting expression to data type int. (Msg 8115)
A value or calculation exceeds the target data type’s range.
SQL Server: Cannot insert explicit value for identity column in table 'x' when IDENTITY_INSERT is set to OFF.
An INSERT supplied a value for an IDENTITY column.
MySQL ERROR 1044 (42000): Access denied for user to database
The login succeeded, but the user has no privileges on the database you’re using.
MySQL ERROR 1022 (23000): Can't write; duplicate key in table
An ALTER/CREATE produced a duplicate key or constraint name — often a foreign key name that already exists in the database.
MySQL ERROR 1061 (42000): Duplicate key name 'x'
CREATE INDEX/ADD INDEX used an index name that already exists on the table.
PostgreSQL: ERROR: duplicate key value violates unique constraint
An INSERT/UPDATE would create a duplicate in a UNIQUE or PRIMARY KEY column — or the id sequence is behind the existing data.
ERROR: column "x" of relation "y" already exists
ALTER TABLE ADD COLUMN for a column that’s already there.
ERROR: cannot drop table x because other objects depend on it
Views, foreign keys or other objects depend on what you’re dropping.
sqlite3.IntegrityError: FOREIGN KEY constraint failed
An insert/update/delete violated a foreign key in SQLite (with PRAGMA foreign_keys=ON).
sqlite3.OperationalError: attempt to write a readonly database
The process can’t write to the SQLite file or its directory.
sqlite3.OperationalError: unable to open database file
SQLite couldn’t open or create the database file — wrong path or missing/unwritable directory.
MySQL ERROR 1091 (42000): Can't DROP 'x'; check that column/key exists
ALTER TABLE tried to drop a column or index that doesn’t exist.
MySQL ERROR 1215 (HY000): Cannot add foreign key constraint
The foreign key can’t be created — mismatched column types, missing index, or incompatible engines/collations.
MySQL ERROR 3780 (HY000): Referencing column 'x' and referenced column 'y' in foreign key constraint are incompatible.
MySQL 8 refuses a foreign key between columns of different types or collations.
MySQL ERROR 1366: Incorrect string value: '\xF0\x9F\x98\x80' for column
The text contains characters (usually emoji) that the column’s character set can’t store — the column or connection is `utf8`/`ut…
Fatal error: Uncaught mysqli_sql_exception
A MySQLi query or connection failed; since PHP 8.1 MySQLi throws exceptions by default.
sqlite3.OperationalError: near "x": syntax error
SQLite couldn’t parse the statement; the token after “near” is where it stopped.
Map another error
Popular: 403500400TypeErrorCritical error0xC000007BNullPointerException404