[horde] More Apple iCal woes...

[Ryan Steele]

Hey folks,

I've found the "fly in the ointment".  On the Mac running iCal, if I
download testacct's iCalendar file by plugging in the URL to it in
Firefox and importing the events into iCal, I then have the ability to
publish new events to Kronolith.  I'm curious as to why that initial
import of the iCalendar data needs to be done in iCal before I can
publish to Kronolith?  Is this a bug? Figured I'd ask before filing -
Jan, Mike?

Thanks,
Ryan

Ryan Steele wrote:
> 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
>