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

XF 1.1 Mark All Read and Flush Alerts queries?

Big Dan

Active member
#1
Hi,

I'm noticing with the import from vB 4, XF is showing all threads as unread which makes sense but is there a query I can run to mark all threads are read for all members?

Some members are also seeing fresh alerts. I'd like to flush them out too if possible.

Thanks,
Dan
 

Jake Bunce

XenForo moderator
Staff member
#4
is there a query I can run to mark all threads are read for all members?
The forum and thread "read" records are individual records for each user, thread, and forum. I can't think of a way to do that with a simple query.

Some members are also seeing fresh alerts. I'd like to flush them out too if possible.
Run this query to delete all current alerts:

Code:
TRUNCATE TABLE xf_user_alert;