• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

XF 1.4 SQL Query to change all subscribe threads from watch_email to watch_no_email?


Well-known member
SQL Query to change all current subscribe threads of all users from watch_email to watch_no_email?
Can someone advice?


Well-known member
252649 rows affected. (Query took 2.0870 seconds.)
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? :unsure: