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

XF 1.4 Where is Board Active set in SQL?

Discussion in 'XenForo Questions and Support' started by .Rolex, Jan 4, 2015.

  1. .Rolex

    .Rolex New Member

    Hi,

    I'm looking for where this option is turned on and off in the database.

    Any help is appreciated!

    .Rolex
     
  2. Jeremy

    Jeremy XenForo Moderator Staff Member

    It's stored in xf_option, but IDs, values, and defaults are stored as blobs/varbinary so not easily set.
     
  3. .Rolex

    .Rolex New Member

    Do you know which one it is? Or is it different for each board?
     
  4. Jeremy

    Jeremy XenForo Moderator Staff Member

    I don't know which one it is, no. Why are you trying to set it via SQL?
     
  5. borbole

    borbole Well-Known Member

    Do you want to turn the forum on/off from the db? If so run this query:

    Code:
    UPDATE xf_option SET option_value = 1 WHERE option_id ='boardActive';
    This will turn it on. To turn it off set option_value to 0.
     
    14DH01 likes this.
  6. .Rolex

    .Rolex New Member

    I'm working on an automated maintenance script.

    sweet. thank you sir :)
     
  7. Chris D

    Chris D XenForo Developer Staff Member

    You also need additional code to invalidate the options cache. If you are doing that solely with a SQL query then the easiest way would be:

    Code:
    DELETE FROM xf_data_registry WHERE data_key = 'options'
     
    14DH01 and borbole like this.
  8. .Rolex

    .Rolex New Member

    thanks Chris (y)
     
  9. 14DH01

    14DH01 Active Member

    It's simply the best way to open the " forum" if exchange server (
    former "DNS"/ news "DNS") No loss of new messages during transfer (y)
     
  10. AndyB

    AndyB Well-Known Member

Share This Page