Re: duplicated addresses (mysql backend)
On 9/11/07, Henry Hughes henry@PROTECTED wrote: >
Mariano,
The table that holds the email address can contain more than one list, that the same email address may be subscribed to: I know that (in fact, I do have a couple of lists that have subscribers in common)
> >
CREATE TABLE dada_subscribers ( email_id int4 not null primary key auto_increment, email text(320), list varchar(16), list_type varchar(64), list_status char(1) );
Therefore it is very possible that at first glance you could have duplicates, but check the 'list' field too, as this is the key that differentiates between one list and another Yeah, but this is not the case that is, it happened several times that I searched for an address (via the web mail cgi) and it appeared more than once and (also via the web mail cgi), if you select only one of those and hit "delete", it will erase both (since it does the sql DELETE based on 'email' and not on 'email_id', which is fine for me
>
SELECT DISTINCT(
list='LISTNAME'The above query should give you a list of unique addresses from your subscriber table Subsitute LISTNAME for your own Yes but that's the easy one I want to see which one of those are repeated well I think maybe a (very) dirty solution would be to issue that query and the same one without the 'DISTINCT' and 'diff' both results
>
Not tested or even ran the query myself though, as no access to a test dada host at present
Don't worry, thanx anyway
- 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.