Answers.Body: <p>You're missing one of your tables in the CiviCRM database.  I'm not sure how that could have possibly happened!  I don't think it's possible for CiviCRM to have done it.</p>
  
  <p>If you have a backup, your IT person may be able to restore just the <code>civicrm_acl</code> table - assuming that's the only one that's missing!  If there's no backup, there's a file <code>&lt;civicrm_root&gt;/sql/civicrm.mysql</code>.  Someone can open it up in a text editor, search for the "paragraph" starting with "</p>
  
  <pre><code>CREATE TABLE `civicrm_acl` (
  </code></pre>
  
  <p>and run that entire command in MySQL to recreate a blank ACL table.</p>
  
  <p>Finally - thank you for posting the backtrace, it's what allowed me to figure out your problem!  The best way to post it is to edit your original question, which allows you better formatting options.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-02-25T17:48:10.443Z
Answers.Text: Thank you so so much!!! I will work on it as soon as my IT guy gets in and let you know how it goes. :)
Answers.UserDisplayName: Lauren
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-02-25T15:41:37.410Z
Answers.LastActivityDate: 2016-02-25T15:41:37.410Z
Answers.UserDisplayName: Jon G - Megaphone Tech
Body: <p>I've been using CiviCRM on Wordpress for about a year now. Initially, I had created a user who had 'viewing' permissions only, although this user has not been active. I'm trying to use it now and whenever I try to view a contact's details I get this error: <code>DB error: no such table</code>. Any advice? </p>
  
  <p>I have checked the Wordpress security profile and everything looks ok and this user does not have any additional CIvi ACLs assigned.
  Thanks for your insight into this!</p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-02-25T13:06:06.933Z
Comments.Text: can you paste the error & backtrace generated in ConfigAndLog file ?
Comments.UserDisplayName: jitendra - fuzion
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-02-25T13:16:15.603Z
Comments.Text: From CIVI screen:
  Sorry but we are not able to provide this at the moment.
  DB Error: no such table
  
  Return to home page.
