1. 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?

Discussion in 'XenForo Questions and Support' started by Big Dan, Feb 9, 2012.

  1. Big Dan

    Big Dan Active Member

    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
     
  2. Digital Doctor

    Digital Doctor Well-Known Member

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

    Big Dan Active Member

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

    Jake Bunce XenForo Moderator Staff Member

    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.

    Run this query to delete all current alerts:

    Code:
    TRUNCATE TABLE xf_user_alert;
    
     
    Big Dan likes this.
  5. Digital Doctor

    Digital Doctor Well-Known Member

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

    Big Dan Active Member

    Thank you Jake! I live with not marking all as read. :)
     
  7. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

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

Share This Page