Topic: SOGO is not showing mailbox after restoring

- iRedMail version (check /etc/iredmail-release): 1.5.2
- Deployed with iRedMail Easy or the downloadable installer?Downloadable Installer
- Linux/BSD distribution name and version: Debia 11
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- 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.
We have upgraded our os from debian 10 to 11 and installed iredmail 1.5.2 and upgraded to  iRedAdmin-Pro-SQL-5.1. After we restore our vmail and sogo db from old backup to the new iredadmin, sogo is not showing the mailbox . We tried to update the settings for sogo from admin panel for users and it gives the  below error
Error: InternalError(1054, "Unknown column 'enablesogoactivesync' in 'field list'").

Any help would be appreciated.


Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team.


Re: SOGO is not showing mailbox after restoring

when you restore an old database which has a different database structure, you need to run the database update script afterwards

since it is related to enablesogoactivesync, i guess this is the correct one:

https://docs.iredmail.org/upgrade.iredm … 1.4.2.html
-> https://raw.githubusercontent.com/iredm … mail.mysql

since the column is unknown, you aswell need to use the script which added it.

you need to know which release you had when you made a backup and then update one by one to the newest to get it to work