Answers.Body: <p>Check your browser console log and check civicrm config log file after enabling the debugging and back trace. You will get more detail about this error.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-01-16T00:04:24.020Z
Answers.Text: this approach has worked for me; the debug/backtrace tell you which table is at fault here; for me it's always been civicrm_acl_contact_cache; once in a while it gets corrupted (not related to upgrades or anything, just happens) and I need to drop it in the d/b and copy it (just the table structure) from a backup
Answers.UserDisplayName: MtnPavlas
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-12-02T17:04:40.817Z
Answers.LastActivityDate: 2015-12-02T17:04:40.817Z
Answers.UserDisplayName: Prem Patel
Answers.Body: <p>In my case the missing table <code>jos_content</code>, which is an old standard name for a primary Joomla table, a name not used since many years (table name prefix is randomized).</p>
  
  <p>I removed the extensions <code>Content Tokens</code> and <code>Fancy Tokens</code> and the error disappeared. (Probably the culprit was <code>Content Tokens</code> since that has CMS-specific tokens for making CMS-information available).</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-10-07T13:39:46.110Z
Answers.LastActivityDate: 2016-10-07T13:39:46.110Z
Answers.UserDisplayName: thoni56
Answers.Body: <p>Just to confirm that I had the same issue with a corrupted civicrm_acl_contact_cache table.</p>
  
  <p>Dropping the table and re-importing the table structure is working for me.</p>
  
  <p>Think it happen when server ran out of disk space.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-05-24T01:23:24.507Z
Answers.LastActivityDate: 2019-05-24T01:23:24.507Z
Answers.UserDisplayName: joewickert
Answers.Body: <p>For me, all that I need to do is to Empty/Flush the civicrm_acl_contact_cache table to clear the error, but it keeps coming back. Update: dropping/recreating the civicrm_acl_conact_cache no longer works for me.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-07-31T14:27:36.937Z
Answers.Text: Update: The missing table, in my case turned out to be the 'civicrm_mail_settings' table. Importing it from a backup appears to have resolved the 'DB Error' issue.
Answers.UserDisplayName: CSDweb
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-07-29T03:56:17.523Z
Answers.LastActivityDate: 2016-07-30T17:30:44.320Z
Answers.LastEditDate: 2016-07-30T17:30:44.320Z
Answers.UserDisplayName: CSDweb
Body: <p>CiviCRM 4.6.10 Joomla 3.4.0 getting this error when going to events dashboard or trying to create event.</p>
  
  <p>Sorry but we are not able to provide this at the moment.
  DB Error: no such table
  Return to home page.</p>
  
  <p>Is there an sql database dump that will recreate all the civicrm databases including some expired sample data?</p>
  
Tags: <database>
Title: no such table when using civicrm
ThreadText: # no such table when using civicrm
  
  (Asked by: username_0 on 2015-12-02)
  
  CiviCRM 4.6.10 Joomla 3.4.0 getting this error when going to events dashboard or trying to create event.
  
  Sorry but we are not able to provide this at the moment.
  DB Error: no such table
  Return to home page.
  
  Is there an sql database dump that will recreate all the civicrm databases including some expired sample data?
  
  **Tags:** database
  
  
  ---
  
  ## 4 answers
  
  ### Answer by username_1 on 2015-12-02. Score: 4
  
  Check your browser console log and check civicrm config log file after enabling the debugging and back trace. You will get more detail about this error.
  
  > **Comments:**
  > **username_2**: this approach has worked for me; the debug/backtrace tell you which table is at fault here; for me it's always been civicrm_acl_contact_cache; once in a while it gets corrupted (not related to upgrades or anything, just happens) and I need to drop it in the d/b and copy it (just the table structure) from a backup  
  
  ---
  
  ### Answer by username_3 on 2016-10-07. Score: 1
  
  In my case the missing table `jos_content`, which is an old standard name for a primary Joomla table, a name not used since many years (table name prefix is randomized).
  
  I removed the extensions `Content Tokens` and `Fancy Tokens` and the error disappeared. (Probably the culprit was `Content Tokens` since that has CMS-specific tokens for making CMS-information available).
  
  
  ---
  
  ### Answer by username_4 on 2019-05-24. Score: 0
  
  Just to confirm that I had the same issue with a corrupted civicrm\_acl\_contact\_cache table.
  
  Dropping the table and re-importing the table structure is working for me.
  
  Think it happen when server ran out of disk space.
  
  
  ---
  
  ### Answer by username_5 on 2016-07-29. Score: 0
  
  For me, all that I need to do is to Empty/Flush the civicrm\_acl\_contact\_cache table to clear the error, but it keeps coming back. Update: dropping/recreating the civicrm\_acl\_conact\_cache no longer works for me.
  
  > **Comments:**
  > **username_5**: Update: The missing table, in my case turned out to be the 'civicrm_mail_settings' table. Importing it from a backup appears to have resolved the 'DB Error' issue.  
  
  ---
  
  