Numeric value out of range: 1264 Out of range value for column 'status' [#2282309]

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 #1

30 June 2014 at 10:58

almaudoh committed 596d19f on 7.x-1.x

Issue #2282309 by almaudoh | tilon: Fixed Numeric value out of range:...

Comment #2

almaudoh CreditAttribution: almaudoh commented 30 June 2014 at 11:18

Status:

Active

» Fixed

Changed 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 from tinyint to smallint. I will post a hook_update patch for this in a separate issue.