==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release): 9.9 MariaDB
- Deployed with iRedMail Easy or the downloadable installer: Probably downloadable version 9.7 or before
- Linux/BSD distribution name and version: CentOS Linux release 7.6.1810 (Core)
- 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.
====

Hello,

Recently upgraded an installation that I did not set up, from 9.7 to 9.8 to 9.9. Everything went great but there is one thing I have found that may indicate a larger problem.

On the iRedAdmin-Pro dashboard where it shows "Top Senders" and "Top Recipients" there are only a few records but the top is listed as address "<>"

See attachment.

I tracked this code back to the column "email_raw" in the amavisd.msgs table that doesn't exist in my database. I don't see this referenced anywhere in any update, I have checked *.mysql scripts linked to upgrade documentation and still I cannot find this.

I do, however, have "email_raw" in amavisd.maddr.

Is this a bug? If so I kind of find it hard to believe It's not easily searchable in this forum but you never know.

Let me know if you need any more information and thanks in advance for the help!