Error map
1366 MySQL ERROR 1366: Incorrect string value: '\xF0\x9F\x98\x80' for column
MySQL · layer 5, Data
Centre: this error. First ring: errors it is linked with (6). 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 (6)
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.
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.
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 1366 (HY000): Incorrect integer value: '' for column 'x' at row 1
An empty string or non-numeric text was inserted into an INT column under strict mode.
MySQL ERROR 1273 (HY000): Unknown collation: 'utf8mb4_0900_ai_ci'
A dump from MySQL 8 uses a collation the target server (MySQL 5.7 / MariaDB) doesn’t support.
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.
Two steps away (17)
MySQL ERROR 1146 (42S02): Table 'db.table' doesn't exist
The query references a table that MySQL can’t find in that database.
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).
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.
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 1066 (42000): Not unique table/alias: 'x'
The same table or alias appears twice in a FROM/JOIN without distinct aliases.
MySQL ERROR 1062 (23000): Duplicate entry for key
An INSERT/UPDATE would create a duplicate value in a PRIMARY or UNIQUE key.
HTTP 422 Unprocessable Content
The request is well-formed, but the data fails validation (e.g. invalid email, missing required field).
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.
MySQL ERROR 1048 (23000): Column 'x' cannot be null
An INSERT/UPDATE put NULL into a NOT NULL column.
MySQL ERROR 1264 (22003): Out of range value for column 'x' at row 1
A number is too large (or negative for UNSIGNED) for the column type.
MySQL ERROR 1292 (22007): Incorrect datetime value: 'x' for column 'y'
A string couldn’t be converted to DATE/DATETIME — wrong format, empty string, or a zero date in strict mode.
TypeError: x is not a constructor
new was used with something that isn’t a class/constructor — usually a wrong import.
ReferenceError: Cannot access 'x' before initialization
A let/const/class was used before its declaration line ran (temporal dead zone) — often a circular import.
MySQL ERROR 1046 (3D000): No database selected
A query referenced tables without a database selected (no USE and no db in the connection).
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 1061 (42000): Duplicate key name 'x'
CREATE INDEX/ADD INDEX used an index name that already exists on the table.
Map another error
Popular: 500403400ORA-009331064Critical errorFileNotFoundException assemblyTypeError