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

ezteamroom : calendar doesn't work in postgresql

    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"
      

        Issue Links

          Activity

          Hide
          ezrobot added a comment -

          This issue has been automatically closed due to the lack of activity over a long period of time. It is very likely that it is obsolete, but if you think it is still valid, do not hesitate to reopen it and mention why.

          Show
          ezrobot added a comment - This issue has been automatically closed due to the lack of activity over a long period of time. It is very likely that it is obsolete, but if you think it is still valid, do not hesitate to reopen it and mention why.

            People

            • Assignee:
              unknown
              Reporter:
              Vidar Langseid
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated: