Support Forum

Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
general-topic
Auto subscribe emails aren't being sent
Avatar
lisalew
Member
Free Members
sp_UserOfflineSmall Offline
Jan 10, 2012 - 10:27 pm

I clicked the "Auto subscribe members to all topics they post in:" under Member Settings a few months ago.  New members still aren't getting emails when someone posts to their topics.

 

Note - I haven't upgraded since right before the Beta release because I don't want to upgrade to 3.3.  Do I need to upgrade in order to get the emails to work?

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Jan 11, 2012 - 8:40 pm

we dont seem to be having an issues here or any other reports... but dont know anyone else still on the alpha which is known to have some issues with old wp... which is why the min was changed for beta...

What's the hesitation on upgrading to wp 3.3??

Avatar
lisalew
Member
Free Members
sp_UserOfflineSmall Offline
Jan 12, 2012 - 9:51 am

Thanks for the response.  I'll go ahead and upgrade.  We are using several plugins, and I've made several customizations to the forum, so I'm just a little nervous to upgrade.  But I'm sure it will need to be done eventually, so I might as well do it now!

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Jan 12, 2012 - 11:10 am

Do you mean customisation to core SP code? If so may I ask what it was as it may well be possible to do what you want with the templates.

if you changed theme code or CSS then you should really create your own theme instead of using a supplied one.

andy-signature.png
YELLOW
SWORDFISH
Avatar
lisalew
Member
Free Members
sp_UserOfflineSmall Offline
Jan 16, 2012 - 2:05 pm

My simple-press customizations were to the theme, so I was able to duplicate my theme so it wouldn't get written over.  I upgraded everything to 3.3, and so far so good.  Thank you!

One question...what field in the database stores whether a member is receiving emails when they get responses to their topics?  I would like to set all of our existing members to auto-subscribe (I believe the option to do this in the forum backend only applies to new members).

 

Thanks!

Lisa 

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Jan 16, 2012 - 2:37 pm

Ooh. Tricky one.
The setting is in the sfmembers table in the column user_options. The problem is that this a serialised array. if you take a look you will see the array element named 'autosubpost'. Actually the part you need to look at is:

s:11:"autosubpost";b:0;

To change this turned on it would need to be:

s:11:"autosubpost";b:1;

Not something that could be done with a simple SQL query I am afraid.

andy-signature.png
YELLOW
SWORDFISH
Avatar
lisalew
Member
Free Members
sp_UserOfflineSmall Offline
Jan 16, 2012 - 4:19 pm

Could I just do a simple string replace and change all of the "s:11:"autosubpost";b:0;" to "s:11:"autosubpost";b:1;"?

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Jan 16, 2012 - 5:13 pm

Should be safe. Just be careful not to change the overall length of any items or any other data

andy-signature.png
YELLOW
SWORDFISH
Avatar
lisalew
Member
Free Members
sp_UserOfflineSmall Offline
Jan 24, 2012 - 11:54 am

It worked - thanks so much!  - PS - for anyone else who might try the search and replace method...it is i:0 instead of b:0 - at least in my database.

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Jan 24, 2012 - 12:23 pm

Interesting, I would expected either to work but those serialized arrays are black magic!
Glad you managed to do that.

andy-signature.png
YELLOW
SWORDFISH
Forum Timezone: Europe/Stockholm
Most Users Ever Online: 1170
Currently Online:
Guest(s) 1
Top Posters:
Mr Papa: 19448
Ike: 2086
Brandon: 864
kvr28: 804
jim: 650
FidoSysop: 577
Conrad_Farlow: 531
fiddlerman: 358
Stefano Prete: 325
Member Stats:
Guest Posters: 620
Members: 17365
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10128
Posts: 79626