Hi, did You run the DB-update script (sql-update-2.2.17_to_2.3.0). I think You need that even when going to v3.
Regards Uwe Arndt --- | Wiss. Leiter RZ/GHRKO | [email protected] | Universitaet Koblenz | T: +49 261 287 1310 | Universitaetsstr.1 56070 KO | F: +49 261 287 100 1310 Am 07.11.2016 um 08:13 schrieb "Raido Rinaldi" ([email protected]): > 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 >> > > -- [email protected] https://inverse.ca/sogo/lists
