Uploaded image for project: 'eZ Publish / Platform'
  1. eZ Publish / Platform
  2. EZP-19320

(tc-160) (Teamroom) Adding an event to a calendar raises a fatal error in Postgres

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Medium
    • Resolution: Won't Fix
    • Affects Version/s: 4.7.0-dev
    • Labels:
      None
    • Environment:

      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.

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            pcardiga Paulo Cardiga
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: