Error map

1136 MySQL ERROR 1136 (21S01): Column count doesn't match value count at row 1

SQL · layer 5, Data

Open the full error page →

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.

5 · Data
1136 — MySQL ERROR 1136 (21S01): Column count doesn't match value count at row 1 (SQL)1136SQLite syntax error — sqlite3.OperationalError: near "x": syntax error (SQL)SQLite syntax errorGROUP BY — Column must appear in the GROUP BY clause / isn't in GROUP BY (MySQL 1055 only_full_group_by) (SQL)GROUP BYambiguous column — Column reference is ambiguous / Column 'id' in field list is ambiguous (MySQL 1052) (SQL)ambiguous columnmissing FROM-clause — ERROR: missing FROM-clause entry for table "x" (PostgreSQL)missing FROM-clauseORA-00933 — ORA-00933: SQL command not properly ended (SQL)ORA-009331248 — MySQL ERROR 1248 (42000): Every derived table must have its own alias (SQL)1248102 — SQL Server: Incorrect syntax near 'x'. (Msg 102) (SQL)102window in WHERE — ERROR: window functions are not allowed in WHERE (SQL)window in WHERE1222 — MySQL ERROR 1222 (21000): The used SELECT statements have a different number of columns (SQL)122242601 — ERROR: syntax error at or near "x" (PostgreSQL)426011066 — MySQL ERROR 1066 (42000): Not unique table/alias: 'x' (SQL)1066aggregate in WHERE — ERROR: aggregate functions are not allowed in WHERE (use HAVING) / MySQL 1111 Invalid use of group function (SQL)aggregate in WHERE1064 — MySQL ERROR 1064 (42000): You have an error in your SQL syntax (MySQL)1064SQLITE_BUSY — sqlite3.OperationalError: database is locked (SQLITE_BUSY) (SQL)SQLITE_BUSYSQLite FK failed — sqlite3.IntegrityError: FOREIGN KEY constraint failed (SQL)SQLite FK failedSubquery returns more than 1 row — Subquery returns more than 1 row (MySQL 1242) / more than one row returned by a subquery used as an expression (SQL)Subquery returns mo…Division by zero — SQL Error: division by zero / Divide by zero error encountered (SQL)Division by zerorecursion limit — Msg 530: The statement terminated. The maximum recursion 100 has been exhausted before statement completion. / MySQL 3636 Recursive query aborted after 1001 iterations (SQL)recursion limit1054 — MySQL ERROR 1054 (42S22): Unknown column in 'field list' (MySQL)105442703 — PostgreSQL: ERROR: column "x" does not exist (PostgreSQL)427031267 — MySQL ERROR 1267 (HY000): Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_0900_ai_ci,IMPLICIT) for operation '=' (SQL)1267ORA-00942 — ORA-00942: table or view does not exist (SQL)ORA-00942ORA-00904 — ORA-00904: "X": invalid identifier (SQL)ORA-00904ORA-00001 — ORA-00001: unique constraint (SCHEMA.PK_X) violated (SQL)ORA-000012627 — SQL Server: Violation of PRIMARY KEY constraint 'x'. Cannot insert duplicate key in object 'y'. (Msg 2627) (SQL)2627245 — SQL Server: Conversion failed when converting the varchar value 'x' to data type int. (Msg 245) (SQL)2458115 — SQL Server: Arithmetic overflow error converting expression to data type int. (Msg 8115) (SQL)8115

Directly related (12)

SQLite syntax errorSQL

sqlite3.OperationalError: near "x": syntax error

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

GROUP BYSQL

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.

ambiguous columnSQL

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.

missing FROM-clausePostgreSQL

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).

ORA-00933SQL

ORA-00933: SQL command not properly ended

Oracle found extra clauses or syntax it doesn’t support at the end of a statement.

1248SQL

MySQL ERROR 1248 (42000): Every derived table must have its own alias

A subquery in FROM wasn’t given an alias.

102SQL

SQL Server: Incorrect syntax near 'x'. (Msg 102)

T-SQL couldn’t parse the statement near the shown token.

window in WHERESQL

ERROR: window functions are not allowed in WHERE

A window function (ROW_NUMBER, RANK, LAG) was filtered directly in WHERE.

1222SQL

MySQL ERROR 1222 (21000): The used SELECT statements have a different number of columns

The SELECTs combined with UNION return different numbers of columns.

42601PostgreSQL

ERROR: syntax error at or near "x"

PostgreSQL couldn’t parse the SQL; the token shown is where parsing failed.

1066SQL

MySQL ERROR 1066 (42000): Not unique table/alias: 'x'

The same table or alias appears twice in a FROM/JOIN without distinct aliases.

aggregate in WHERESQL

ERROR: aggregate functions are not allowed in WHERE (use HAVING) / MySQL 1111 Invalid use of group function

An aggregate (SUM, COUNT, AVG) was used in WHERE, which filters rows before grouping.

Two steps away (15)

1064MySQL

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.

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).

Subquery returns more than 1 rowSQL

Subquery returns more than 1 row (MySQL 1242) / more than one row returned by a subquery used as an expression

A subquery used where a single value is expected (`= (SELECT …)`) returned several rows.

Division by zeroSQL

SQL Error: division by zero / Divide by zero error encountered

An expression divided by a value that was 0 for at least one row.

recursion limitSQL

Msg 530: The statement terminated. The maximum recursion 100 has been exhausted before statement completion. / MySQL 3636 Recursive query aborted after 1001 iterations

A recursive CTE exceeded the database’s recursion limit — often an infinite loop in hierarchical data.

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…

1267SQL

MySQL ERROR 1267 (HY000): Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_0900_ai_ci,IMPLICIT) for operation '='

Two strings with different collations were compared or joined.

ORA-00942SQL

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-00904SQL

ORA-00904: "X": invalid identifier

A column name in the statement doesn’t exist (or is misquoted).

ORA-00001SQL

ORA-00001: unique constraint (SCHEMA.PK_X) violated

An insert/update duplicated a value in a unique or primary key constraint.

2627SQL

SQL Server: Violation of PRIMARY KEY constraint 'x'. Cannot insert duplicate key in object 'y'. (Msg 2627)

An insert duplicated a primary key or unique constraint value.

245SQL

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.

8115SQL

SQL Server: Arithmetic overflow error converting expression to data type int. (Msg 8115)

A value or calculation exceeds the target data type’s range.

Map another error

Popular: 4035004000xC000007BTypeErrorCritical error404NullPointerException