I assume I want to use the following when running postgresql: ./usr/share/doc/sogo-1.3.7a/sql-update-1.3.3_to_1.3.4.sh
Regards, John John Marsetta Senior Support Engineer New England Organ Bank 60 First Avenue Waltham, MA 02451 (w)617-558-6623 (c)617-595-6754 (f)617-244-8755 [cid:image001.jpg@01CC4ACA.401F63F0] Sign up to be an organ donor @: https://secure.rmv.state.ma.us/OrganDonor/intro.aspx From: Ludovic Marcotte [mailto:lmarco...@inverse.ca] Sent: Thursday, July 21, 2011 4:31 PM To: users@sogo.nu Subject: Re: [SOGo] Calendar items not getting saved On 21/07/11 16:02, John Marsetta wrote: Jul 21 15:59:10 sogod [5677]: [ERROR] <0x0xb054cd0[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 sogojmarsett00110d38fdd_quick a, sogojmarsett00110d38fdd b WHERE ((c_component = 'vevent') AND ((c_startdate IS NULL) OR (c_startdate <= 1311825599)) AND ((c_enddate IS NULL) OR (c_enddate >= 1311220800)) AND (c_iscycle = 0)) AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL)': <PostgreSQL72Exception: 0xbb8ad28> NAME:PostgreSQL72FatalError REASON:fatal pgsql error (channel=<0x0xbf93798[PostgreSQL72Channel]: connection=<0x0xbbc6228[PGConnection]: connection=0x0xb00a708>>): ERROR: column a.c_category does not exist Run the update scripts. -- Ludovic Marcotte lmarco...@inverse.ca<mailto:lmarco...@inverse.ca> :: +1.514.755.3630 :: www.inverse.ca<http://www.inverse.ca> Inverse inc. :: Leaders behind SOGo (www.sogo.nu<http://www.sogo.nu>) and PacketFence (www.packetfence.org<http://www.packetfence.org>) ________________________________ This email message and any files transmitted with it contain confidential information intended only for the person(s) to whom this email message is addressed. If you have received this email message in error, please notify the sender immediately by telephone or email and destroy the original message without printing or making a copy.
<<inline: image001.jpg>>