Answers.Body: <p>Try disabling the logging functionality using API Explorer. Navigate from the menu link - <code>Support -&gt; Developer -&gt; API Explorer</code>.</p>
  
  <p><a href="https://i.sstatic.net/y4RqY.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/y4RqY.png" alt="enter image description here"></a></p>
  
  <p>Or using Drush(if drupal) -</p>
  
  <pre><code>drush cvapi Setting.create logging=0 
  </code></pre>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-01-11T11:49:51.997Z
Answers.Text: Thanks so much Jitendra. The API Explorer way worked. After disabling via API I enabled via the UI which recreated the log files and solved my problem.
Answers.UserDisplayName: Davy Ivins
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-01-11T11:35:49.820Z
Answers.LastActivityDate: 2019-01-11T11:35:49.820Z
Answers.UserDisplayName: jitendra - fuzion
Body: <p>Drupal 6 / Civi 5.9 / Aegir</p>
  
  <p>I deleted my log_civicrm_... tables and now am getting a "DB Error: no such table" across a range of CiviCRM actions including adding contacts, running cron etc.  </p>
  
  <p>Logging is switched on and I cannot disable it via Administer > System Settings >Misc (...) > Logging).</p>
  
  <p>Is there another way? Is there a table or a file I can edit  or a command I can run to to disable logging?</p>
  
Tags: <logging><drupal-6>
Title: Civi 5.9 - DB Error: no such table / cannot disable logging
ThreadText: # Civi 5.9 - DB Error: no such table / cannot disable logging
  
  (Asked by: username_0 on 2019-01-11)
  
  Drupal 6 / Civi 5.9 / Aegir
  
  I deleted my log\_civicrm\_... tables and now am getting a "DB Error: no such table" across a range of CiviCRM actions including adding contacts, running cron etc.
  
  Logging is switched on and I cannot disable it via Administer > System Settings >Misc (...) > Logging).
  
  Is there another way? Is there a table or a file I can edit or a command I can run to to disable logging?
  
  **Tags:** logging, drupal-6
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2019-01-11. Score: 3 | Accepted answer
  
  Try disabling the logging functionality using API Explorer. Navigate from the menu link - Support -> Developer -> API Explorer.
  
  Or using Drush(if drupal) -
  drush cvapi Setting.create logging=0
  
  > **Comments:**
  > **username_0**: Thanks so much Jitendra. The API Explorer way worked. After disabling via API I enabled via the UI which recreated the log files and solved my problem.  
  
  ---
  
  