Topic: Upgrade SoGo 3.2 to 4 script Duplicate column name 'c_hascertificate'
==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version: upgrade from 0.9.7 to 0.9.8.
- Linux: debian 8
- Store mail accounts in: MySQL
- Web server: Nginx
====
Hi,
I follow upgrade guide :
https://docs.iredmail.org/upgrade.iredm … 0.9.8.html
https://docs.iredmail.org/upgrade.sogo.3.to.4.html
When I run the sogo upgrade script, I have :
# bash /usr/share/doc/sogo/sql-update-3.2.10_to_4.0.0-mysql.sh
Username (root):
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 1060 (42S21) at line 1: Duplicate column name 'c_hascertificate'
ERROR 1060 (42S21) at line 1: Duplicate column name 'c_hascertificate'
ERROR 1060 (42S21) at line 1: Duplicate column name 'c_hascertificate'# dpkg -l | grep sogo
ii sogo:amd64 4.0.5.20190213-1 amd64 a modern and scalable groupware
ii sogo-activesync 4.0.5.20190213-1 amd64 a modern and scalable groupware - ActiveSync moduleThe faulty table (tested SQL lines by lines)
mysql> ALTER TABLE sogogillesqu0123456789_quick ADD c_hascertificate INT4 DEFAULT 0;
ERROR 1060 (42S21): Duplicate column name 'c_hascertificate'
mysql> desc sogogillesqu0123456789_quick;
----
Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.