- Issue created by @kenorb
- πΊπΈUnited States markusa
D8+ version doesn't work with Search API
I did just try it recently actually, and if Civi tables are in a separate database, doesn't work at all as the DataSource tries to query from the Drupal database.
Do you have Civi tables in the same database as Drupal?
- π΅πPhilippines dsdeiz
Yeah, can you export your search index configuration? I tested both CiviCRM contact and event and they are working as expected. I am just using search_api_db though.
Is your CiviCRM database separate from Drupal?
- π¬π§United Kingdom kenorb
The configuration in civicrm.settings.php points to the different db than local Drupal. So maybe mistakenly is using Drupal local db instead of what's configured in Civi's settings file?
- Status changed to Needs review
about 1 year ago 8:20pm 29 September 2023 - π΅πPhilippines dsdeiz
Yeah, that was the case. Can you give this a try - https://github.com/eileenmcnaughton/civicrm_entity/pull/450? It's on 4.0.x although I think it can be applied to 8.x-3.5 as well.
- π¬π§United Kingdom kenorb
Thanks for the patch, I'm going to test it.
I'm attaching patch for 8.x-3.x (so I can use it with Composer), since 4.x was slightly failing to apply. - Status changed to RTBC
about 1 year ago 3:47pm 17 October 2023 - π¬π§United Kingdom kenorb
Tested changes from PR and it seems to work fine. Search API indexing for Civi entities works while having 2 databases (
$databases['default']['default']
&$databases['civicrm']['default']
). - Status changed to Fixed
about 1 year ago 2:58am 19 October 2023 - πΊπΈUnited States markusa
Code was merged to 4.0.x branch in the github repo. We're gearing up to push updates to Drupal.org repo very soon for a new release.
Automatically closed - issue fixed for 2 weeks with no activity.