27 Dec 2018
When inserting a record, I was trying to insert the value 2403919011 to a field with type INT and length of 11. On insert it would insert the value 2147483647 instead.
The issue was with field type of INT, the maximum integer value in hold is 2147483647, since the number I was inserting was larger it would default to the maximum number allowed.
SOLUTION: In your MySQL table, change the field type to BIGINT.
ALTER TABLE `name` MODIFY COLUMN `field_name` bigint(20) NOT NULL DEFAULT 0