Hi there,

Recently the management at a site I help administer wanted to, as a one-time measure in order to make sure people opted into autosubscribe, uncheck the auto-subscribe options from people's profiles. So I ran an update query against the fields beginning with autosub_ setting them to 0. However, this didn't seem to work for everyone. Is it safe to assume that this setting is cached somewhere or set as a Drupal database variable?

Please let me know a bit about this so I can deliver a better solution.

I also want to turn off self_notify for everyone.

Thanks,
Kevin

Comments

salvis’s picture

salvis
he/his
commented

Set them to -1, then they'll use the settings that you define on admin/settings/subscriptions/userdefaults.

Note that uid's < 0 really are rid's (role ids). What you set on admin/settings/subscriptions/userdefaults is stored in {subscriptions_user} with uid -2 (authenticated user).

I'm surprised that your database changes haven't worked for you. There's no caching or variables.

gwtt’s picture

gwtt commented

Thanks; I'll give it a try and let you know what happens...

gwtt’s picture

gwtt commented
Status: Active » Closed (fixed)

Hi salvis,

It appears this was actually a PEBKAC error :)

We recently had some issues and had to restore an old copy of the database...I restored it to a different database and pointed to that, but I think I must have run the updates against the old copy. It would make sense, since out of habit I probably clicked that.

Anyway, seems good now so I set this to closed.

Thanks for responding anyway; it was helpful.