I did the upgrade from 2.2.13 straight to v3, but calendar was not working. Items were not saved and I was getting errors in syslog:
Nov 05 15:26:31 sogod [2667]: [ERROR] <0x0x7fed3d279280[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_compo nent,a.c_title,a.c_location,a.c_orgmail,a.c_status,a.c_category,a.c_classifi cation,a.c_isallday,a.c_isopaque,a.c_participants,a.c_partmails,a.c_partstat es,a.c_sequence,a.c_priority,a.c_cycleinfo,a.c_iscycle,a.c_nextalarm,a.c_des cription,a.c_uid,a.c_startdate,a.c_enddate FROM sogomatimuru0017e447e43_quick a, sogomatimuru0017e447e43 b WHERE ((c_component = 'vevent') AND ((c_startdate IS NULL) OR (c_startdate <= 1478901599)) AND ((c_enddate IS NULL) OR (c_enddate >= 1478296800)) AND (c_iscycle = 0)) AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL)': <MySQL4Exception: 0x7fed3d363ad0> NAME:ExecutionFailed REASON:Unknown column 'a.c_description' in 'field list' Nov 05 15:26:31 sogod [2667]: [ERROR] <0x0x7fed3d279280[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_compo nent,a.c_title,a.c_location,a.c_orgmail,a.c_status,a.c_category,a.c_classifi cation,a.c_isallday,a.c_isopaque,a.c_participants,a.c_partmails,a.c_partstat es,a.c_sequence,a.c_priority,a.c_cycleinfo,a.c_iscycle,a.c_nextalarm,a.c_des cription,a.c_uid,a.c_startdate,a.c_enddate FROM sogomatimuru0017e447e43_quick a, sogomatimuru0017e447e43 b WHERE ((c_component = 'vevent') AND ((c_startdate IS NULL) OR (c_startdate <= 1478901599)) AND ((c_cycleenddate IS NULL) OR (c_cycleenddate >= 1478296800)) AND (c_iscycle = 1)) AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL)': <MySQL4Exception: 0x7fed3d437060> NAME:ExecutionFailed REASON:Unknown column 'a.c_description' in 'field list' Nov 05 15:26:31 sogod [2667]: [ERROR] <0x7fed3d7153c0[SOGoAppointmentFolder]:personal> (-[SOGoAppointmentFolder fetchFields:from:to:title:component:additionalFilters:includeProtectedInform ation:]): fetch failed! Nov 05 15:26:31 sogod [2666]: [ERROR] <0x0x7fed3d3b6380[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_compo nent,a.c_title,a.c_location,a.c_orgmail,a.c_status,a.c_category,a.c_classifi cation,a.c_isallday,a.c_isopaque,a.c_participants,a.c_partmails,a.c_partstat es,a.c_sequence,a.c_priority,a.c_cycleinfo,a.c_iscycle,a.c_nextalarm,a.c_des cription,a.c_uid,a.c_startdate,a.c_enddate FROM sogomatimuru0017e447e43_quick a, sogomatimuru0017e447e43 b WHERE ((c_component = 'vevent') AND ((c_startdate IS NULL) OR (c_startdate <= 1478383199)) AND ((c_enddate IS NULL) OR (c_enddate >= 1477774800)) AND (c_iscycle = 0)) AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL)': <MySQL4Exception: 0x7fed3d1f17a0> NAME:ExecutionFailed REASON:Unknown column 'a.c_description' in 'field list' Nov 05 15:26:31 sogod [2667]: 90.191.98.156 "GET /SOGo/so/mati.muru/Calendar/eventslist?asc=1&day=20161105&filterpopup=view_n ext7&search=title_Category_Location&sort=start&value= HTTP/1.1" 200 439/0 0.014 - - 0 Nov 05 15:26:31 sogod [2666]: [ERROR] <0x0x7fed3d3b6380[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_compo nent,a.c_title,a.c_location,a.c_orgmail,a.c_status,a.c_category,a.c_classifi cation,a.c_isallday,a.c_isopaque,a.c_participants,a.c_partmails,a.c_partstat es,a.c_sequence,a.c_priority,a.c_cycleinfo,a.c_iscycle,a.c_nextalarm,a.c_des cription,a.c_uid,a.c_startdate,a.c_enddate FROM sogomatimuru0017e447e43_quick a, sogomatimuru0017e447e43 b WHERE ((c_component = 'vevent') AND ((c_startdate IS NULL) OR (c_startdate <= 1478383199)) AND ((c_cycleenddate IS NULL) OR (c_cycleenddate >= 1477774800)) AND (c_iscycle = 1)) AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL)': <MySQL4Exception: 0x7fed3d42aa00> NAME:ExecutionFailed REASON:Unknown column 'a.c_description' in 'field list' Nov 05 15:26:31 sogod [2666]: [ERROR] <0x7fed3d6369d0[SOGoAppointmentFolder]:personal> (-[SOGoAppointmentFolder fetchFields:from:to:title:component:additionalFilters:includeProtectedInform ation:]): fetch failed! Nov 05 15:26:31 sogod [2666]: 90.191.98.156 "GET /SOGo/so/mati.muru/Calendar/eventsblocks?ed=20161105&sd=20161030&view=weekvi ew HTTP/1.1" 200 787/0 0.008 - - 0 Tervitades / Best regards, Raido Rinaldi vanemtehnik Mob. 510 2834 [email protected] Kuvarnet OÜ | +372 747 5542 | Riia 181C III korrus, Tartu 51014 skype: arvutihooldus | www.kuvarnet.ee | ithooldus.net -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Christian Mack Sent: Friday, November 4, 2016 3:19 PM To: [email protected] Subject: Re: [SOGo] Sogo change "from address" from GUI Hello Am 04.11.2016 um 12:07 schrieb "Raido Rinaldi" ([email protected]): > > So to get this feature, I have to upgrade sogo to at least 2.3.17 version? > Is this fix included in sogo v3? > It depends:-) If you just want to use an email address, which the user has not in his account, then you need only a version, which supports changing it. We have used this with earlier versions than 2.3.17 (sorry, don't remember, when exactly we enabled it). Only if you want to be able to set one of the email addresses of the user too, then you need 2.3.17. On the V3 demo site from Inverse this function is not available. Not sure, if it is not implemented or just disabled though. I did not yet test this function in V3 myself. BTW: Since SOGo 2.0.5 you should have switched to using sogo.conf instead of GNUstepDefaults. I once had problems with another setting before changing this. Especially using sogo-tool will not work without sogo.conf. Therefore you should switching first. A HowTo is included in the documentation in chapter "10. Upgrading". If you still can not change this setting, then upgrade. Kind regards, Christian Mack PS: I would upgrade anyway, as 2.3.17 provides a lot of additional functions and fixes a lot of bugs. > -----Original Message----- > From: [email protected] [mailto:[email protected]] On Behalf Of > Christian Mack > Sent: Friday, November 4, 2016 1:06 PM > To: [email protected] > Subject: Re: [SOGo] Sogo change "from address" from GUI > > Am 04.11.2016 um 11:39 schrieb Christian Mack > ([email protected]): >> Hello >> >> Am 02.11.2016 um 10:52 schrieb "Raido Rinaldi" ([email protected]): >>> >>> I want option that users can edit their email address from Sogo web -> >>> preferences -> Imap accounts. I am running SOGo 2.2.13 and my >>> GNUstepdefaults config contains: >>> >>> # more /var/lib/sogo/GNUstep/Defaults/.GNUstepDefaults >>> >>> <key>SOGoMailCustomFromEnabled</key> >>> >>> <string>YES</string> >>> >>> <key>SOGoUserSources</key> >>> >>> <array> >>> >>> <dict> >>> >>> But the option in webmail is still greyed out: >>> >>> >>> What am I missing? >>> >> >> I am not sure, 2.2.13 already had that functionality or not. >> But the field always looks greyed out. >> Can you edit the field after restarting sogod and memcached? >> >> There was a fix recently, which prevented setting email addresses which >> belonged to the user already. >> This will be part of the next version if I remember correctly. >> > > Have to correct myself :-) > That fix is already in 2.3.17 > -- Christian Mack Universität Konstanz Kommunikations-, Informations-, Medienzentrum (KIM) Abteilung Basisdienste 78457 Konstanz +49 7531 88-4416 -- [email protected] https://inverse.ca/sogo/lists
