1 Topic by gilles.quenot (edited by gilles.quenot 2018-03-27 04:37:13)

  • gilles.quenot
  • Member
  • Offline
  • Registered: 2016-12-05
  • Posts: 61

Topic: [SOLVED] contacts : Unknown column 'c_hascertificate' in 'field list

- iRedMail version 0.9.5-1
- Linux/BSD distribution name and version: debian 8.10
- Store mail accounts in which backend : MySQL
- Web server Nginx
- Manage mail accounts with iRedAdmin-Pro? no
====

Hi,

I can't get any contact visible in the proper SoGo page, but I can export contacts as well.


I get this error in /var/log/sogo/sogo.log

Mar 26 16:16:05 sogod [10112]: [ERROR] <0x0x7f667825db80[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 sogogillesqu003686d9622_quick WHERE ... 
<MySQL4Exception: 0x55a03fc3e040> NAME:ExecutionFailed REASON:Unknown column 'c_hascertificate' in 'field list'

Regards

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2 Reply by gilles.quenot

  • gilles.quenot
  • Member
  • Offline
  • Registered: 2016-12-05
  • Posts: 61

Re: [SOLVED] contacts : Unknown column 'c_hascertificate' in 'field list

Fixed by running /usr/share/doc/sogo/sql-update-3.2.10_to_4.0.0-mysql.sh

Found via:

grep -rl c_hascertificate /usr/share/doc/sogo