Alright, applying the changes from the commits of the hotfix above solved the issue.
So, to summarize, a solution to my issue was the following:
- Apply the fix from Fix Issue #6994: Update pollMonitoredInboxesAOP to double check that … by MikeyJC · Pull Request #9246 · salesagility/SuiteCRM · GitHub
This makes sure the issue will not re-appear after removing the duplicate records. - Delete the duplicate records from
folders_rel
. I only kept 3 actual records, corresponding to myinbound_email
mailboxes and deleted the rest. - [Optional] Run
OPTIMIZE TABLE inbound_email;
to free up the disk space
Now SuiteCRM is working again, and looks like no data has been lost.