CiviCRM Stack Exchange is a question and answer site for administrators and users of the CiviCRM Constituent Relationship Management software. It only takes a minute to sign up.
Sign up to join this community
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!
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.
<wp_folder>/wp-content/plugins/files/civicrm/ConfigAndLog/your_log_file.– jitendra - fuzion Feb 25 '16 at 13:19