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 Well-Known 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 Well-Known 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.
     
    dougdirac and 14DH01 like this.
  6. .Rolex

    .Rolex New Member

    I'm working on an automated maintenance script.

    sweet. thank you sir :)
     
    dougdirac likes this.
  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

  11. dougdirac

    dougdirac Member

    Does this still work on the current XF version? I'm doing something similar.

    Which of these two queries would need to happen first, deleting the options cache or setting the board Active value?
    Does the options cache need to be deleted again when turning the board back on via sql query?

    Separately, what's the query needed to turn a board notice on?

    Thanks!
     

Share This Page