MariaDB error: "Data truncated for column" when column is mediumint and value fits

Check if the used value is not a string. In case of a string MySQL converts the value silently to mediumint, but MariaDB does something else which causes this error.