Topic: after migration by updating tables to iredadmin pro getting error
I have migrated my data from old iredadmin 0.9.8 to 0.9.9 and done below steps mentioned on link:
1.copy all mailboxes (in Maildir format) to new iRedMail server with tools like rsync.
2.Set correct file owner and permission of mailboxes. Default owner is vmail, group is vmail, permission is 0700.
With SQL backends, you can get full maildir path of user with below SQL command:
mysql> USE vmail;
mysql> SELECT CONCAT(storagebasedirectory, '/', storagenode, '/', maildir) FROM mailbox WHERE firstname.lastname@example.org';
after that I have updated mysql structure suggested here :
Version Release Date Upgrade tutorial Comment
0.9.9 Dec 17, 2018 Upgrade from iRedMail-0.9.8 Contains SQL/LDAP structure change
but I am getting below error once I move vmail db to new iredadmin pro version and domains and migrated email ids not showing in domains and accounts option
Error: OperationalError(1054, "Unknown column 'maillists' in 'field list'")