Topic: Sent\Received mails display issue

- iRedMail version (check /etc/iredmail-release):  0.9.9
- Deployed with iRedMail Easy or the downloadable installer? downloadbale
- Linux/BSD distribution name and version: Ubuntu 14.04 LTS
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): LDAP
- 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.
after updating to iRedAdmin 4.1 LDAP I got a strange issue in the display of sent and received messages, check the below snip:

Post's attachments

Capture.PNG 43.41 kb, 1 downloads since 2019-10-25 

You don't have the permssions to download the attachments of this post.


Re: Sent\Received mails display issue

Seems a bug of iRedAdmin-Pro. It uses column "maddr.email_raw" as sender/recipient addresses, but if the SQL records exists before you adding SQL column "maddr.email_raw" (introduced in iRedMail-0.9.8), this column will not have a value.

The solution is removing all records in 4 tables and let Amavisd re-create them:

- quarantine
- msgrcpt
- msgs
- maddr

Please manage the quarantined mails with iRedAdmin-Pro first, either release or delete them, then remove sql records in above 4 tables.

I will try to fix this in next release of iRedAdmin-Pro, use "maddr.email" if "maddr.email_raw" is empty.


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

buy me a cup of coffee


Re: Sent\Received mails display issue

great, it worked after clearing the mentioned tables.
Thank you.