XF 2.0 Turn off and on board via SQL

[Brent W]

How can I turn off and on the board in XF 2 with SQL?

 

[oman]

The following query will accomplish this:

UPDATE xf_option SET option_value = 1 WHERE option_id ='boardActive';

DELETE FROM xf_data_registry WHERE data_key = 'options';

Set option value as 0 to close. Set option value as 1 to open.

I've tested it on XenForo 2.0.4 and it works.

Source.