User gets subscription emails but not subscribed?

[ddolliver]

I have one user that keeps getting the following emails, but he has no subscriptions to any ads. The PPC system (2.61) is integrated with VB 3.6.7x.

Email sent to this user:

To: <xxxxxx@att.net>
Sent: New Reply to Sold the Lighnting - lots of parts for sale, including
Boyd Coddington wheels... at National Lightning Owners Club


> blwnsvt01 has posted a reply about the following ad:
>
> "Sold the Lighnting - lots of parts for sale, including Boyd Coddington
> wheels..."
>
> http://www.nloc.net/classifieds/show...hp?product=514
>
> If you no longer wish to be notified of replies about the above ad, you
> can disable notification for it here:
>
> http://www.nloc.net/classifieds/comm...d=&product=514
>
> Thanks!
>
> The National Lightning Owners Club Team
> http://www.nloc.net


Help

[Chuck S]

Okay looks to me though we are finding a subscription for him in your notify table.

What you can do is a couple things here. For one you can view the users classifieds profile and see if you find subscriptions there.

http://www.nloc.net/classifieds/member.php?uid=XXX

Now if you dont see anything there we will need to go to your sites control panel and use phpmyadmin which is a database viewer in most sites where you can view and work with your databases. You can run a query like so to select all subscriptions based on userid where xxx equals the userid.

SELECT * FROM pp_notify WHERE userid=XXX

Once we see there are subscriptions normally you delete subscriptions from the member profile but you can use a query like this in phpmyadmin again replacing XXX with userid of the user.

DELETE FROM pp_notify WHERE userid=XXX