On Jan 25, 2011, at 6:28 AM, Brian Lockwood wrote: > 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.
Yes, since May 2010 .. ;) > 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. > > 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 You didn't executed the update script (sql-update-1.3.3_to_1.3.4.sh). It adds the c_categories field for all the quick addressbook tables. Francis -- [email protected] :: +1.514.755.3640 :: http://www.inverse.ca Inverse :: Leaders behind SOGo (http://sogo.nu) and PacketFence (http://packetfence.org) -- [email protected] https://inverse.ca/sogo/lists
