Hello,
I have 2 registered users who are receiving unsubscribed forum topic content regardless of their individual subscription settings. Here's the relevant info:
Users: born@climate.unibe.ch and brady
URL: http://bb.cgd.ucar.edu
Looking at the subscriptions table for these UID's (recipient_uid), I see the following:
sid module field value recipient_uid send_interval author_uid send_updates send_comments
382 node type forum 1040275 1 -1 1 1
1955 node type forum 1041495 1 -1 1 1
... and from the subscriptions_users table, I see the following:
uid digest send_interval send_updates send_comments send_interval_visible send_updates_visible send_comments_visible autosub_on_post autosub_on_update autosub_on_comment send_self suspended
1040275 0 3600 1 1 1 1 1 1 1 1 1 0
1041495 0 3600 0 0 1 1 1 0 0 0 0 0
... other information. We're using the Advanced Forums module (v7.x-2.0). We had initially brought up the site with Comment Notify v7.x-1.1 and then switched to Subscriptions and disabled the Comment Notify. Could there be some kind of cross-talk still going on? I'm not able to repeat the problem on our test server.
Bug? User Admin error? any suggestions most welcome!
Comments
Comment #1
salvisDo you really have UIDs in the millions?
If you have {subscriptions} records like
382 node type forum 1040275 1 -1 1 1
1955 node type forum 1041495 1 -1 1 1
then your users 1040275 and 1041495 do have (content type) subscriptions to all forum posts (in all accessible forums).
That's what "node type forum" means.
Comment #2
aliceb commentedHi there,
Yes, UID's in the millions due to a port from a previous vBulletin site. We don't have that many actual users.
I ran a query as follows:
select u.uid, u.name, u.mail from users as u, subscriptions as s
where u.uid = s.recipient_uid and field='type' and value='forum';
and got back 39 records. I then masqueraded in as a couple of users from that list who I know are not subscribed to all forum topics and are *not* receiving any unsubscribed notifications (i.e. subscriptions notifications are working correctly for them).
So, I'm still not sure why it's just these two users (that I know of) who are receiving unsubscribed notifications.
Should I try removing them from the subscriptions table completely and let them reset their preferences again?
Thanks,
Alice
Comment #3
salvisI'm still not sure we're on the same page when you write 'unsubscribed notifications'.
Go to user/1040275/subscriptions/type and user/1041495/subscriptions/type, look for the 'Forum topic' content type, and verify that they have not subscribed to it.
Comment #4
aliceb commentedhmmm... I get "access denied" when I try to go to those pages and I'm admin.
The pages I'm looking at are:
user/1040275/subscriptions/taxa and user/1041495/subscriptions/taxa
which lists the current subscriptions for the categories (forum topics) available and in both cases, none of these categories are selected.
Other settings I can try on the configuration of the module?
Thanks,
A.
Comment #5
salvisTry being user 1.
The .../taxa page creates node|tid|TID subscriptions, and the .../type page node|type|TYPE subscriptions.
You can delete the node|type|forum rows via SQL if you prefer a quick fix.
Comment #6
aliceb commentedI deleted the users with recipient_uid's in the subscriptions table that had an entry with the field='type' and value='forum'. I've asked a couple of friendly users to let me know if they're receiving any notifications now that they never subscribed to - that's what I meant by unwanted subscription notifications.
One interesting thing to note, when new registration requests come in, they are automatically blocked until approved by an admin BUT an entry for them is added to the users and subscriptions tables in the database and then subsequently removed when registration requests are deleted. We receive a lot of bogus registration requests. Their associated subscriptions entry has the field='type' and value='forum' set by default.
I'm wondering if what's been happening is that we've had some users request registration, they are approved but then they never update their subscriptions settings and leave them as the default with the field='type' and value='forum'.
So, to make a long story not so short... I'm not sure if this is a bug in the subscriptions module or an integration issue on our end with the user module.
Thanks for your time.
Alice
Comment #7
salvisThe default type subscriptions for newly created users are at admin/config/system/subscriptions/userdefaults/type.
The default subscriptions are entered into the {subscriptions} table when the user is created (no "BUT" here) and removed when the user is deleted. They do not become active until a user has logged in for the first time. Subscriptions are disabled for blocked users.
Did you try user 1 for accessing user/1040275/subscriptions/type ? You need the 'Administer user subscriptions' permission for that, or be user 1. If you still cannot access the page, then there must be some custom code on your site that is blocking access.
AFAICS, everything is working perfectly.