XF 1.5 Watched threads incorrect after migrating from SMF

TheUnderdog

New member
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
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);
 
Top