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 username='user@domain.com';

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

https://docs.iredmail.org/upgrade.iredm … 0.9.9.html

https://docs.iredmail.org/upgrade.iredm … db-special

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'")



Re: after migration by updating tables to iredadmin pro getting error

You missed SQL structure change introduced in iRedMail-0.9.8:
https://docs.iredmail.org/upgrade.iredm … l-database


Does my reply help a little? How about buying me a cup of coffee ($5) as an encouragement?

buy me a cup of coffee