Re: email address added twice in data base

 
From: "Justin J" <justin@PROTECTED>
Date: December 8th 2009

When following next two steps, an email address will be added twice to the SQL subscribers data base: � Add an email address by means of the default subscriber screen The email address will be added to the data base with list_type = "sub_confirm_list" � Do not confirm the subscription, but add the same email address by means of the admin control panel: the email address will be added for the second time but now with list_type="list" Shouldn't the entry with list_type = "sub_confirm_list" be removed or overwritten when adding the email address by means of the admin panel? Or is this behaviour as intended?

No, I think that's a pretty good idea I think the problem is, say you have 1,000,000 subscribers you want to subscribe - do you want/need to try 1,000,000 times to see if any of those address are in the sub_confirm_list sublist, when you subscribe them? That's twice as many SQL queries

I think its easy enough to do, I think it's not done, for performance reasons

Moreover when I click on the confimation link in the email after the email address is added by the admin, the second email address is still present with list_type = "sub_confirm_list" in the data base

I guess, if we want, that's a good place to remove that extra entry, but I don't really know if it's totally mission critical

  • 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:

https://dadamailproject.com/d

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.