Re: duplicated addresses (mysql backend)
On Sep 11, 2007, at 8:56 AM, Mariano Absatz wrote:
Well FWIW, I did the checks manually (diff'ing the output of 'SELECT' vs 'SELECT DISTINCT') and it turned out that most duplicates had to do with addresses which had uppercase characters it seems older versions of dada allowed this, so that, if I got 'El Baby@gmail com' in the database and then tried to insert 'el baby@gmail com' I'd succeed ('cause now the verification process is always done in lowercase)
For quite some time, the behavior has been to lowercase the entire
email address, before inserting it into the table (via Dada Mail)
If
you inserted the address another way, all bets are off
Like anything, there may be a bug in Dada Mail that circumvents this
- if anyone can find it, lemme know
Also, the behavior can be modified via the $EMAIL_CASE Config
pm
variable
From the docs:
[snip] $EMAIL_CASE configures dada to either lowercase ONLY the 'domain' part of an email, or lowercase the entire email address Lowercasing the domain is the correct way, since the 'name' part of an email should be case sensitive, but it is almost never handled that way Set this to 'lc_domain' to lowercase JUST the domain, or set this to 'lc_all' to lowercase the entire email address [/snip]
The RFC states the the name part of the email address is case
sensitive, but this is rarely the case in real life
- This mailing list is a public mailing list - anyone may join or leave, at any time.
- This mailing list is a group discussion list (unmoderated)
-
Start a new thread, email: dadadev@dadamailproject.com
This is the developer discussion mailing list for Dada Mail.
If you are just looking for support Dada Mail, consult the message boards at:
https://forum.dadamailproject.com
Documentation for Dada Mail:
Specifically, see the Error FAQ:
https://dadamailproject.com/d/FAQ-errors.pod.html
To post to this list, send a message to:
mailto:dadadev@dadamailproject.com
All subscribers of this list may post to the list itself.
Topics that are welcome:
- Constructive critiques on the program (I like, "x", but, "y" needs some work - here's an idea on how to make this better...)
- Bug/Error reports
- Bug fixes
- Request For Comments on any changes to the program
- Help customizing Dada Mail for your own needs
- Patches
- Language Translations
- Support Documentation/Doc editing, FAQ's, etc.
- Discussion of any changes that you would like to be committed to the next version of Dada Mail -
Dada Mail is on Github:
https://github.com/justingit/dada-mail/
If you would like to fork, branch, send over PRs, open up issues, etc.
Privacy Policy:
This Privacy Policy is for this mailing list, and this mailing list only.
Email addresses collection through this mailing list are used explicitly to work within this email discussion list.
We only collect email addresses through our Closed-Loop Opt-In system.
We don't use your email address for any other purpose.
We won't be sharing your email address with any other entity.
Unsubscription can be done at any time. Please contact us at: justin@dadamailproject.com for any help regarding your subscription, including removal from the mailing list.
All mailing list messages sent from us will include a subscription removal link, which will allow you to remove yourself from this mailing list automatically, and permanently.
All consent to use your email address for any other purpose stated at the time of the mailing list subscription will also be revoked upon mailing list removal.