Timeline for How to get Views to work in CiviCRM on Drupal9 with separate CiviCRM database
Current License: CC BY-SA 4.0
8 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Apr 27, 2021 at 18:34 | comment | added | jackrabbithanna | Right, for now removing the backticks works, Drupal 9 still hasn't deprecated per-table prefixes, but may come one day. | |
| Apr 21, 2021 at 17:50 | comment | added | davejenx |
That SELECT command denied error was solved for me & others by Views integration error on D9 #4: "Try removing the back ticks ... '`' from the prefix information in the settings.local.php"
|
|
| Feb 19, 2021 at 8:48 | comment | added | Pál Rudan | It seems so, that CiviCRM Entity (at least up to CiviCRM Entity 8.x-3.0-beta2 version) not handles, if Drupal and CiviCRM are in separate databases. | |
| Feb 12, 2021 at 8:43 | comment | added | Pál Rudan | Could happen, that this github.com/eileenmcnaughton/civicrm_entity/issues/259 issue has some relation with my problem? | |
| Feb 11, 2021 at 13:39 | comment | added | Pál Rudan |
The Drupal DB user is the same as the CiviCRM user. Checked by me and by the DB manager too, and the DB User has ALL PRIVILEGES on both DB's.
|
|
| Feb 10, 2021 at 22:03 | comment | added | jackrabbithanna | This looks like Drupal DB user, set in settings.php trying to query CiviCRM database but not having permissions to SELECT on it. | |
| Feb 10, 2021 at 12:17 | comment | added | Pál Rudan |
A bit better, but still not working... I get a new error message: Drupal\Core\Database\DatabaseExceptionWrapper type: Exception in xxxViewNamexxx[xxxBlockNamexxx]: SQLSTATE[42000]: Syntax error or access violation: 1142 SELECT command denied to user 'xMyCiviCRMUserx'@'localhost' for table 'civicrm_contact': SELECT [...] message Drupal\views\Plugin\views\query\Sql->execute() function (/var/www/devweb/web/core/modules/views/src/Plugin/views/query/Sql.php file in line 1548.). (in the section [...] is a simple query, but it's too long for pasting here. xMyCiviCRMUserx has access to the db.
|
|
| Feb 9, 2021 at 20:26 | history | answered | jackrabbithanna | CC BY-SA 4.0 |