[Tickets #1034] NEW: creation of new event fails on SQL error

[bugs at bugs.horde.org]

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

Ticket URL: http://bugs.horde.org/ticket/?id=1034
-----------------------------------------------------------------------
 Ticket     | 1034
 Created By | imp at mavetju.org
 Summary    | creation of new event fails on SQL error
 Queue      | Kronolith
 Version    | 2.0
 State      | Unconfirmed
 Priority   | 2. Medium
 Type       | Bug
 Owners     | 
-----------------------------------------------------------------------


imp at mavetju.org (2004-12-30 04:01) wrote:

When trying to add a new event (Organizing -> Calendar -> New Event), it
fails because of a bad SQL statement with regarding to the event_end
statements:

SELECT event_id, event_uid, event_description, event_location, event_s
tatus, event_attendees, event_keywords, event_title, event_category, event_
recurtype, event_recurenddate, event_recurinterval, event_recurdays, event_
start, event_end, event_alarm, event_modified, event_exceptions, event_crea
tor_id FROM kronolith_events WHERE calendar_id = 'edwin' AND ((event_end > 
'-001-11-27 00:00:00' AND event_start < '2004-01-02 00:00:00') OR (event_re
curenddate >= '-001-11-27 00:00:00' AND event_start <= '2004-01-02 00:00:00
' AND event_recurtype != 0)).

Invalid input syntax for type timestamp: "-001-11-27 00:00:00"

(this error is shown in the log of the database server, it doesn't show up
in Kronolith itself)

This is with a PostgreSQL database backend.

If you need more information please let me know.