1 Topic by orlovnv

  • orlovnv
  • Member
  • Offline
  • Registered: 2018-01-16
  • Posts: 7

Topic: Sogo contacts error

==== Required information ====
- iRedMail version (check /etc/iredmail-release):
- Linux/BSD distribution name and version:
- Store mail accounts in which backend (LDAP/MySQL/PGSQL):
- Web server (Apache or Nginx):
- Manage mail accounts with iRedAdmin-Pro?
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
======== Required information ====
- iRedMail version (check /etc/iredmail-release):
- Linux/BSD distribution name and version:
- Store mail accounts in which backend (LDAP/MySQL/PGSQL):
- Web server (Apache or Nginx):
- Manage mail accounts with iRedAdmin-Pro?
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====version 0.9.6
debian 8
Mysql
Apache
No pro

can not add new contact, or import to a new user and doesn't work exchange of contacts with android device

Post's attachments

sogo.log 1.37 mb, 1 downloads since 2018-01-16 

Снимок экрана 2018-01-16 в 19.52.11.png 266.54 kb, file has never been downloaded. 

You don't have the permssions to download the attachments of this post.

----

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

2 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,770

Re: Sogo contacts error

Discussed in another thread:
https://forum.iredmail.org/post60752.html#p60752

Also in SOGo mailing list:
https://www.mail-archive.com/users@sogo … 27143.html

3 Reply by orlovnv

  • orlovnv
  • Member
  • Offline
  • Registered: 2018-01-16
  • Posts: 7

Re: Sogo contacts error

root@mediateka:/usr/share/doc/sogo# ./sql-update-3.2.10_to_4.0.0-mysql.sh
Username (root): sogo
Hostname (127.0.0.1):
Database (sogo):
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:
ERROR 1146 (42S02) at line 1: Table 'sogo.sogoanisimov0021b7e4498_quick' doesn't exist
root@mediateka:/usr/share/doc/sogo#

4 Reply by iredmailtnt

  • iredmailtnt
  • Member
  • Offline
  • Registered: 2016-02-10
  • Posts: 52

Re: Sogo contacts error

orlovnv wrote:

root@mediateka:/usr/share/doc/sogo# ./sql-update-3.2.10_to_4.0.0-mysql.sh
Username (root): sogo
Hostname (127.0.0.1):
Database (sogo):
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:
ERROR 1146 (42S02) at line 1: Table 'sogo.sogoanisimov0021b7e4498_quick' doesn't exist
root@mediateka:/usr/share/doc/sogo#

I too am getting this same type of error with 0.9.7 on Centos 7 and mariadb.

5 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,770

Re: Sogo contacts error

Was column 'c_hascertificate' created?

Please report this issue to SOGo bug tracker:
https://sogo.nu/bugs/

Or mailing list:
https://sogo.nu/support/index.html#/community

6 Reply by orlovnv

  • orlovnv
  • Member
  • Offline
  • Registered: 2018-01-16
  • Posts: 7

Re: Sogo contacts error

how to check it?

7 Reply by jonaspariente

  • jonaspariente
  • Member
  • Offline
  • Registered: 2018-01-30
  • Posts: 1

Re: Sogo contacts error

Same error here on debian 9 and mariadb.
It has nothing to do with iredmail, it's on sogo's part only.

Error detail :
- On contact creation, I found in sogo.log :
ERROR(-[GCSFolder writeContent:fromComponent:container:toName:baseVersion:]): cannot insert content : <MySQL4Exception: 0x55796f63f370> NAME:ExecutionFailed REASON:Unknown column 'c_hascertificate' in 'field list'
- then sql-update-3.2.10_to_4.0.0-mysql.sh complains about "_quick" table not existing.

I don't know if something is missing in sql-update-3.2.10_to_4.0.0-mysql.sh but I had to manually add c_hascertificate column (with type : int and null allowed) on sogo_quick_contact table in sogo database.

Then I ran again sql-update-3.2.10_to_4.0.0-mysql.sh without any error.

Finally, I created a contact with success (and syncing with thunderbird is working well too).

Hope this help.

8 Reply by Almotzo

  • Almotzo
  • Member
  • Offline
  • Registered: 2013-02-18
  • Posts: 25

Re: Sogo contacts error

ERROR 1146 (42S02) at line 1: Table 'sogo.sogoanisimov0021b7e4498_quick' doesn't exist

Same Error, what are the SQL Code for fixing that ?

Debian 9, MariaDB