Error map

1292 MySQL ERROR 1292 (22007): Incorrect datetime value: 'x' for column 'y'

MySQL · layer 5, Data

Open the full error page →

Centre: this error. First ring: errors it is linked with (9). 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.

1292 — MySQL ERROR 1292 (22007): Incorrect datetime value: 'x' for column 'y' (MySQL)1292invalid_type — API Error: Invalid type — expected integer, received string (API)invalid_typeinvalid_date — API Error: Invalid date format — expected ISO 8601 (YYYY-MM-DDTHH:mm:ssZ) (API)invalid_dateDateTimeParseException — java.time.format.DateTimeParseException: Text '31/12/2024' could not be parsed at index 2 (Java)DateTimeParseExcept…invalid time value — RangeError: Invalid time value (JavaScript)invalid time value1690 — MySQL ERROR 1690 (22003): BIGINT UNSIGNED value is out of range (MySQL)169022008 — ERROR: date/time field value out of range: "31/12/2024" — HINT: Perhaps you need a different "datestyle" setting. (PostgreSQL)22008Unparseable date — java.text.ParseException: Unparseable date: "x" (Java)Unparseable date1366 — MySQL ERROR 1366 (HY000): Incorrect integer value: '' for column 'x' at row 1 (MySQL)13661264 — MySQL ERROR 1264 (22003): Out of range value for column 'x' at row 1 (MySQL)1264400 — HTTP 400 Bad Request (HTTP)400422 — HTTP 422 Unprocessable Content (HTTP)4221406 — MySQL ERROR 1406: Data too long for column (MySQL)1406NumberFormatException — java.lang.NumberFormatException: For input string: "x" (Java)NumberFormatExcepti…IllegalArgumentException — java.lang.IllegalArgumentException (Java)IllegalArgumentExce…MethodArgumentNotValidException — MethodArgumentNotValidException: Validation failed for argument [0] (Java)MethodArgumentNotVa…InputMismatchException — java.util.InputMismatchException (Scanner) (Java)InputMismatchExcept…ValueError — ValueError: invalid literal for int() with base 10: 'abc' (Python)ValueErrorInput string was not in a correct format — System.FormatException: Input string was not in a correct format (.NET)Input string was no…ArithmeticException — java.lang.ArithmeticException: / by zero (Java)ArithmeticException22P02 — ERROR: invalid input syntax for type integer: "abc" (PostgreSQL)22P0242804 — ERROR: column "x" is of type integer but expression is of type text — HINT: You will need to rewrite or cast the expression. (PostgreSQL)4280422P02 uuid — ERROR: invalid input syntax for type uuid: "x" (PostgreSQL)22P02 uuid22001 — ERROR: value too long for type character varying(255) (PostgreSQL)2200122003 — ERROR: numeric field overflow — A field with precision 5, scale 2 must round to an absolute value less than 10^3 (PostgreSQL)220031366 — MySQL ERROR 1366: Incorrect string value: '\xF0\x9F\x98\x80' for column (MySQL)13661048 — MySQL ERROR 1048 (23000): Column 'x' cannot be null (MySQL)1048Pydantic ValidationError — pydantic_core._pydantic_core.ValidationError: 1 validation error for Model (Python)Pydantic Validation…invalid_value — API Error: Invalid parameter value — must be one of the allowed values / out of range (API)invalid_valueValidationException: Missing the key — DynamoDB ValidationException: One or more parameter values were invalid: Missing the key pk in the item / The provided key element does not match the schema (AWS)ValidationException…unknown field — strict decoding error: unknown field "spec.template.spec.containers[0].ports[0].protocl" (Kubernetes)unknown field

Directly related (9)

invalid_typeAPI

API Error: Invalid type — expected integer, received string

A request field has the wrong data type — a string where the API expects a number, a number where it expects a boolean, an object…

invalid_dateAPI

API Error: Invalid date format — expected ISO 8601 (YYYY-MM-DDTHH:mm:ssZ)

A date or timestamp in the request isn’t in the format the API expects — usually ISO 8601 with a time zone, or a Unix timestamp.

DateTimeParseExceptionJava

java.time.format.DateTimeParseException: Text '31/12/2024' could not be parsed at index 2

