Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
I received this error while trying to send a sms trought rules:
PDOException: SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'status' at row 1: INSERT INTO {sms_track} (reference, dir, number, gw_number, message, status, created, options) VALUES ...
The errors happen because the "status" column in database was defined as "tiny int", I deleted "size" definition in this column leaving only "int", and worked.
Hope helps to someone.
Comments
Comment #2
almaudoh CreditAttribution: almaudoh commentedChanged the size definition in sms_track.install to
small
. That fixes this issue.For websites already deployed, do an alter column sql query to change the
status
column fromtinyint
tosmallint
. I will post a hook_update patch for this in a separate issue.Comment #3
almaudoh CreditAttribution: almaudoh commentedRaised #2295013: Upgrade path: 'status' column in sms_track table is too small with patch for the upgrade path.