[Tickets #8700] type cast needed for event_recurtype for postgresql-8.3.8

[bugs at horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/8700
------------------------------------------------------------------------------
  Ticket             | 8700
  Created By         | michael.menge at zdv.uni-tuebingen.de
  Summary            | type cast needed for event_recurtype for
                     | postgresql-8.3.8
  Queue              | Kronolith
  Version            | 2.3.2
  Type               | Bug
  State              | Unconfirmed
  Priority           | 1. Low
  Milestone          |
  Patch              |
  Owners             |
+New Attachment     | event_recurtype.patch
------------------------------------------------------------------------------


michael.menge at zdv.uni-tuebingen.de (2009-11-11 09:00) wrote:

Nov 11 13:58:41 HORDE [error] [kronolith] DB Error: unknown error:  
SELECT event_id, event_uid, event_description, event_location,  
event_private, event_status, event_attendees, event_keywords,  
event_title, event_category, event_recurcount, event_recurtype,  
event_recurenddate, event_recurinterval, event_recurdays, event_start,  
event_end, event_alarm, event_modified, event_exceptions,  
event_creator_id FROM kronolith_events WHERE calendar_id = 'xxxxx' AND  
((event_end > '2009-11-01 00:00:00' AND event_start < '2009-12-08  
00:00:00') OR (event_recurenddate >= '2009-11-01 00:00:00' AND  
event_start <= '2009-12-08 00:00:00' AND event_recurtype <> 0))  
[nativecode=ERROR:  operator does not exist: character varying <>  
integer bei Zeichen 578
TIP:  No operator matches the given name and argument type(s). You  
might need to add explicit type casts.] [pid 4590 on line 331 of  
"horde-3.3.5/kronolith-h3-2.3.2/lib/Driver/sql.php"]