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

Reply via email to