A java.time parse call got text that doesn’t match the expected format.

invalid time valueJavaScript

RangeError: Invalid time value

A Date is invalid (NaN), and toISOString() or a formatting library couldn’t format it.

1690MySQL

MySQL ERROR 1690 (22003): BIGINT UNSIGNED value is out of range

Arithmetic on UNSIGNED columns produced a negative result.

22008PostgreSQL

ERROR: date/time field value out of range: "31/12/2024" — HINT: Perhaps you need a different "datestyle" setting.

PostgreSQL parsed a date in the wrong order (DMY vs MDY) or got an impossible value.

Unparseable dateJava

java.text.ParseException: Unparseable date: "x"

SimpleDateFormat couldn’t parse the string with its pattern.

1366MySQL

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.

1264MySQL

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.

Two steps away (21)

400HTTP

HTTP 400 Bad Request

The server could not understand the request because its syntax, headers or body are malformed or invalid.

422HTTP

HTTP 422 Unprocessable Content

The request is well-formed, but the data fails validation (e.g. invalid email, missing required field).

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…

NumberFormatExceptionJava

java.lang.NumberFormatException: For input string: "x"

A string couldn’t be parsed as a number — it’s empty, has spaces/commas, is too large, or isn’t numeric.

IllegalArgumentExceptionJava

java.lang.IllegalArgumentException

A method rejected an argument value as invalid.

MethodArgumentNotValidExceptionJava

MethodArgumentNotValidException: Validation failed for argument [0]

Bean Validation (@Valid with @NotNull, @Email, @Size…) rejected the request body.

InputMismatchExceptionJava

java.util.InputMismatchException (Scanner)

Scanner.nextInt()/nextDouble() read a token that isn’t that type.

ValueErrorPython

ValueError: invalid literal for int() with base 10: 'abc'

int() received a string that isn’t a whole number — empty, decimal, whitespace or text.

Input string was not in a correct format.NET

System.FormatException: Input string was not in a correct format

int.Parse/decimal.Parse/Convert.ToInt32 got a string that isn’t a valid number — empty, contains text, or uses another culture’s…

ArithmeticExceptionJava

java.lang.ArithmeticException: / by zero

Integer division or modulo by zero.

22P02PostgreSQL

ERROR: invalid input syntax for type integer: "abc"

A string couldn’t be converted to the column’s type (integer, numeric, boolean, date…).

42804PostgreSQL

ERROR: column "x" is of type integer but expression is of type text — HINT: You will need to rewrite or cast the expression.

An INSERT/UPDATE supplies a value of a different type than the column, and PostgreSQL won’t cast implicitly.

22P02 uuidPostgreSQL

ERROR: invalid input syntax for type uuid: "x"

A value that isn’t a valid UUID was compared with or inserted into a uuid column.

22001PostgreSQL

ERROR: value too long for type character varying(255)

A string exceeds the column’s varchar length.

22003PostgreSQL

ERROR: numeric field overflow — A field with precision 5, scale 2 must round to an absolute value less than 10^3

A number doesn’t fit the column’s numeric(precision, scale) or integer range.

1366MySQL

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…

1048MySQL

MySQL ERROR 1048 (23000): Column 'x' cannot be null

An INSERT/UPDATE put NULL into a NOT NULL column.

Pydantic ValidationErrorPython

pydantic_core._pydantic_core.ValidationError: 1 validation error for Model

Data didn’t match a Pydantic model — a field is missing, has the wrong type, or fails a constraint.

invalid_valueAPI

API Error: Invalid parameter value — must be one of the allowed values / out of range

The field has the right type but a value the API doesn’t allow — not in the list of accepted options, too small or large, too lon…

ValidationException: Missing the keyAWS

DynamoDB ValidationException: One or more parameter values were invalid: Missing the key pk in the item / The provided key element does not match the schema

The item or key doesn’t match the table’s primary key schema — wrong attribute name, wrong type, or missing sort key.

unknown fieldKubernetes

strict decoding error: unknown field "spec.template.spec.containers[0].ports[0].protocl"

The manifest contains a field the API schema doesn’t know — a typo, wrong indentation, or a field from another API version.