[kronolith] Calendar and PostgreSQL (?)

[Morten Schmidt]

Sorry for the fuss...

I figured it out, and now I'm going to do a thing everybody that reports 
problems should learn to do if they resolve it: TELL PEOPLE ABOUT IT ;o)

I figured out that in my administration setting I hadn't created a DataTree 
for Horde...

I did this:
Administration -> Setup -> [TAB] DataTree System

In there it said: 
* What backend should we use for Horde DataTree storage?    None

I changed it to: SQL Database, called the table horde_datatree (which was 
already in the db) and viola!!!

Thank you all anyways...

/morten

On Sunday 31 July 2005 13:45, Morten Schmidt wrote:
> 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

-- 
Powered by Debian GNU/Linux & PalmOS5