Thanks a lot for your help with this. It is now fixed although I am still a little surprised to find this being added without announcement (?) or I am searching for documentation in the wrong areas.
Thanks again. On 09/01/18 00:40, "MicTieMix" (mictie...@gmail.com) wrote: > Had the same issue a couple of days ago... > > It seems that a new column 'c_hascertificate' was added to the > SoGo-mysql-database around Dec 25th. > > I was able to resolve this issue by manually adding a column > 'c_hascertificate' (as INT) to the relevant database. > > Hope it helps! > > > -----Original Message----- > From: users-requ...@sogo.nu [mailto:users-requ...@sogo.nu] On Behalf Of > Michael Doerner | Technologywise > Sent: Monday, 8 January 2018 04:56 > To: users@sogo.nu > Subject: [SOGo] Unknown column 'c_hascertificate' in 'field list' > > Hi all > > I have just updated our SOGo to the very latest SOGo nightly build (for > CentOS6), 3.2.10.20180107, hoping to fix a problem that must have started > recently but I am unsure when exactly. > > When trying to look at the address book in the SOGo web interface (tested > with various users), the screen will show you the total amount of contacts > but underneath, where the list of contacts should be seen, it looks like it > is trying to refresh but not been able to show any entry. > > The SOGo log shows the following: > > Jan 08 09:47:03 sogod [3637]: [ERROR] <0x0x7fa98f65f468[GCSFolder]> > -[GCSFolder fetchFields:fetchSpecification:ignoreDeleted:]: cannot execute > quick-fetch SQL 'SELECT c_name, c_cn, c_givenname, c_sn, c_screenname, c_o, > c_mail, c_telephonenumber, c_categories, c_component, c_hascertificate FROM > ..... (cut)... > ExecutionFailed REASON:Unknown column 'c_hascertificate' in 'field list' > > We have not in any way tried to do something manually with the MySQL database > so I wonder what might be the reason for this? > > Any idea or help? > > Thanks, Michael > -- > users@sogo.nu > https://inverse.ca/sogo/lists > -- users@sogo.nu https://inverse.ca/sogo/lists
