1 Topic by k-hussein

  • k-hussein
  • Member
  • Offline
  • Registered: 2014-12-11
  • Posts: 106

Topic: Sent\Received mails display issue

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- 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
Capture.PNG 43.41 kb, 1 downloads since 2019-10-25 

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

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,088

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.

3 Reply by k-hussein

  • k-hussein
  • Member
  • Offline
  • Registered: 2014-12-11
  • Posts: 106

Re: Sent\Received mails display issue

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