MyMail Issue: Cannot delete messages

[Omnirock]

I've been trying to delete the backlog of messages in MyMail, and have been encountering problems when doing so.

I've tried using the Clear All command and it's giving the following message: " All Messages Cleared. You have cleared all messages from your inbox. If you need to recover these, please contact a system administrator for more information. "

Yet is still showing all my messages in the inbox.

When I select messages and use the Clear Selected options, sometimes a few of them will delete, other times they will not.

The only consistent is that the messages that remain regardless, are the ones from prior to being reinstated. i.e. messages before March 26th(?)

[SyMP2005]

I think messages have to be read before being able to delete, also a refresh is required before it's visible.

[Omnirock]

I've tried that, there's a mix of read and unread messages that will not get cleared.

I think the best solution would be to create a test account if one does not exist already, have them set to RETIRED, send them some MyMail, reinstate the account and see if the bug is reproduced, then work on a solution from there.

[jonpas]

There are way too many test accounts we have. We are setting up an empty database to be used for local testing as well, so either someone does it on live or we do it when that's setup.

Thanks for the reproduction steps!

[codethirteen]

Been meaning to bring this one up, so I'm glad someone submitted it. I already looked at the code last week, because I have 300+ MyMails and when you change unit you are given all the backlog of them too. So part of the problem is the initial SQL query is simply calling all unread messages in your unit. Which is probably worth disabling to start with. I'll take a look later today.