Hi,
same issue here. I found the change in the GIT log
https://github.com/inverse-inc/sogo/commit/f66278131267ecc67363e303a8edabf5f2d780fb#diff-f7d02c1fd40d613920753ef1dc49b3c3L36
Plus a script which included the changes
root@localhost:/usr/share/doc/sogo# grep c_hascertificate *
sql-update-3.2.10_to_4.0.0-mysql.sh:# 3- add the c_hascertificate column
to contact quick table
sql-update-3.2.10_to_4.0.0-mysql.sh: part="`echo -e \"ALTER TABLE
$table ADD c_hascertificate INT4 DEFAULT 0;\\n\"`";
sql-update-3.2.10_to_4.0.0.sh:# 2- add the c_hascertificate column to
contact quick table
sql-update-3.2.10_to_4.0.0.sh: part="`echo -e \"ALTER TABLE $table
ADD c_hascertificate INT4 DEFAULT 0;\\n\"`";
root@localhost:/usr/share/doc/sogo#
root@localhost:/usr/share/doc/sogo# ./sql-update-3.2.10_to_4.0.0-mysql.sh
Username (root): XXXXX
Hostname (127.0.0.1):
Database (sogo): XXXXX
This script will ask for the database password twice
Converting c_content from TEXT to LONGTEXT in the sogo_user_profile table
Converting c_mail from VARCHAR(255) to TEXT in Contacts quick tables
Enter password:
Enter password:
root@localhost:/usr/share/doc/sogo#
Though I as well did not find a trace of an announcement. Or did I miss
something?
BR
Frank
-------- Original-Message --------
Subject: Re: [SOGo] Unknown column 'c_hascertificate' in 'field list'
From: Michael Doerner | Technologywise" (Michael) <users@sogo.nu>
To: Users <users@sogo.nu>
CC:
Date: Dienstag, 9. Januar 2018 10:12:28 (GMT +0100)
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
