Details
-
Bug
-
Resolution: Obsolete
-
High
-
5.2-dev
-
Operating System: Debian7
PHP Version: 5.4.4
Database and version: PostgreSQL (9.1.9)
Browser (and version): Firefox 24
Description
Hi,
In PostgreSQL, if i create an object that has a string attribute, and in that attribute we register a string with 11 numbers, we have a fatal error.
To reproduce:
- Create a class with a string attribute
- Create an object of previous class, and in string attribute put the number 12345678901
- Save for publishing
When saving, we have the following error:
Fatal error: A database transaction in eZ Publish failed.
In debug, we have:
Error: eZPostgreSQLDB Oct 17 2013 12:04:01
Error: error executing query: 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 ( '994', '72', '0', '1', '0', '996', '16', '182', '1382004241', '1', 'string', '12345678901' ) : ERROR: value "12345678901" is out of range for type integer
LINE 15: ... '996', '16', '182', '1382004241', '1', 'string', '123456789...
^
Error: eZDBInterface::commit TRANSID-ae0223081bf3ccf80eff38b822493e9f Oct 17 2013 12:04:01
Transaction in progress failed due to DB error, transaction was rollbacked. Transaction ID is TRANSID-ae0223081bf3ccf80eff38b822493e9f.
Note1: This error do not happen if we use a string with 11 characters instead of only numbers
Note2: This error do not happen if we use a smaller string with less numbers (until 10 numbers)
Note3: This issue only happens on PostgreSQL. Do not happen on Mysql.
