Gossamer Forum
Home : Products : Gossamer Links : Version 1.x :

E-mailing Owners

Quote Reply
E-mailing Owners
The <%ID%> does not seem to be correct on mass mailing all the owners.

Suggestion?

Lance Rasmussen, Bowlingzone.com
Quote Reply
Re: E-mailing Owners In reply to
You need to be more specific.

Quote Reply
Re: E-mailing Owners In reply to
I sent a test message to only link ID#5 (myself) and the content of the message was only the <%ID%>. The e-mail content was 5.

I sent a broadcast e-mail to the owners with HTML for placing a vote for rating their site. In the Input tag, I used value="<%ID%>"

When I read the e-mail after sending out the mail to everyone, the value was 2, which is not correct.

Lance
Quote Reply
Re: E-mailing Owners In reply to
Who owned link 2?

I believe links will only send one message, to the first link of the owner. If the owner has more than one link, I don't think they get counted.

I could be wrong.

I've sent out many messages, and use the default configuration for this, and never had a problem. I have 3 or 4 ID's I added links with just to test that they all got a message.

Quote Reply
Re: E-mailing Owners In reply to
I am having the same problem. I don't know what's going on. I have thousands of link owners and I don't want to a targeted email because the ids always get messed up. Does anyone know why?

It's not because of duplicates i think. I tried sending myself an email and i got the wrong id.
Quote Reply
Re: E-mailing Owners In reply to
I don't get it.

Here is the code from the mailer:

Code:
if ($in->param('all')) {
$sth = $sub->prepare ("SELECT * FROM Links WHERE ReceiveMail = 'Yes'");
}
else {
$ids = join ",", $in->param('mail');
$ids or print "No users were selected!" and exit;
$sth = $sub->prepare ("SELECT * FROM Links WHERE ID IN ($ids) AND ReceiveMail = 'Yes'");
}
$sth->execute();
while ($link = $sth->fetchrow_hashref) {
($id, $name, $email) = ($link->{'ID'}, $link->{'Contact_Name'}, $link->{'Contact_Email'});

The values for the ID, $name and $email are taken from the same "link" so you can't get it mixed up.

Here's a subset of the mailing:

Code:
379 - Invalid email address: . Skipping.
380 - Message would have been sent to 'Ira@postcards.com'
381 - Already mailed to: 'Ira@postcards.com'!
382 - Already mailed to: 'Ira@postcards.com'!
383 - Invalid email address: . Skipping.
384 - Invalid email address: . Skipping.
385 - Invalid email address: . Skipping.
386 - Invalid email address: . Skipping.
387 - Invalid email address: . Skipping.
388 - Invalid email address: . Skipping.
389 - Already mailed to: 'Ira@postcards.com'!
390 - Already mailed to: 'Ira@postcards.com'!
391 - Already mailed to: 'Ira@postcards.com'!
392 - Already mailed to: 'Ira@postcards.com'!
393 - Already mailed to: 'Ira@postcards.com'!
394 - Message would have been sent to 'ira@postcards.com'
395 - Already mailed to: 'ira@postcards.com'!
396 - Already mailed to: 'ira@postcards.com'!
397 - Already mailed to: 'ira@postcards.com'!
398 - Already mailed to: 'Ira@postcards.com'!
399 - Already mailed to: 'Ira@postcards.com'!
400 - Already mailed to: 'Ira@postcards.com'!
401 - Already mailed to: 'Ira@postcards.com'!
402 - Already mailed to: 'Ira@postcards.com'!
403 - Already mailed to: 'Ira@postcards.com'!
404 - Already mailed to: 'Ira@postcards.com'!
405 - Already mailed to: 'Ira@postcards.com'!
406 - Already mailed to: 'Ira@postcards.com'!
407 - Already mailed to: 'Ira@postcards.com'!

In that case, the _only_ link he'd be notified of is the very first one - 380.

This should really be a bit smarter and put all the links for that person together, and send one letter with all the values, but it doesn't.

Note-- the case "Ira" and "ira" generate two different mailings.

To correct for that, everything should be lowercased before tallying the names.



Quote Reply
Re: E-mailing Owners In reply to
If it _used_ to work, then something you did affected it.

Have you tried to make it do something "extra" such that it's now off??

Also, what version of the program are you using? I know Alex has given different people different versions, and before trying to track a bug that only exists in your copy.... Smile

This sounds like it _could_ be due to a change in the database routines, and if so, I'd have no way to check it since my last version is 1.11 stable.

Quote Reply
Re: E-mailing Owners In reply to
While it may not make sense, it is what is happening.

I just recieved the following e-mail reply from my mailing...

>I have listed ID of "491" and has always been that.
>Which number is correct, '491' or '426'
>
>To: mcba@mc.net


I looked at #491. The following info for that ID is...

Title: Bowl-NJ
URL: http://www.bowl-nj.com
e-mail: ginni@bowl-nj.com

I looked at #426. The following info for that ID is...

Title: McHenry County Bowling Association
URL: http://user.mc.net/~mcba/
e-mail: mcba@mc.net


I don't see where the script can get confused by duplicates there.

Is the ID variable getting overwritten somehow before e-mailing but after showing the result of it being e-mailed with the correct ID#? Or vice-versa?

Lance

Quote Reply
Re: E-mailing Owners In reply to
That's a good question. Alex just put it up last week, so I don't know what exactly I have.

I have only made a couple mods, mostly regarding my mod for allowing NBSP, LT and GT in the template, and graphical ratings.

Nothing in this area.

Lance
Quote Reply
Re: E-mailing Owners In reply to
I have 1.11 stable and this problem is still happening to me. I don't know why. Maybe I should get alex's attention.
Quote Reply
Re: E-mailing Owners In reply to
Ok,

I'm pretty sure it's working for me, since I've sent out 3 or 4 such monthly mailings with no compliants about the wrong link.

Lance Rasmussen: maybe ask Alex if it's the stable release. I have not updated my copy of links since the original 1.11 release. I don't know if Alex has been installing copies with an updated set of .pm files or not.


charhua: I don't know why you'd be having this sort of problem. It might be something Alex should look at.

When I look at the code -- the email address and other information is all pulled from the same link, so I can't see where this error would be coming from.

I don't pretend to know all the internals of Links Smile Just the parts I've been able to play with.

Quote Reply
Re: E-mailing Owners In reply to
The only people who should have versions other then 1.11 are people who are using MS SQL Server on Windows NT (and there's only six of you out there Wink. Everyone else should be using the latest version 1.11.

If you are having problems, can you please email me a copy of the message someone got, plus a URL to your admin area?

Cheers,

Alex