Comments.UserDisplayName: Lauren
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-02-25T13:18:09.383Z
Comments.Text: My IT guy is not in yet and I don't know where to find the ConfigAndLog file. Could you point me in the right direction?
Comments.UserDisplayName: Lauren
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-02-25T13:19:16.620Z
Comments.Text: sure ConfigAndLog File would be created at `<wp_folder>/wp-content/plugins/files/civicrm/ConfigAndLog/your_log_file.`
Comments.UserDisplayName: jitendra - fuzion
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-02-25T13:28:43.343Z
Comments.Text: Sorry for my limited knowledge here... I found the ConfigAndLog folder and there are about 6 files in there, non of which I recognize the file type except for a text file and the most recent one is dated about a year ago. Wouldn't/shouldn't there be a more recent one if it's actively logging my errors?
Comments.UserDisplayName: Lauren
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-02-25T13:35:33.840Z
Comments.Text: Ok, I have the backtrace...just trying to figure out how to chop it up to post it. It's too long to post in here. Thank you for your help and patience @jitendrapurohit
Comments.UserDisplayName: Lauren
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-02-25T13:37:10.857Z
Comments.Text: Database Error Code: Table 'civi_crm.civicrm_acl' doesn't exist, 1146
  Additional Details:
  
  Array
  (
      [callback] => Array
          (
              [0] => CRM_Core_Error
              [1] => handle
          )
  
      [code] => -18
      [message] => DB Error: no such table
      [mode] => 16[debug_info] =>  SELECT      civicrm_acl.*
                          FROM        civicrm_acl  WHERE   civicrm_acl.entity_table   = 'civicrm_contact'
                              AND     civicrm_acl.entity_id      = 8218 [nativecode=1146 ** Table 'civi_crm.civicrm_acl' doesn't exist]
Comments.UserDisplayName: Lauren
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-02-25T13:37:36.713Z
Comments.Text: [type] => DB_Error
      [user_info] =>  SELECT      civicrm_acl.*
                          FROM        civicrm_acl  WHERE   civicrm_acl.entity_table   = 'civicrm_contact'
                              AND     civicrm_acl.entity_id      = 8218 [nativecode=1146 ** Table 'civi_crm.civicrm_acl' doesn't exist]
      [to_string] => [db_error: message="DB Error: no such table" code=-18 mode=callback callback=CRM_Core_Error::handle prefix="" info=" SELECT      civicrm_acl.*
Comments.UserDisplayName: Lauren
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-02-25T13:37:45.543Z
Comments.Text: FROM        civicrm_acl  WHERE   civicrm_acl.entity_table   = 'civicrm_contact'
                              AND     civicrm_acl.entity_id      = 8218 [nativecode=1146 ** Table 'civi_crm.civicrm_acl' doesn't exist]"]
  )
Comments.UserDisplayName: Lauren
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-02-25T13:49:54.730Z
Comments.Text: I also got a long error when I was trying to add a new user on the Wordpress side. I'm getting the feeling that we are going to have to do a major reinstall and restore...
Comments.UserDisplayName: Lauren
Tags: <wordpress><permissions>
Title: User Permissions
ThreadText: # User Permissions
  
  (Asked by: username_0 on 2016-02-25)
  
  I've been using CiviCRM on Wordpress for about a year now. Initially, I had created a user who had 'viewing' permissions only, although this user has not been active. I'm trying to use it now and whenever I try to view a contact's details I get this error: `DB error: no such table`. Any advice?
  
  I have checked the Wordpress security profile and everything looks ok and this user does not have any additional CIvi ACLs assigned.
  Thanks for your insight into this!
  
  **Tags:** wordpress, permissions
  
  > **Comments:**
  > **username_1**: can you paste the error & backtrace generated in ConfigAndLog file ?  
  > **username_0**: From CIVI screen: Sorry but we are not able to provide this at the moment. DB Error: no such table  Return to home page.  
  > **username_0**: My IT guy is not in yet and I don't know where to find the ConfigAndLog file. Could you point me in the right direction?  
  > **username_1**: sure ConfigAndLog File would be created at `<wp_folder>/wp-content/plugins/files/civicrm/ConfigAndLog/your_log_file.`  
  > **username_0**: Sorry for my limited knowledge here... I found the ConfigAndLog folder and there are about 6 files in there, non of which I recognize the file type except for a text file and the most recent one is dated about a year ago. Wouldn't/shouldn't there be a more recent one if it's actively logging my errors?  
  > **username_0**: Ok, I have the backtrace...just trying to figure out how to chop it up to post it. It's too long to post in here. Thank you for your help and patience @jitendrapurohit  
  > **username_0**: Database Error Code: Table 'civi_crm.civicrm_acl' doesn't exist, 1146 Additional Details:  Array (     [callback] => Array         (             [0] => CRM_Core_Error             [1] => handle         )      [code] => -18     [message] => DB Error: no such table     [mode] => 16[debug_info] =>  SELECT      civicrm_acl.*                         FROM        civicrm_acl  WHERE   civicrm_acl.entity_table   = 'civicrm_contact'                             AND     civicrm_acl.entity_id      = 8218 [nativecode=1146 ** Table 'civi_crm.civicrm_acl' doesn't exist]  
  > **username_0**: [type] => DB_Error     [user_info] =>  SELECT      civicrm_acl.*                         FROM        civicrm_acl  WHERE   civicrm_acl.entity_table   = 'civicrm_contact'                             AND     civicrm_acl.entity_id      = 8218 [nativecode=1146 ** Table 'civi_crm.civicrm_acl' doesn't exist]     [to_string] => [db_error: message="DB Error: no such table" code=-18 mode=callback callback=CRM_Core_Error::handle prefix="" info=" SELECT      civicrm_acl.*  
  > **username_0**: FROM        civicrm_acl  WHERE   civicrm_acl.entity_table   = 'civicrm_contact'                             AND     civicrm_acl.entity_id      = 8218 [nativecode=1146 ** Table 'civi_crm.civicrm_acl' doesn't exist]"] )  
  > **username_0**: I also got a long error when I was trying to add a new user on the Wordpress side. I'm getting the feeling that we are going to have to do a major reinstall and restore...  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_2 on 2016-02-25. Score: 2
  
  You're missing one of your tables in the CiviCRM database. I'm not sure how that could have possibly happened! I don't think it's possible for CiviCRM to have done it.
  
  If you have a backup, your IT person may be able to restore just the `civicrm_acl` table - assuming that's the only one that's missing! If there's no backup, there's a file `<civicrm_root>/sql/civicrm.mysql`. Someone can open it up in a text editor, search for the "paragraph" starting with "
  
  ```
  CREATE TABLE `civicrm_acl` (
  
  ```
  
  and run that entire command in MySQL to recreate a blank ACL table.
  
  Finally - thank you for posting the backtrace, it's what allowed me to figure out your problem! The best way to post it is to edit your original question, which allows you better formatting options.
  
  > **Comments:**
  > **username_0**: Thank you so so much!!! I will work on it as soon as my IT guy gets in and let you know how it goes. :)  
  
  ---
  
  