"Base table or view not found" when running report with CiviCRM on Drupal 9.

Open on Drupal.org →

Created on 5 July 2023, almost 2 years ago

Updated 13 September 2023, over 1 year ago

Hi there,

Couldn't see another issue for this, so creating one while I investigate closer.

Installed security_review on a Drupal 9 site with CiviCRM installed, and running the rerport generates this error:

Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'jobs.civicrm_activity' doesn't exist: SELECT `id`, `details__value` FROM civicrm_activity t; Array ( ) in Drupal\security_review\Checks\Field->run() (line 108 of /app/sites/jobs/web/modules/contrib/security_review/src/Checks/Field.php).

I'll try to debug to see if it is just using the wrong database connection.

🐛 Bug report

Status

Closed: duplicate

Version

2.0

Component

Code

Created by

🇬🇧United Kingdom Finn Lewis

Live updates comments and jobs are added and updated live.

Base table or view not found when running with CiviCRM installed

Sign in to follow issues

Comments & Activities

Issue created by @Finn Lewis
Comment over 1 year ago →
🇲🇾Malaysia akmalfikri
This also happens to databases which have prefixes settings enabled and prefix exists in it's table names.
Comment over 1 year ago →
🇺🇸United States smustgrave
Closed https://www.drupal.org/project/security_review/issues/3372554 🐛 "Base table or view not found" when running report with CiviCRM on Drupal 9. Closed: duplicate as a dup.
Status changed to Closed: duplicate over 1 year ago8:47pm 13 September 2023
Comment over 1 year ago →
🇺🇸United States smustgrave
Closing this as dup of https://www.drupal.org/project/security_review/issues/3168627 🐛 Long field names which are shortened by Drupal doesn't work. Needs review since that has a patch for review

contrib.social Blog FAQ Discussions

Production build 0.71.5 2024