1 Topic by va

  • va
  • Member
  • Offline
  • Registered: 2019-02-20
  • Posts: 4

Topic: Upgrade iRedMail 1.4.1 - mysql error

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release): 1.4.1
- Deployed with iRedMail Easy or the downloadable installer? Deployed with installer
- Linux/BSD distribution name and version: Ubuntu 18.04
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL Ver 14.14 Distrib 5.7.35
- Web server (Apache or Nginx): Nginx
- Manage mail accounts with iRedAdmin-Pro? yes
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====

Hi,

Error with following command while doing iRedMail migration to 1.4.1:

mysql vmail < /tmp/iredmail.mysql
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF NOT EXISTS `enablesogowebmail` CHAR(1) NOT NULL DEFAULT 'y'' at line 1

Seems that syntax has to be modified for this MySQL version

Could you help pls?
Thanks

----

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

2 Reply by Robbos (edited by Robbos 2021-09-11 23:55:52)

  • Robbos
  • Member
  • Offline
  • Registered: 2018-08-27
  • Posts: 1

Re: Upgrade iRedMail 1.4.1 - mysql error

Hello All,
  The next part of the upgrade process that upgraded the sogo database did not work either and caused an issue which required me to reload last nights backup to get sogo working again. These commands.

wget -O /tmp/sogo.mysql https://github.com/iredmail/iRedMail/ra … sogo.mysql
mysql sogo < /tmp/sogo.mysql
rm -f /tmp/sogo.mysql

  I am using an older install that i have upgraded a number of times so maybe the mysql database is a little different to a fresh install?? Just a thought.

  I am assuming this is from this feature...

https://github.com/iredmail/iRedMail/issues/124

Thanks.

3 Reply by ZhangHuangbin

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

Re: Upgrade iRedMail 1.4.1 - mysql error

Please redownload this file and apply again:
https://raw.githubusercontent.com/iredm … mail.mysql

4 Reply by va

  • va
  • Member
  • Offline
  • Registered: 2019-02-20
  • Posts: 4

Re: Upgrade iRedMail 1.4.1 - mysql error

I applied your fix and it worked!

Thanks ZH