Answers.Body: <p>It's in civicrm_setting but if it's never been turned on it won't be there. But also it's more than just a setting - you would need to rebuild the schema and triggers.</p>
  <p>If you have <a href="https://github.com/totten/cv" rel="nofollow noreferrer">cv</a> installed you can do <code>cv ev &quot;Civi::settings()-&gt;set('logging', 1); $s = new CRM_Logging_Schema(); $s-&gt;enableLogging();&quot;</code> to do it from the command line manually.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-01-03T03:41:25.263Z
Answers.Text: Thanks! I don't have cv installed. Is there anywhere that details the civicrm_settings record that is needed? But really, sounds like I need to work through the gateway timeout issue.
Answers.UserDisplayName: RiverRunner
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-01-03T04:46:45.877Z
Answers.Text: I could tell you what the database row looks like, but inserting it by itself will just make your database inconsistent. The extra tables and triggers need to get created in order for logging to be enabled and do anything.
Answers.UserDisplayName: Demerit
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-01-02T00:55:15.173Z
Answers.LastActivityDate: 2021-01-02T00:55:15.173Z
Answers.UserDisplayName: Demerit
Body: <p>I am attempting to turn on detailed logging for a site (Administer -&gt; System Settings -&gt; Misc (Undelete, PDFs, Limits, Logging, Captcha, etc.), the Logging option. When I save the change, I'm getting a gateway timeout, and am working with the hosting company to resolve that.</p>
  <p>In the meantime, where is that setting saved? I don't see a place in civicrm.settings.php nor in the civicrm_setting table. But I suspect that's because No is the default.</p>
  <p>How and where can I add that setting manually? So far, my Google Fu is failing me.</p>
  <p>Thanks!</p>
  
Tags: <civicrm.settings.php><logging><civicrm.settings><system-settings>
Title: Where is the Detailed Logging setting stored?
ThreadText: # Where is the Detailed Logging setting stored?
  
  (Asked by: username_0 on 2021-01-01)
  
  I am attempting to turn on detailed logging for a site (Administer -> System Settings -> Misc (Undelete, PDFs, Limits, Logging, Captcha, etc.), the Logging option. When I save the change, I'm getting a gateway timeout, and am working with the hosting company to resolve that.
  
  In the meantime, where is that setting saved? I don't see a place in civicrm.settings.php nor in the civicrm\_setting table. But I suspect that's because No is the default.
  
  How and where can I add that setting manually? So far, my Google Fu is failing me.
  
  Thanks!
  
  **Tags:** civicrm.settings.php, logging, civicrm.settings, system-settings
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2021-01-02. Score: 1
  
  It's in civicrm\_setting but if it's never been turned on it won't be there. But also it's more than just a setting - you would need to rebuild the schema and triggers.
  
  If you have [cv](https://github.com/totten/cv) installed you can do `cv ev "Civi::settings()->set('logging', 1); $s = new CRM_Logging_Schema(); $s->enableLogging();"` to do it from the command line manually.
  
  > **Comments:**
  > **username_0**: Thanks! I don't have cv installed. Is there anywhere that details the civicrm_settings record that is needed? But really, sounds like I need to work through the gateway timeout issue.  
  > **username_1**: I could tell you what the database row looks like, but inserting it by itself will just make your database inconsistent. The extra tables and triggers need to get created in order for logging to be enabled and do anything.  
  
  ---
  
  