Author Topic: linking drupal-id and civicrm-id after updating to views 2.5 and civicrm 2.2.2 (Read 1360 times)

johanvdw · April 15, 2009, 12:42:13 pm

I recently updated civicrm (from 2.2.0 to 2.2.2) to be able to use the boolean custom fields in views. At the same time, I updated views.

I cleared the caches of views and reinstalled civicrm using the guidelines in from the upgrading instructions.

However, I get a new error as soon as I try to link my civicrm id to the drupal id:
SELECT civicrm_contact.id AS id, civicrm_contact.first_name AS civicrm_contact_first_name, civicrm_contact.last_name AS civicrm_contact_last_name FROM civicrm_contact civicrm_contact LEFT JOIN users users_ ON .uf_id = users_.uid LIMIT 0, 10 in xxx/modules/views/includes/view.inc on line 731.

Clearly, something is going wrong here: there is no join with the table civicrm_uf_match and that way the join with users cannot work either. I haven't had time to delve any deeper, but maybe I made an obvious mistake while upgrading and someone here has a solution?

johanvdw · April 16, 2009, 03:25:42 am

I was able to fix by editing civicrm_handler_relationship_contact2users.inc:

Code: [Select]

17,20c17,20
<       'table' => 'civicrm_uf_match',
<       'field' => 'contact_id',    
<       'left_table' => 'civicrm_contact',
<       'left_field' => 'id',
---
>       'table' => 'civicrm_contact',
>       'field' => 'id',    
>       'left_table' => 'civicrm_uf_match',
>       'left_field' => 'contact_id',
52c52
< ?>
---
> ?>
\ No newline at end of file

CiviCRM Community Forums (archive)

News:

Author Topic: linking drupal-id and civicrm-id after updating to views 2.5 and civicrm 2.2.2 (Read 1360 times)

johanvdw

linking drupal-id and civicrm-id after updating to views 2.5 and civicrm 2.2.2

johanvdw

[SOLVED ]linking drupal-id and civicrm-id views 2.5 and civicrm 2.2.2