24 Jan 2011 21:17
Re calendar afrer upgrade
Sorry this post is not in line. My previous post seems not to have appeared
In the sogo logs when I post an event I get messages like
Jan 24 18:50:39 sogod [15291]: [ERROR] <0x0xaa479f8[GCSFolder]> -[GCSFolder fetchFields:
fetchSpecification:ignoreDeleted:]: cannot execute quick-fetch SQL 'SELECT b.c_name,b.c_content,b.c_creationdate,b.c_lastmodified,b.c_version,a.c_component,a.c_title,a.c_location,a.c_orgmail,a.c_status,a.c_category,a.c_classification,a.c_isallday,a.c_isopaque,a.c_participants,a.c_partmails,a.c_partstates,a.c_sequence,a.c_priority,a.c_cycleinfo,a.c_iscycle,a.c_nextalarm,a.c_uid,a.c_startdate,a.c_enddate
FROM sogobrianloc00117296d89_quick a, sogobrianloc00117296d89 b WHERE
((c_component = 'vevent') AND (c_iscycle = 1)) AND a.c_name = b.c_name
AND (c_deleted != 1 OR c_deleted IS NULL)': <PostgreSQL72Exception:
0x9464da0> NAME:PostgreSQL72FatalError REASON:fatal pgsql error
(channel=<0x0xac78c40[PostgreSQL72Channel]: connection=<0x0x943c1a0[PGConnection]: connection=0x0xaa8efd8>>): ERROR: column a.c_category does not exist
Jan 24 18:50:39 sogod [15291]: [ERROR] <0x0AA24B08[SOGoAppointmentFolder]:personal> (-[SOGoAppointmentFolder fetchFields:from:to:title:component:additionalFilters:includeProtectedInformation:]): fetch failed!
172.16.32.243 - - [24/Jan/2011:18:50:39 GMT] "POST /SOGo/so/brianlockwood/Calendar/eventsblocks?sd=20110123&ed=20110129&view=weekview HTTP/1.1" 200 64/0 0.014 - - 0
Jan 24 18:50:39 sogod [15291]: [ERROR] <0x0AA24B08[SOGoAppointmentFolder]:personal> (-[SOGoAppointmentFolder fetchFields:from:to:title:component:additionalFilters:includeProtectedInformation:]): fetch failed!
172.16.32.243 - - [24/Jan/2011:18:50:39 GMT] "POST /SOGo/so/brianlockwood/Calendar/eventsblocks?sd=20110123&ed=20110129&view=weekview HTTP/1.1" 200 64/0 0.014 - - 0
The event is actually in the database though
BEGIN:VCALENDAR VERSION:2.0 PRODID:-//Inverse inc./SOGo 1.0//EN BEGIN:VEVENT UID:3BC4-4D3DCB80-39-441DDF00 SUMMARY:Test LOCATION:home CREATED:20110124T185659Z DTSTAMP:20110124T185659Z LAST-MODIFIED:20110124T185659Z BEGIN:VALARM TRIGGER;X-WEBSTATUS=triggered;VALUE=DURATION:-PT15M ACTION:DISPLAY END:VALARM DTSTART;TZID=/inverse.ca/20101018_1/Europe/London:20110124T190000 DTEND;TZID=/inverse.ca/20101018_1/Europe/London:20110124T200000 TRANSP:OPAQUE END:VEVENT BEGIN:VTIMEZONE TZID:/inverse.ca/20101018_1/Europe/London X-LIC-LOCATION:Europe/London BEGIN:DAYLIGHT TZOFFSETFROM:+0000 TZOFFSETTO:+0100 TZNAME:BST DTSTART:19700329T010000 RRULE:FREQ=YEARLY;BYMONTH=3;BYDAY=-1SU END:DAYLIGHT BEGIN:STANDARD TZOFFSETFROM:+0100 TZOFFSETTO:+0000 TZNAME:GMT DTSTART:19701025T020000 RRULE:FREQ=YEARLY;BYMONTH=10;BYDAY=-1SU END:STANDARD END:VTIMEZONE END:VCALENDAR
RSS Feed