CiviCRM Community Forums (archive)

I've followed the views integration piece for my site, and the general basis of views / civicrm is working. When I start adding relationships to my view, I get errors. Not sure I'm doing this right.

Would like to pay someone for some of their time to help me fix this issue, and pave the way towards me being able to build some powerful views. Just getting my head around what's not working right now would be quite helpful. More work would likely come from this initial piece.

I can be reached at adam(at)shorelineconsulting(dot)ca

thank you,
adam

current issue:

Error message
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'civicrm_contact.contact_id' in 'on clause'

SQL:
SELECT civicrm_contact.id AS id, civicrm_contribution_civicrm_contact__civicrm_contact.first_name AS civicrm_contribution_civicrm_contact__civicrm_contact_first_, civicrm_contribution_civicrm_contact__civicrm_contact.id AS civicrm_contribution_civicrm_contact__civicrm_contact_id, civicrm_contact.last_name AS civicrm_contact_last_name
FROM
{civicrm_contact} civicrm_contact
LEFT JOIN {civicrm_contribution} civicrm_contribution_civicrm_contact ON civicrm_contact.contact_id = civicrm_contribution_civicrm_contact.id
LEFT JOIN {civicrm_contact} civicrm_contribution_civicrm_contact__civicrm_contact ON civicrm_contribution_civicrm_contact.contact_id = civicrm_contribution_civicrm_contact__civicrm_contact.id

I'm seeing the same issue when using a CiviContribute relationship too.
As a workaround I've altered the SQL of the view in a drupal custom module as follows:


 /**
 * Implements hook_views_query_alter()
 */
function mycustommodule_views_query_alter(&$view, &$query) {
  // this is the name of our View and Display
  if ($view->name == 'membership_renewal_due' && $view->current_display == 'default') {
  //dpm($query);
      $query->table_queue['civicrm_contribution_civicrm_contact']['join']->left_field = 'id';
      $query->table_queue['civicrm_contribution_civicrm_contact']['join']->definition['left_field'] = 'id';
  }
}


This should work if you just change the function name to match your custom module and alter the view name and current display for your view.

Is this still an issue with D7 and civi 4.2.0? I have those versions installed and the error began happening yesterday....