Answers.Body: <p><code>civicrm_group_contact_cache</code> table for some reason has exceeded auto-increment value limit (2^32).</p>
  
  <p>This is possible because of nature of this table - caching, adding, removing items.</p>
  
  <p>Solution is to drop auto-increment value to beginning:</p>
  
  <pre><code>ALTER TABLE civicrm_group_contact_cache AUTO_INCREMENT = 1
  </code></pre>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-01-18T16:52:18.517Z
Answers.LastActivityDate: 2018-01-20T07:35:48.293Z
Answers.LastEditDate: 2018-01-20T07:35:48.293Z
Answers.UserDisplayName: Erik Ropez
Answers.Body: <p>Detailed instructions are available in the <a href="https://docs.civicrm.org/sysadmin/en/latest/troubleshooting/#debugging" rel="nofollow noreferrer">"More detailed errors"</a> section of the troubleshooting guide.  In short: Either turn on debugging AND backtrace, which will give you a more detailed error; or view the appropriate errors in your CiviCRM log.</p>
  
  <p>If you need help interpreting those errors, I suggest opening a new question here.  It's also a good practice to paste the text of the error instead of (or in addition to) a screenshot of the error - it makes it easier for others to search, and easier for someone to troubleshoot.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-01-18T16:01:36.190Z
Answers.LastActivityDate: 2018-01-18T16:01:36.190Z
Answers.UserDisplayName: Jon G - Megaphone Tech
Answers.Body: <p>You will find more information on the cause of error you are getting in civicrm log files. The location may vary of log files based on the CMS you are using. Typically location of log files for following CMS's are as follows:</p>
  
  <p><strong>Drupal</strong>: sites/default/files/civicrm/ConfigAndLog</p>
  
  <p><strong>Wordpress</strong>: Location is based on civicrm version, can be found at one of the following locations:</p>
  
  <ul>
  <li>wp-content/uploads/civicrm/ConfigAndLog</li>
  <li>wp-content/plugins/files/civicrm/ConfigAndLog</li>
  </ul>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-01-18T19:24:45.607Z
Answers.LastActivityDate: 2018-01-18T19:24:45.607Z
Answers.UserDisplayName: Hassan Farooq
Body: <p>Suddenly an error appeared out of nowhere when managing groups.</p>
  
  <blockquote>
    <p>"Count data for smart groups is not currently calculated. You may click Update >Smart Groups to generate it. Be aware this can cause significant server load." <em>(screenshot 1)</em></p>
  </blockquote>
  
  <p>When I try to <strong>Update Smart Group Count</strong> or click on <em>Contacts</em> of any group, there is the error:</p>
  
  <blockquote>
    <p>Sorry but we are not able to provide this at the moment. </p>
    
    <p>DB Error: unknown error</p>
    
    <p>Return to home page.</p>
    
    <p><em>(screenshot 2)</em></p>
  </blockquote>
  
  <p>Meanwhile, the database is NOT down. I can access contacts through search.</p>
  
  <p>What could have happened? Where do I start looking for solutions?</p>
  
  <p><strong>CiviCRM 4.7.14. on Drupal 7.52</strong></p>
  
  <h2><a href="https://i.sstatic.net/MtbY9.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/MtbY9.png" alt="enter image description here"></a></h2>
  
  <p><a href="https://i.sstatic.net/Ucwrh.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/Ucwrh.png" alt="enter image description here"></a></p>
  
Tags: <error><groups><smartgroups>
Title: How can I identify DB error?
ThreadText: # How can I identify DB error?
  
  (Asked by: username_0 on 2018-01-18)
  
  Suddenly an error appeared out of nowhere when managing groups.
  
  > "Count data for smart groups is not currently calculated. You may click Update >Smart Groups to generate it. Be aware this can cause significant server load." *(screenshot 1)*
  
  When I try to **Update Smart Group Count** or click on *Contacts* of any group, there is the error:
  
  > Sorry but we are not able to provide this at the moment.
  >
  > DB Error: unknown error
  >
  > Return to home page.
  >
  > *(screenshot 2)*
  
  Meanwhile, the database is NOT down. I can access contacts through search.
  
  What could have happened? Where do I start looking for solutions?
  
  **CiviCRM 4.7.14. on Drupal 7.52**
  
  ## [enter image description here](https://i.sstatic.net/MtbY9.png)
  
  [![enter image description here](https://i.sstatic.net/Ucwrh.png)](https://i.sstatic.net/Ucwrh.png)
  
  **Tags:** error, groups, smartgroups
  
  
  ---
  
  ## 3 answers
  
  ### Answer by username_1 on 2018-01-18. Score: 2 | Accepted answer
  
  `civicrm_group_contact_cache` table for some reason has exceeded auto-increment value limit (2^32).
  
  This is possible because of nature of this table - caching, adding, removing items.
  
  Solution is to drop auto-increment value to beginning:
  
  ```
  ALTER TABLE civicrm_group_contact_cache AUTO_INCREMENT = 1
  
  ```
  
  
  ---
  
  ### Answer by username_2 on 2018-01-18. Score: 2
  
  Detailed instructions are available in the ["More detailed errors"](https://docs.civicrm.org/sysadmin/en/latest/troubleshooting/#debugging) section of the troubleshooting guide. In short: Either turn on debugging AND backtrace, which will give you a more detailed error; or view the appropriate errors in your CiviCRM log.
  
  If you need help interpreting those errors, I suggest opening a new question here. It's also a good practice to paste the text of the error instead of (or in addition to) a screenshot of the error - it makes it easier for others to search, and easier for someone to troubleshoot.
  
  
  ---
  
  ### Answer by username_3 on 2018-01-18. Score: 0
  
  You will find more information on the cause of error you are getting in civicrm log files. The location may vary of log files based on the CMS you are using. Typically location of log files for following CMS's are as follows:
  
  **Drupal**: sites/default/files/civicrm/ConfigAndLog
  
  **Wordpress**: Location is based on civicrm version, can be found at one of the following locations:
  
  * wp-content/uploads/civicrm/ConfigAndLog
  * wp-content/plugins/files/civicrm/ConfigAndLog
  
  
  ---
  
  