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

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

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

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