XF 1.1 Mark All Read and Flush Alerts queries?

[Big Dan]

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

 

[Digital Doctor]

I'm noticing with the import from vB 4, XF is showing all threads as unread which makes sense

Does it ?
I think the xF debut should start off with all threads read, not unread.

 

[Big Dan]

Does it ?
I think the xF debut should start off with all threads read, not unread.

It makes sense to me because XF wasn't logging what was and wasn't read.

 

[Jake Bunce]

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:

TRUNCATE TABLE xf_user_alert;

 

[Digital Doctor]

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.

Upon creation of the tables and completion of the import, can't the default be read ?

 

[Big Dan]

Thank you Jake! I live with not marking all as read.

 

[Jake Bunce]

Upon creation of the tables and completion of the import, can't the default be read ?

It could be done with a custom script that inserts appropriate records into the xf_forum_read table.