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

In which table are settings stored?

Discussion in 'XenForo Development Discussions' started by Marcus, Aug 28, 2013.

  1. Marcus

    Marcus Well-Known Member

    My testforum is using my real-life database but I have to switch off "save templates as file". Do you know the database table I have to take a look into? xf_addon is just for addons, and xf_option just defines the options :/
     
  2. Rigel Kentaurus

    Rigel Kentaurus Well-Known Member

    Code:
    select * from xf_data_registry where data_key='options'
    
     
    Marcus likes this.
  3. Marcus

    Marcus Well-Known Member

    Is the whole xenForo data stored in one blob?

    Last week I changed a setting directly in the database (and not a blob) to do something similar, I forgot if it was forum software xenforo or another one.
     
  4. Chris D

    Chris D XenForo Developer Staff Member

    The setting for save templates as files is stored in xf_option but changing it there won't immediately take effect as it is cached where Rigel says (delete that row after altering the setting in xf_option)

    admin.php?options/list/performance#_templateFiles

    The option ID is templateFiles
     
    Last edited: Aug 28, 2013
    Marcus likes this.
  5. v8td

    v8td Member

    Where is stored SMTP settings?
    Thanks!
     
  6. Chris D

    Chris D XenForo Developer Staff Member

    Admin CP > Options > Email Options

    The data for all options can be found in the xf_option table.

    There should rarely be a need to view or modify this data directly in the database, however.
     
    v8td likes this.

Share This Page