1 Topic by saquib.akhtar

  • saquib.akhtar
  • saquib.akhtar
  • Member
  • Offline
  • From: INDIA
  • Registered: 2018-02-20
  • Posts: 110

Topic: Updating to SOGO 4.0

==== Required information ====
- iRedMail version (check /etc/iredmail-release): 0.9.8
- Linux/BSD distribution name and version: CentOS 7.5
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): PGSQL
- Web server (Apache or Nginx): Nginx
- Manage mail accounts with iRedAdmin-Pro? yes, 2.4.9
====

I am upgrading to sogo 4.0 version and got this error after running script:

ERROR:  column "c_hascertificate" of relation "sogo_quick_contact" already exists


I followed this link : https://docs.iredmail.org/upgrade.sogo.3.to.4.html

----

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: 31,094

Re: Updating to SOGO 4.0

Did you upgrade from SOGo v3 or v2?
Before upgrading SOGo to v4, did you migrate SOGo SQL tables to the "9 tables" mode?
https://docs.iredmail.org/upgrade.sogo. … ables.html

3 Reply by saquib.akhtar

  • saquib.akhtar
  • saquib.akhtar
  • Member
  • Offline
  • From: INDIA
  • Registered: 2018-02-20
  • Posts: 110

Re: Updating to SOGO 4.0

I saw that already those parameters existed as in the link:
https://docs.iredmail.org/upgrade.sogo. … ables.html

So running it gave me an error.

4 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,094

Re: Updating to SOGO 4.0

saquib.akhtar wrote:

So running it gave me an error.

What error?

5 Reply by saquib.akhtar

  • saquib.akhtar
  • saquib.akhtar
  • Member
  • Offline
  • From: INDIA
  • Registered: 2018-02-20
  • Posts: 110

Re: Updating to SOGO 4.0

It gave me an error of trying to delete some column of table .
But after that I restarted memcached and sogo both.

6 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,094

Re: Updating to SOGO 4.0

Show us the original and related error log please.

7 Reply by r.crellin

  • r.crellin
  • Member
  • Offline
  • Registered: 2017-02-11
  • Posts: 16

Re: Updating to SOGO 4.0

Hi I'm having same error as above I'm updating from v2 to v4 I have also don't the 9 tables instruction and came up with same error message. Wondering if anyone can help on this issue. We get the error when upgrading from v3 to v4 by the way. if you need any supporting error logs please let me know here I can get this info from for you. Thanks

8 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,094

Re: Updating to SOGO 4.0

r.crellin wrote:

I'm having same error as above I'm updating from v2 to v4

Which tutorials did you follow? What's the error message in SOGo log file?