[WebDNA] [sendmail] random duplicates

This WebDNA talk-list message is from

2010


It keeps the original formatting.
numero = 105285
interpreted = N
texte = This is a multi-part message in MIME format.--------------080708000009010802030605Content-Type: text/plain; charset=ISO-8859-1; format=flowedContent-Transfer-Encoding: 7bitI am experiencing an issue with emails being sent more than once. I am running the latest version of WebDNA on a newly installed Linux server with 2.27 dual quads, 8GB ram and 15K rpm drives. I am using an outside SMTP server and our ISP has recently upgraded us to a 25M up/down fiber connection. Thought I would list this info as maybe one of the upgrades could be contributing to the issue.I recently put a form on our site for customers to register for a contest that includes an option to subscribe to our email newsletter. The page that processes the form uses one [sendmail] to send an email confirming their entry into the contest and a 2nd and separate [sendemail] confirming their subscribing to our email newsletter if their email address in not already subscribed.During testing of the contest form, we noticed that a duplicate of one or both of the confirmation emails was being sent. The email log file only showed one email however it also indicated skipping a log number. Also, there was only one email in the SentEmail folder.My first attempt to correct this was to change the default number of ticks in the Email Settings to a higher number, 60. This now caused nearly five duplicates to be sent. So I then went the other direction and set the ticks to 5 which improved this issue but it didn't completely stop sending duplicates until I set the ticks way down to 3.Lowering the ticks to three appears to have stopped the double emails being sent from the contest form however lowering the ticks now appears to have caused a major issue when sending out our email newsletter to 23000 email addresses of which we sent out shortly after lowering the ticks. We immediately began to receive calls from customers informing us that they were receiving 25 copies of the newsletter email. I immediately went into the Mail Settings and set the ticks back to ten. My email address is towards the bottom of the file and I believe setting the ticks back to 10 fixed sending the bulk email as only one copy of the newsletter was sent to my email address. Unfortunately, I am now back to the contest form randomly sending duplicates. Note, I have been using WebDNA to send out our email newsletter to our list for the last several months without issue.I do break down the 23000 email addresses by building a temporary send database that copies the email addresses from the live master email database to a temporary send database that sets a group number value in each record of which I currently have set to be 30. The template that sends all the emails loops through a search finding all the records flagged with the current index loop group and inserts the found 30 email addresses into the BCC's of a single [sendmail] separated by commas. The "To" address does not exist, example list@xxxx.com and the "Reply To" address is our valid customer service email address.I've read through the TalkList and the best suggestion I found so far is to put a WAITFORFILE within the loop and have it wait for a file that doesn't exist and set the default wait time from 30 seconds to three minutes to put a pause between sending each group of 30 emails.It was also suggested to use a 3rd party source to manage our email list. I prefer to manage it in house. Sending out our newsletter has worked fine up until this last send.Any suggestions would be appreciated.Thanks,Steve--------------080708000009010802030605Content-Type: text/html; charset=ISO-8859-1Content-Transfer-Encoding: 7bitI am experiencing an issue with emails being sent more thanonce. I am running the latest version of WebDNA on a newly installedLinux server with 2.27 dual quads, 8GB ram and 15K rpm drives. I amusing an outside SMTP server and our ISP has recently upgraded us to a25M up/down fiber connection. Thought I would list this info as maybeone of the upgrades could be contributing to the issue.

I recently put a form on our site for customers to register for acontest that includes an option to subscribe to our email newsletter.The page that processes the form uses one [sendmail] to send an emailconfirming their entry into the contest and a 2nd and separate[sendemail] confirming their subscribing to our email newsletter iftheir email address in not already subscribed.

During testing of the contest form, we noticed that a duplicate of oneor both of the confirmation emails was being sent. The email log fileonly showed one email however it also indicated skipping a log number.Also, there was only one email in the SentEmail folder.

My first attempt to correct this was to change the default number ofticks in the Email Settings to a higher number, 60. This now causednearly five duplicates to be sent. So I then went the other directionand set the ticks to 5 which improved this issue but it didn'tcompletely stop sending duplicates until I set the ticks way down to 3.

Lowering the ticks to three appears to have stopped the double emailsbeing sent from the contest form however lowering the ticks now appearsto have caused a major issue when sending out our email newsletter to23000 email addresses of which we sent out shortly after lowering theticks. We immediately began to receive calls from customers informingus that they were receiving 25 copies of the newsletter email. Iimmediately went into the Mail Settings and set the ticks back to ten.My email address is towards the bottom of the file and I believesetting the ticks back to 10 fixed sending the bulk email as only onecopy of the newsletter was sent to my email address. Unfortunately, Iam now back to the contest form randomly sending duplicates. Note, Ihave been using WebDNA to send out our email newsletter to our list forthe last several months without issue.

I do break down the 23000 email addresses by building a temporary senddatabase that copies the email addresses from the live master emaildatabase to a temporary send database that sets a group number value ineach record of which I currently have set to be 30. Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] [sendmail] random duplicates (Donovan Brooke 2010)
  2. Re: [WebDNA] [sendmail] random duplicates (Steve Raslevich - Northern Sound 2010)
  3. Re: [WebDNA] [sendmail] random duplicates (Tom Duke 2010)
  4. Re: [WebDNA] [sendmail] random duplicates (Stuart Tremain 2010)
  5. Re: [WebDNA] [sendmail] random duplicates (Steve Raslevich - Northern Sound 2010)
  6. Re: [WebDNA] [sendmail] random duplicates (Tom Duke 2010)
  7. [WebDNA] [sendmail] random duplicates (Steve Raslevich - Northern Sound 2010)
