[horde] More Apple iCal woes...

[Ryan Steele]

Hey folks,

I thought I had this working previously, but maybe I was wrong.  I'm
working with RC1 for the framework and Kronolith.  When I go to publish
a calendar with iCal to Horde, I get "500 - Internal Server Error".  It
works just fine from Sunbird/Lightning.  I checked the logs and found this:

Jan 27 14:47:02 HORDE [debug] [kronolith] Kronolith_Driver_sql::listEventsConditional(): user = "testacct"; 
query = "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 = ? AND ((event_end > ? AND event_start < ?) OR
(event_recurenddate >= ? AND event_start <= ? AND event_recurtype <> ?))"; values = "testacct,0000-01-01 
00:00:00,9999-12-28 00:00:00,0000-01-01 00:00:00,9999-12-28 00:00:00,0" [on line 302 of "/path/to/kronolith/lib/Driver/sql.php"]

Jan 27 14:47:02 HORDE [error] [horde] No iCalendar data was found. [on line 147 of "/path/to/horde/lib/Horde/RPC/webdav.php"]

However, if I just manually run:

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="testacct";

...it returns testacct's calendar just fine.

I checked the URL that iCal is sending, and it looks like this:
http://testacct@my.domain.com/rpc.php/kronolith/testacct.ics.  I tested
that out in Firefox, and it loads without any problem.  I've also
verified the password
and permissions on the calendar as correct, so now I'm a bit confused by
what's going on here - can anyone shed light on the situation?  Thanks.

Best Regards,
Ryan