J Joe Blow Well-known member Dec 11, 2017 #1 Where is the Receive Site mailings setting located in the Xenforo database? Thanks for your help.
J Joe Blow Well-known member Dec 12, 2017 #2 OK, let me explain in a little more details what it is I would like to do. I want to execute a SQL query that will change the Receive Site Mailings setting to off for members of a particular user group (#19). Thanks to anyone who is able to assist. Upvote 0 Downvote
OK, let me explain in a little more details what it is I would like to do. I want to execute a SQL query that will change the Receive Site Mailings setting to off for members of a particular user group (#19). Thanks to anyone who is able to assist.
J Joe Blow Well-known member Dec 13, 2017 #3 OK, I'm trying this Code: UPDATE xf_user_option SET receive_admin_email = 0 WHERE user_group_id = 19 But getting this error message: #1054 - Unknown column 'user_group_id' in 'where clause' Is it because user_group_id is in another database table? Upvote 0 Downvote
OK, I'm trying this Code: UPDATE xf_user_option SET receive_admin_email = 0 WHERE user_group_id = 19 But getting this error message: #1054 - Unknown column 'user_group_id' in 'where clause' Is it because user_group_id is in another database table?
P Paul B XenForo moderator Staff member Dec 13, 2017 #4 Joe Blow said: Is it because user_group_id is in another database table? Click to expand... Correct. It's not as simple as that as user groups are stored as an array in a single field. Why not just ask the members to update their preferences? Upvote 0 Downvote
Joe Blow said: Is it because user_group_id is in another database table? Click to expand... Correct. It's not as simple as that as user groups are stored as an array in a single field. Why not just ask the members to update their preferences?
J Joe Blow Well-known member Dec 13, 2017 #5 Brogan said: Why not just ask the members to update their preferences? Click to expand... Because it's an unsubscribed user group where users have basically left the forum and I don't want them getting any admin emails. Is there any way to achieve this with a query? Upvote 0 Downvote
Brogan said: Why not just ask the members to update their preferences? Click to expand... Because it's an unsubscribed user group where users have basically left the forum and I don't want them getting any admin emails. Is there any way to achieve this with a query?