Details
-
Bug
-
Resolution: Won't Fix
-
Medium
-
4.7.0-dev
-
None
-
Operating System: Internet Explorer 9.0.8112.16421
PHP Version: 5.3.3
Database and version: PostgreSQL (8.4.8)
Browser (and version): Firefox 11.0
Description
Hi,
In PostgreSQL, when creating a new event in a teamroom calendar, a fatal error is raised:
Warning: PHP: E_WARNING Apr 04 2012 15:43:48 pg_query(): Query failed: ERROR: invalid input syntax for integer: "" LINE 2: ... FROM ezevent WHERE contentobject_attribute_id='' AND ver... ^ in /var/www/ezp/.run/lib/ezdb/classes/ezpostgresqldb.php on line 211 Error: eZPostgreSQLDB Apr 04 2012 15:43:48 Error: error executing query: SELECT id, parent_event_id, contentobject_attribute_id, version, start_date, end_date, event_type, is_parent, is_temp FROM ezevent WHERE contentobject_attribute_id='' AND version='1': ERROR: invalid input syntax for integer: "" LINE 2: ... FROM ezevent WHERE contentobject_attribute_id='' AND ver... ^ Error: eZDBInterface::commit TRANSID-6eef32ad4d1dc4a0721c1dc79a6dae47 Apr 04 2012 15:43:48 Transaction in progress failed due to DB error, transaction was rollbacked. Transaction ID is TRANSID-6eef32ad4d1dc4a0721c1dc79a6dae47.
Steps to reproduce
Create a new teamroom Click on teh created teamroom Click on "Calendar" menu option Click on "Add a new event" button
The rrror happens when we click on the button referred in the last action.