Duplicate e-mails sent to users

[zews]

I have a problem with users getting spammed with 18 e-mails that looks the same when they have an comment added to their ad, or if they subscribe to a category, and someone uploads a new ad. I am not able to verify this bug myself, but I tend to get 2 emails. A lot of users report this 18 emails problem, so I am wondering if this can be a software (PPC) problem, a cron job problem, a mail server problem or configuration problem.

The problems started when I moved to a Ubuntu server, and both PPC and vBulletin are updated with latest version.

Any help would be greatly appreciated!

[Chuck S]

well anytime someone adds a comment an email should go out.

Anytime someone posts an ad an email should go out

If they dont want to subscribe to things then they can visit their profiles and remove any subscriptions.

[zews]

Yes, but the server are sending them 18 emails each time. 18 emails that are all the same, instead of just one.

[Chuck S]

Well you need to document what action is being performed here but as I can see we send one. Why would there be 18? If so an ad is being placed in a category someone has a subscription to then we send an email

The way I see it the only way that user is going to get 18 of the same emails is if they are subscribed to a category 18 TIMES. So as unrealistic as that seems is that the case. try running a query like this to see replacing the cat number and userid with your scenerio

SELECT * FROM cp_notify WHERE product=500 AND userid=14 AND type=1

[wolven]

Hi Chuck,
I've got the same prob here. Some users receive up to 13 mails and they haven't even subscribed to any cat (following your select from above), some of them are Mods in all categories.
Any ideas?

[Chuck S]

They have to be subscribed thats a given because we only send emails to users in the NOTIFY table. Now only idea I would have is by change maybe some old issue how many entries in the notify table for any said user they have multiple entries in that table for a category or product?

[zews]

I still have this problem. Let me try to explain one more time.

A user with 0 subscription uploads a new ad, and then gets 19 emails like this:

XXX has uploaded one or more ads to a category you subscribe to.

Image name:
Title: test
Description: test

Link to ad: xxx/showproduct.php?product=9923

To turn off subscriptions for this category, click on the following link:

xxx/misc.php?action=subscribe&sub=4

The xxx Team

19 identical emails. The email log shows it has sent 19 emails to that user the same second. This user has no subsriptions.

So uploading a new ad makes the script send out 19 subsription emails to the user who uploaded.

I have tried to uninstall sendmail and installed exim as the mail program, but the problem is still the same.

[Chuck S]

Check in image-inc.php make sure it is as this in bold

Content visible to verified customers only.

[wolven]

Hi Chuck,

nope, I find this:

Content visible to verified customers only.

I've changed it according to your advice and will see how it works.

Regards wolven

[Chuck S]

It should

[zews]

Originally Posted by wolven

Hi Chuck,

nope, I find this:

Content visible to verified customers only.

I've changed it according to your advice and will see how it works.

Regards wolven

I also had it like this.

Changing it to get_userinfo( "", $nuserid ); seems to have solved the problem.

So this was a serious bug that was not found before now?

[wolven]

I waited a while to see how it works. It seems to work and all users receive just one mail. Problem solved!

Thanx
Regards, wolven

[Chuck S]

yes I know thanks

[gr8save]

Hello,

I have made the correction above and I am still receiving complaints about this issue.

My members have started a thread where you can find more information about when this happens, but it's pretty much like listed above. As soon as an ad is placed and approved, they get spammed with email.

Here is my what my code looks like inside image-inc.php.

Content visible to verified customers only.

[Chuck S]

I would as I have suggested above suggest you download 261 as this issue is correctly fixed

[GateKeeper]

It would appear that my users are getting spammed with auction expiration notices. The job runs every ten minutes, and an email goes out to every user with an expired ad until they do something about it, i.e. relist the auction, or delete it.
I have verified that 261 is installed. Is there a different fix for this.
Thank you!

[Chuck S]

This thread is not about the issue your reporting or attempting to trail on the end of this thread and the file you want to make sure you replace is sendnotice.php

[Big Kahuna]

I had the same problem that ZEWS and Wolven had -- and the change to image-inc.php appears to have been the solution.

Went from 8 emails to 1.

Good thing as Mopar Muscle Magazine will be featuring the classified site in its November or December issue that has already gone to press.

[gr8save]

Originally Posted by Chuck S

I would as I have suggested above suggest you download 261 as this issue is correctly fixed

Hi Chuck,

I have upgraded to 2.61 and my members are still reporting multiple emails. The most recent report claims 48 emails were sent.

http://www.goaliestore.com/board/bug...ml#post1065518

When I upgraded to 2.61 I found no upgrade option for 2.6 -> 2.61 so I only uploaded the files over the old. The system reports that it's currently 2.61 and aside from the email issue, the system is running fine.

Any ideas?

[Chuck S]

Have you applied any fix noted in here