Hi there.
I've created a series of workshops within CiviEvents and am able to group and display them in Drupal using the views module - most current versions of Drupal and Civicrm with the date patch applied. Works like a charm when sorting by title or date!
I also need to group them by stream - that is a series of 5 workshops that are grouped so that participants can go through them all together. I thought creating a custom field for the stream code would do this, but while I can access the field in the Drupal view for the sort, I get the following message when I try to preview the view (a civievent view:
user warning: Table 'xxxx1_drupal.civicrm_value_course_code_3' doesn't exist query: SELECT civicrm_event.id AS id, civicrm_event.start_date AS civicrm_event_start_date, civicrm_value_course_code_3.course_code_6 AS civicrm_value_course_code_3_course_code_6 FROM xxxxx_civicrm.civicrm_event civicrm_event LEFT JOIN civicrm_value_course_code_3 civicrm_value_course_code_3 ON civicrm_event.id = civicrm_value_course_code_3.entity_id LIMIT 0, 10 in /hsphere/local/home/xxxxxx/xxxxx.ideaworldhq.com/modules/views/includes/view.inc on line 731.
Not being a programmer, Im lost here - any suggestions would be appreciated. The only alternative I see is to integrate the code into the course title and do the sort based on that.
Thanks
Chris Hutcheson
Comments
Same problem
I'm having the same problem here... It seems like the query is run on the drupal db instead of the civicrm db.
My MySQL user has priviledges for both databases.
I'm still trying to figgure out a solution that wont bite me in the arse a at a later stage.