1 Topic by akash.modh (edited by akash.modh 2021-11-21 03:25:34)

  • akash.modh
  • Member
  • Offline
  • Registered: 2021-11-21
  • Posts: 2

Topic: InternalError(1054, "Unknown column 'enablesogoactivesync' in 'field l

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

Hello - After upgrading iredmail-pro MySQL version 4.9. I am getting InternalError(1054, "Unknown column 'enablesogoactivesync' in 'field list') while doing ip whitelist in advance features

----

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

2 Reply by Cthulhu

  • Cthulhu
  • Member
  • Offline
  • Registered: 2019-06-04
  • Posts: 907

Re: InternalError(1054, "Unknown column 'enablesogoactivesync' in 'field l

you missed some upgrade steps then, its related to changed database structure in the sql tables

3 Reply by ZhangHuangbin

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

Re: InternalError(1054, "Unknown column 'enablesogoactivesync' in 'field l

akash.modh wrote:

Hello - After upgrading iredmail-pro MySQL version 4.9. I am getting InternalError(1054, "Unknown column 'enablesogoactivesync' in 'field list') while doing ip whitelist in advance features

This sql column (and 2 more) is introduced in iRedMail-1.4.1, please upgrade your iRedMail server to the latest iRedMail-1.4.2 by following below 2 upgrade tutorials:

https://docs.iredmail.org/upgrade.iredm … 1.4.1.html
https://docs.iredmail.org/upgrade.iredm … 1.4.2.html