Details
-
Bug
-
Resolution: Obsolete
-
High
-
4.3.0rc1
-
None
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: "" 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
Issue Links
- relates to
-
EZP-16547 EzTeamRoom: PostGres: Create new lightbox [Error] Transaction in progress failed due to DB error, transaction was rollbacked.
- Closed