2

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!

  • can you paste the error & backtrace generated in ConfigAndLog file ? – jitendra - fuzion Feb 25 '16 at 13:06
  • From CIVI screen: Sorry but we are not able to provide this at the moment. DB Error: no such table Return to home page. – Lauren Feb 25 '16 at 13:16
  • 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? – Lauren Feb 25 '16 at 13:18
  • sure ConfigAndLog File would be created at <wp_folder>/wp-content/plugins/files/civicrm/ConfigAndLog/your_log_file. – jitendra - fuzion Feb 25 '16 at 13:19
  • 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? – Lauren Feb 25 '16 at 13:28
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.

  • 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. :) – Lauren Feb 25 '16 at 17:48

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.