• 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?

Chris D

XenForo developer
Staff member
#7
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.
I'm working on an automated maintenance script.



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

Active member
#9
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)
 
#11
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.
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'
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!