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

XF 1.4 SQL Query to change all subscribe threads from watch_email to watch_no_email?

Discussion in 'XenForo Questions and Support' started by RoldanLT, Nov 7, 2014.

  1. RoldanLT

    RoldanLT Well-Known Member

    SQL Query to change all current subscribe threads of all users from watch_email to watch_no_email?
    Can someone advice?
    Thanks!
     
  2. Brogan

    Brogan XenForo Moderator Staff Member

    Code:
    UPDATE xf_thread_watch SET email_subscribe = 0
    Untested.
     
    RoldanLT likes this.
  3. RoldanLT

    RoldanLT Well-Known Member

    Oh looks like I need to setup a test forum to try that Query, Thanks!
     
  4. Brogan

    Brogan XenForo Moderator Staff Member

    It should work.
    It simply changes all entries in the table to 0 - there are only two states, 0 and 1.
     
    RoldanLT likes this.
  5. RoldanLT

    RoldanLT Well-Known Member

    I just backup the whole database, just to be sure.
    Yes from the looks of the table, your query should work 99.9% :)
    Thanks!
     
  6. RoldanLT

    RoldanLT Well-Known Member

    Why 250K+ ? Threads? When I only have 47K+ :/

    Edit, Is this 250K+ are all users?

    Edit again: Aw looks like 250K+ thread/user with watch email? :unsure:
     
  7. Brogan

    Brogan XenForo Moderator Staff Member

    Each entry in the table is user ID and thread ID.

    The maximum number of entries possible is users x threads.
     
    RoldanLT likes this.

Share This Page