XF 1.5 Watched threads incorrect after migrating from SMF

[TheUnderdog]

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]

You could empty the xf_thread_watch table and then run a query like this:

https://xenforo.com/community/threa...l-thread-they-have-started.42325/#post-456711

 

[TheUnderdog]

You could empty the xf_thread_watch table and then run a query like this:

https://xenforo.com/community/threa...l-thread-they-have-started.42325/#post-456711

But that says: That will add a watch record for the author of every existing thread (no emails).

So it only works when you are the author of the thread, not if you posted in it...

 

[Jake Bunce]

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:

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);