1 Topic by vypotol (edited by vypotol 2018-07-06 00:53:08)

  • vypotol
  • Member
  • Offline
  • Registered: 2018-07-06
  • Posts: 1

Topic: iRedAdmin update fails with error when adding new user

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- 0.8.6 iRedMail version
- Ubuntu 14.04 
- MySQL
- Apache
- Error - Error: (1054, "Unknown column 'domain.settings' in 'group statement'")
====

iRedAdmin version 0.3 was upgraded to 0.9.1 with tools/upgrade_iredadmin.sh
There were no errors during installation and I could login to the newly installed version after apache restart.

Now when I go to Add Users dropdown, the following error is shown.
Error: (1054, "Unknown column 'domain.settings' in 'group statement'")

I am guessing certain columns are missing in vmail's domain table. I took vmail db backup before doing the update but I am not sure if the tools/upgrade_iredadmin.sh script adds/changes any mysql tables or not.

I understand there have been several releases and directly jumping to 0.9.1 could be causing this. If that is the case, would I need to roll through all the major releases?

Any pointers will be highly appreciated.

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 ZhangHuangbin

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

Re: iRedAdmin update fails with error when adding new user

You must follow iRedMail upgrade tutorials to upgrade iRedMail from 0.8.6 to the latest iRedMail-0.9.8 first, then upgrade iRedAdmin (from any old release to the latest):
https://docs.iredmail.org/iredmail.releases.html

3 Reply by KsenZ

  • KsenZ
  • Member
  • Offline
  • Registered: 2017-01-20
  • Posts: 8

Re: iRedAdmin update fails with error when adding new user

ZhangHuangbin wrote:

You must follow iRedMail upgrade tutorials to upgrade iRedMail from 0.8.6 to the latest iRedMail-0.9.8 first, then upgrade iRedAdmin (from any old release to the latest):
https://docs.iredmail.org/iredmail.releases.html

I upgrade iRedMail and iRedMail, to the latest version. But the error remained.

4 Reply by ZhangHuangbin

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

Re: iRedAdmin update fails with error when adding new user

KsenZ wrote:

I upgrade iRedMail and iRedMail, to the latest version. But the error remained.

What's the error message you got?
Which iRedMail release were you running?

5 Reply by KsenZ

  • KsenZ
  • Member
  • Offline
  • Registered: 2017-01-20
  • Posts: 8

Re: iRedAdmin update fails with error when adding new user

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- 0.9.9 iRedMail version
- CentOS 7
- MySQL
- Nginx
- Error - Error: (1054, "Unknown column 'domain.settings' in 'group statement'")
====

6 Reply by ZhangHuangbin

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

Re: iRedAdmin update fails with error when adding new user

KsenZ wrote:

- Error - Error: (1054, "Unknown column 'domain.settings' in 'group statement'")

SQL column "domain.settings" was introduced in iRedMail-0.8.7:
https://docs.iredmail.org/upgrade.iredm … l-database