[kronolith] Unable to display events on calendars.

[Lim Wai Kheong]

Hi,

    My Horde setup has some problems in displaying the events on the 
calendars. Basically I can create the events (checked from MySQL, they 
are there). However, I see nothing whenever I try to view them (from any 
calendars).

    After changing the logging level to 'PEAR_LOG_DEBUG', this is what I 
get from horde.log when I click the calendar link:

   SELECT DISTINCT event_id, event_description, event_location, 
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 = 
'e844ed72873fdb2d94163988619ec2c6' AND ((event_end > '2004-02-01 
00:00:00' AND event_start < '2004-03-01 00:00:00') OR 
(event_recurenddate >= '2004-02-01 00:00:00' AND event_start <= 
'2004-03-01 00:00:00' AND event_recurtype != 0))

   I cut and paste the query and run it in the SQL shell with no 
results. I browsed kronolith_events table and found that all 
'calendar_id's contains something like 'user at my.domain.name' instead of 
'e844ed72873fdb2d94163988619ec2c6'. Is there any hashing done in 
between? I am using IMP authentication so my user id is my email 
address. Also, prior to this, I didn't use DataTree for Horde Groups.

    Is there any thing that I done wrong when installing kronolith?

    Thanks.



regards,
Lim