Details
-
Bug
-
Resolution: Fixed
-
Medium
-
4.5.0, 4.6.0, 4.7.0, 5.0, 5.1, 5.2, 2014.11, dev-master
Description
Create a ContentType with Textline field type.
Enter a long integer value as content f.e. 3851071005 for this field.
Save content, a fatal error occurs:
Example SQL:
INSERT INTO
ezsearch_object_word_link
( word_id,
contentobject_id,
frequency,
placement,
next_word_id,
prev_word_id,
contentclass_id,
contentclass_attribute_id,
published,
section_id,
identifier,
integer_value )
VALUES ( '1800', '462', '0', '8', '1801', '1806', '4', '370', '1472056666', '2', 'zendesk_userid', '3851071005' );
Causes SQL error:
#1264 - Out of range value for column 'integer_value' at row 1
on integerValue generation the value needs to be verified against MySQL's max int value. A patch proposal which fixes this is attached.