Apologies for a long post. Also, [email protected] seems to be the new place to post sogo messages as my messages to [email protected] do not appear.
I use SOGo for the school email system but wanted to expand use of the calendar. Unfortunately it seems to have broken, probably since the 1.33 upgrade. I get errors in the sogo log (placed below this message). When I upgraded, I ran a database upgrade script that came with the upgrade. Mail and address books all seem fine for all users. I added a field into my sogobrianloc00117296d89 table of the datatype varchar(10) called c_category and this seemed to make the problem go away. New calendars do not show the error. Consequently, I could export my calendars, delete the calendar and reimport. However I do have a large number of users and before I go mucking about with the database I wanted some advice or suggestions as to where I might have gone wrong on doing the upgrade. Error from log below this line. ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 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 -- [email protected] https://inverse.ca/sogo/lists
