R rdn Well-known member Nov 7, 2014 #1 SQL Query to change all current subscribe threads of all users from watch_email to watch_no_email? Can someone advice? Thanks!
SQL Query to change all current subscribe threads of all users from watch_email to watch_no_email? Can someone advice? Thanks!
P Paul B XenForo moderator Staff member Nov 7, 2014 #2 Code: UPDATE xf_thread_watch SET email_subscribe = 0 Untested. Upvote 0 Downvote
R rdn Well-known member Nov 7, 2014 #3 Oh looks like I need to setup a test forum to try that Query, Thanks! Upvote 0 Downvote
P Paul B XenForo moderator Staff member Nov 7, 2014 #4 It should work. It simply changes all entries in the table to 0 - there are only two states, 0 and 1. Upvote 0 Downvote
It should work. It simply changes all entries in the table to 0 - there are only two states, 0 and 1.
R rdn Well-known member Nov 7, 2014 #5 I just backup the whole database, just to be sure. Yes from the looks of the table, your query should work 99.9% Thanks! Upvote 0 Downvote
I just backup the whole database, just to be sure. Yes from the looks of the table, your query should work 99.9% Thanks!
R rdn Well-known member Nov 7, 2014 #6 252649 rows affected. (Query took 2.0870 seconds.) Click to expand... Why 250K+ ? Threads? When I only have 47K+ :/ Edit, Is this 250K+ are all users? Edit again: Aw looks like 250K+ thread/user with watch email? Upvote 0 Downvote
252649 rows affected. (Query took 2.0870 seconds.) Click to expand... Why 250K+ ? Threads? When I only have 47K+ :/ Edit, Is this 250K+ are all users? Edit again: Aw looks like 250K+ thread/user with watch email?
P Paul B XenForo moderator Staff member Nov 7, 2014 #7 Each entry in the table is user ID and thread ID. The maximum number of entries possible is users x threads. Upvote 0 Downvote
Each entry in the table is user ID and thread ID. The maximum number of entries possible is users x threads.
