1 (edited by torsten 2018-01-07 22:05:53)

Topic: After update cannot add Contacts to personal adressbook

==== Required information ====
- iRedMail version (check /etc/iredmail-release): 0.9.7
- Linux/BSD distribution name and version: Linux version 2.6.32-042stab127.2
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Web server (Apache or Nginx): Apache
- Manage mail accounts with iRedAdmin-Pro? no
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====
Hello
after update i cannot add contacts to existing personal adressbooks.
on new created adressbooks (not the personal one ) i can add new contacts as well. On a new user account it works fine.
I didnt know if the problem exist bevor the update.
In the logfile it thems that an field is missing but how can i add this to an existing personal adressbook

thank you
torsten

Sogo.log

Jan 07 14:35:21 sogod [1243]: 80.133.162.80 "GET /SOGo/so/xxx/Contacts/personal/newguid HTTP/1.1" 200 56/0 0.002 - - 4K
Jan 07 14:35:30 sogod [1243]: <0x0x7f6c67be0330[GCSFolder]> ERROR(-[GCSFolder writeContent:fromComponent:container:toName:baseVersion:]): cannot insert content : <MySQL4Exception: 0x7f6c67be50c0> clumn 'c_hascertificate' in 'field list'

----

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

2

Re: After update cannot add Contacts to personal adressbook

torsten wrote:

ERROR(-[GCSFolder writeContent:fromComponent:container:toName:baseVersion:]): cannot insert content : <MySQL4Exception: 0x7f6c67be50c0> clumn 'c_hascertificate' in 'field list'

A new SQL column was introduced in SOGo nightly build, you have to run the scripts shipped in SOGo package to add them:
https://github.com/inverse-inc/sogo/blo … 0-mysql.sh