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

XF 1.5 Watched threads incorrect after migrating from SMF

#1
After migrating from SMF I am now watching a lot of threads that I wasn't subscribed to prior to migration.

What's the reason for this?

Is there an SQL query I can run so that I can reset watched threads for everyone so that they are only watching threads they have previously posted in?
 

Jake Bunce

XenForo moderator
Staff member
#4
So it only works when you are the author of the thread, not if you posted in it...

:(
Use this query to insert watch records for all posters in all threads:

Code:
INSERT INTO xf_thread_watch (user_id, thread_id, email_subscribe)
	SELECT user_id, thread_id, 0
	FROM xf_post
	GROUP BY user_id, thread_id
ON DUPLICATE KEY UPDATE
	email_subscribe = VALUES(email_subscribe);