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

ezteamroom : calendar doesn't work in postgresql

    XMLWordPrintable

Details

    Description

      Createing a calendar event in ezteamroom causes query error:

      Warning: PHP: E_WARNING  	Mar 26 2010 14:05:38
      
      pg_query() [<a href='function.pg-query'>function.pg-query</a>]: Query failed: ERROR:  invalid input syntax for integer: &quot;&quot;
      LINE 2: ... FROM   ezevent WHERE  contentobject_attribute_id='' AND ver...
                                                                   ^ in /var/www/apache2php52/ezppostgres/.run/lib/ezdb/classes/ezpostgresqldb.php on line 175
      
      Error: eZPostgreSQLDB 	Mar 26 2010 14:05:38
      
      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-6535b8f4a09171d72e4c7b5e853d7ce5 	Mar 26 2010 14:05:38
      
      Transaction in progress failed due to DB error, transaction was rollbacked. Transaction ID is TRANSID-6535b8f4a09171d72e4c7b5e853d7ce5.
      
      Steps to reproduce
      Setup
         1. Access the teamroom siteaccess of your eZ Publish installation
         2. Login as admin
         3. On the ezteamroom frontpage click on Create new teamroom
            Enter the information:
            Name: Teamroom 1
            Access: Private
            Feature list: Calendar
            Click on Create
        4.  Run frequent cronjob so that teamroom is created
      
      Verify that creating an event in a calendar in a teamroom works
         1. Go to Sitemap -> Calendar under "Teamroom 1"
         2. Click on the button Add new event
      

      When clicking the "Add new event" button, you get the error

      The remaining test case (blocked, not tested on postgres yet )

         3. Enter the information:
            Full title: Play squash
            Short title: Squash
            Description: In Oslo
            Date: Type=normal, select current date for both From and To dates by clicking on the calendar icon
            Location: Oslo
            Click on Store
         4. Verify that the event appears in the Calendar of "Teamroom 1"
      
      Verify that modifying an event in a calendar in a teamroom works
         1. Go to Sitemap -> Calendar under "Teamroom 1"
         2. Click on the button Edit event next to the event created earlier
         3. Enter the information:
            Full title: Play ping-pong
            Short title: Ping-pong
            Description: In Oslo
            Date: Type=weekly, select current date for Date, select hour:minutes for From and To, and a future date for "Period ends on" by clicking on the calendar icon
            Location: Oslo
            Click on Store
         4. Verify that the event appears updated in the Calendar of "Teamroom 1"
         5. Verify that the event appears weekly until the date specified in "Period ends on"
      
      Verify that deleting an event in a calendar in a teamroom works
         1. Go to Sitemap -> Calendar under "Teamroom 1"
         2. Click on the button Delete event next to the event created earlier
         3. Check Move to trash
         4. Click on Confirm
         5. Verify that the event doesn't appear anymore in the Calendar of "Teamroom 1"
      

      Attachments

        Activity

          People

            unknown unknown
            vl vl
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated: