On 04/19/2013 11:17 PM, Thomas Bruederli wrote:
No, there shouldn't be any duplicates of username + mail_host values. But please look closely if there are differences in upper/lower case within these two columns. Depending on your IMAP server's capabilities and settings, you should consider to adjust the $rcmail_config['login_lc'] option which influences this.
The duplicates were true duplicates. Many of them had a created and last_login that were identical as well. I have deleted all of these ones if there was another record with a more recent last_login.
I then looked at each of the duplicates and deleted in most cases all but the one with the most recent activity. In a couple of cases there were preferences on an older one so I kept that instead. Whole exercise took a while but we don't have a lot of webmail users.
I am not sure but I think they may have come about using the squirrelmail_usercopy plugin when people have got their password wrong. We haven't supported squirrelmail for quite sometime so I have removed that plugin and will keep an eye on things.