MySQL 1121: Out of range column value.

What is MySQL 1121: Out of range column value.

Identify the query causing the error. Check application logs or enable the MySQL general log temporarily to capture the problematic SQL statement:

SET global general_log = 1; SET global log_output = 'table'; After capturing the query, disable logging:SET global general_log = 0;

Examine the table schema for column definitions related to the error. Use the `DESCRIBE` command:

DESCRIBE yourtablename;

Identify the column mentioned in the error and check its data type limits (e.g., INT, VARCHAR). Compare these limits with the data you are trying to insert or update.

If the issue is due to an integer type limit (e.g., trying to insert a value larger than the maximum allowed for an INT), consider changing the column data type to a larger type (e.g., BIGINT) if data correctness allows:

ALTER TABLE yourtablename MODIFY yourcolumnname BIGINT;

For VARCHAR or similar types, ensure the data you're inserting does not exceed the column's defined length. If necessary and appropriate, adjust the column length:

ALTER TABLE yourtablename MODIFY yourcolumnname VARCHAR(new_length);

Re-run the problematic query to confirm the issue is resolved.

Optionally, if the error persists or you suspect data corruption, check the table for issues:

CHECK TABLE yourtablename;

If step 7 indicates table issues, attempt a table repair (back up the table first):

REPAIR TABLE yourtablename;