This is a multi-part message in MIME format.--------------080708000009010802030605Content-Type: text/plain; charset=ISO-8859-1; format=flowedContent-Transfer-Encoding: 7bitI am experiencing an issue with emails being sent more than once. I am running the latest version of WebDNA on a newly installed Linux server with 2.27 dual quads, 8GB ram and 15K rpm drives. I am using an outside SMTP server and our ISP has recently upgraded us to a 25M up/down fiber connection. Thought I would list this info as maybe one of the upgrades could be contributing to the issue.I recently put a form on our site for customers to register for a contest that includes an option to subscribe to our email newsletter. The page that processes the form uses one [sendmail] to send an email confirming their entry into the contest and a 2nd and separate [sendemail] confirming their subscribing to our email newsletter if their email address in not already subscribed.During testing of the contest form, we noticed that a duplicate of one or both of the confirmation emails was being sent. The email log file only showed one email however it also indicated skipping a log number. Also, there was only one email in the SentEmail folder.My first attempt to correct this was to change the default number of ticks in the Email Settings to a higher number, 60. This now caused nearly five duplicates to be sent. So I then went the other direction and set the ticks to 5 which improved this issue but it didn't completely stop sending duplicates until I set the ticks way down to 3.Lowering the ticks to three appears to have stopped the double emails being sent from the contest form however lowering the ticks now appears to have caused a major issue when sending out our email newsletter to 23000 email addresses of which we sent out shortly after lowering the ticks. We immediately began to receive calls from customers informing us that they were receiving 25 copies of the newsletter email. I immediately went into the Mail Settings and set the ticks back to ten. My email address is towards the bottom of the file and I believe setting the ticks back to 10 fixed sending the bulk email as only one copy of the newsletter was sent to my email address. Unfortunately, I am now back to the contest form randomly sending duplicates. Note, I have been using WebDNA to send out our email newsletter to our list for the last several months without issue.I do break down the 23000 email addresses by building a temporary send database that copies the email addresses from the live master email database to a temporary send database that sets a group number value in each record of which I currently have set to be 30. The template that sends all the emails loops through a search finding all the records flagged with the current index loop group and inserts the found 30 email addresses into the BCC's of a single [sendmail] separated by commas. The "To" address does not exist, example list@xxxx.com and the "Reply To" address is our valid customer service email address.I've read through the TalkList and the best suggestion I found so far is to put a WAITFORFILE within the loop and have it wait for a file that doesn't exist and set the default wait time from 30 seconds to three minutes to put a pause between sending each group of 30 emails.It was also suggested to use a 3rd party source to manage our email list. I prefer to manage it in house. Sending out our newsletter has worked fine up until this last send.Any suggestions would be appreciated.Thanks,Steve--------------080708000009010802030605Content-Type: text/html; charset=ISO-8859-1Content-Transfer-Encoding: 7bitI am experiencing an issue with emails being sent more thanonce. I am running the latest version of WebDNA on a newly installedLinux server with 2.27 dual quads, 8GB ram and 15K rpm drives. I amusing an outside SMTP server and our ISP has recently upgraded us to a25M up/down fiber connection. Thought I would list this info as maybeone of the upgrades could be contributing to the issue.

I recently put a form on our site for customers to register for acontest that includes an option to subscribe to our email newsletter.The page that processes the form uses one [sendmail] to send an emailconfirming their entry into the contest and a 2nd and separate[sendemail] confirming their subscribing to our email newsletter iftheir email address in not already subscribed.

During testing of the contest form, we noticed that a duplicate of oneor both of the confirmation emails was being sent. The email log fileonly showed one email however it also indicated skipping a log number.Also, there was only one email in the SentEmail folder.

My first attempt to correct this was to change the default number ofticks in the Email Settings to a higher number, 60. This now causednearly five duplicates to be sent. So I then went the other directionand set the ticks to 5 which improved this issue but it didn'tcompletely stop sending duplicates until I set the ticks way down to 3.

Lowering the ticks to three appears to have stopped the double emailsbeing sent from the contest form however lowering the ticks now appearsto have caused a major issue when sending out our email newsletter to23000 email addresses of which we sent out shortly after lowering theticks. We immediately began to receive calls from customers informingus that they were receiving 25 copies of the newsletter email. Iimmediately went into the Mail Settings and set the ticks back to ten.My email address is towards the bottom of the file and I believesetting the ticks back to 10 fixed sending the bulk email as only onecopy of the newsletter was sent to my email address. Unfortunately, Iam now back to the contest form randomly sending duplicates. Note, Ihave been using WebDNA to send out our email newsletter to our list forthe last several months without issue.

I do break down the 23000 email addresses by building a temporary senddatabase that copies the email addresses from the live master emaildatabase to a temporary send database that sets a group number value ineach record of which I currently have set to be 30. Steve Raslevich - Northern Sound

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

auto enter dates (1998) Re:Emailer Set Up (1997) Re:no [search] with NT (1997) Obscure Question of the day (1997) [SearchString] problem with [search] context (1997) (OT) Dual 2GHz G5 (2003) String manipulation in Webcatalog (2001) X etc.... (1999) Multiple Stores and WebCatalog Prefs (1997) E-Mail (1998) Error -108 (1997) 2.1 Stuff (1998) Parameter Problem (1998) docs for WebCatalog2 (1997) WebCat2b15MacPlugin - showing [math] (1997) WebDNA + MLS (2006) Suffix or Line? (1999) WebCat2: Items xx to xx shown, etc. (1997) Harvesting invalid email addresses from bounced emails??? (2000) Multiple Carts with Mac IE (2002)