[kronolith] Calendar and PostgreSQL (?)

[Morten Schmidt]

I havn't been able to see anyone solving this issue, so I'll just try asking 
here....

I have Horde3 and Kronolith2 configured with a PostgreSQL databse on my Debian 
Sid. But the Calendar doesn't seem to be working with PostgreSQL.

This is what the log says when I click the "Calendar"

[SNIP]
Jul 31 13:38:49 HORDE [debug] [kronolith] Hook _horde_hook_share_init in 
application horde not called. [on line 1418 of 
"/usr/share/horde3/lib/Horde.php"]
Jul 31 13:38:50 HORDE [debug] [kronolith] SQL session setup by Administrator: 
query = "SET datestyle TO 'iso'" [on line 530 of 
"/usr/share/horde3/kronolith/lib/Driver/sql.php"]
Jul 31 13:38:50 HORDE [debug] [kronolith] SQL event list by Administrator: 
query = "SELECT event_id, event_uid, event_description, event_location, 
event_status, 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_creator_id FROM kronolith_events WHERE calendar_id = ? AND ((event_end 
> ? AND event_start < ?) OR (event_recurenddate >= ? AND event_start <= ? AND 
event_recurtype <> ?))" [on line 200 of 
"/usr/share/horde3/kronolith/lib/Driver/sql.php"]
[SNAP]

and this, when I hit "New Event":

[SNIP]
Jul 31 13:40:30 HORDE [debug] [kronolith] Hook _horde_hook_share_init in 
application horde not called. [on line 1418 of 
"/usr/share/horde3/lib/Horde.php"]
Jul 31 13:40:31 HORDE [debug] [kronolith] Hook _horde_hook_share_init in 
application horde not called. [on line 1418 of 
"/usr/share/horde3/lib/Horde.php"]
Jul 31 13:40:31 HORDE [debug] [kronolith] SQL session setup by Administrator: 
query = "SET datestyle TO 'iso'" [on line 530 of 
"/usr/share/horde3/kronolith/lib/Driver/sql.php"]
Jul 31 13:40:31 HORDE [debug] [kronolith] SQL event list by Administrator: 
query = "SELECT event_id, event_uid, event_description, event_location, 
event_status, 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_creator_id FROM kronolith_events WHERE calendar_id = ? AND ((event_end 
> ? AND event_start < ?) OR (event_recurenddate >= ? AND event_start <= ? AND 
event_recurtype <> ?))" [on line 200 of 
"/usr/share/horde3/kronolith/lib/Driver/sql.php"]
Jul 31 13:40:31 HORDE [error] [kronolith] DB Error: unknown error: SELECT 
event_id, event_uid, event_description, event_location, event_status, 
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_creator_id FROM kronolith_events WHERE calendar_id = 'Administrator' 
AND ((event_end > '-001-11-27 00:00:00' AND event_start < '2005-01-02 
00:00:00') OR (event_recurenddate >= '-001-11-27 00:00:00' AND event_start <= 
'2005-01-02 00:00:00' AND event_recurtype <> 0)) [nativecode=ERROR:  invalid 
input syntax for type timestamp: "-001-11-27 00:00:00"] [on line 205 of 
"/usr/share/horde3/kronolith/lib/Driver/sql.php"]
[SNAP]

What is wrong here?

Thank you in advance

/morten

-- 
Powered by Debian GNU/Linux & PalmOS5