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: [email protected] [mailto:[email protected]] On Behalf Of Michael Doerner | Technologywise Sent: Monday, 8 January 2018 04:56 To: [email protected] 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 -- [email protected] https://inverse.ca/sogo/lists -- [email protected] https://inverse.ca/sogo/lists
