CiviCRM Community Forums (archive)

Sonicthoughts,

your change in the \sites\all\modules\civicrm\drupal\modules\views\civicrm\civicrm_handler_field_event_link.inc file seemed to help in my case too. a lot of those errors were removed when activating a view block.

Thanks!
DicE

If there's a way to pull CiviCRM 4.2.8  Event fields into a Drupal 7.21 View, please let me know how to do it. I am trying to follow the instructions to create a View of fully-booked events as per:

http://wiki.civicrm.org/confluence/display/CRMDOC40/Event+listing+showing+fully-booked+result+using+Drupal+Views+PHP

Whenever I try to create a View and select CiviCRM Events from the Show pulldown, it automatically reverts to CiviCRM Relationships and I can't get past that point.

Any and all help is appreciated, I've been trying to make this work for over a week and have read everything  I can find (and tried most of it) without success. This topic here on the forums seems to be the most up-to-date information on the subject, but the challenge hasn't been met yet as far as I can tell.

Only one database in this case. I don't know if this is related (but it seems like it could be) ... whenever I try to get the Views array information to display as per:

civicrm/admin/setting/uf?reset=1

... no array information at all is displayed. Should I be seeing any array info or is this a change in CiviCRM version 4.2.8?

Any and all help will be very much appreciated.

Thank you, I already did try it but it doesn't do what we need. (Maybe I should move this question to a different topic?) We need to be able to run queries on civicrm events to create a page showing events with vacancies remaining as per:

http://wiki.civicrm.org/confluence/display/CRMDOC40/Event+listing+showing+fully-booked+result+using+Drupal+Views+PHP

But, as per my previous post I can't select (it changes it immediately after) CiviCRM Events from the Show pulldown, it automatically reverts to CiviCRM Relationships it changes it immediately after I select it. There's nothing drastically customized on the site, there's no custom hooks or anything like that.

I haven't altered the settings files for either drupal or civicrm. The fact that I can't display the civicrm array data is disturbing but I don't know if this is a bug in either Drupal, an installed module, or a change in Civicrm. Can you tell me please if I should be seeing the array data at:

(website URL)/civicrm/admin/setting/uf?reset=1

... using D7.21 and Civi .4.2.8?

Thank you, that's one less concern which leaves the original issue:

"We need to be able to run queries on civicrm events to create a page showing events with vacancies remaining as per:

http://wiki.civicrm.org/confluence/display/CRMDOC40/Event+listing+showing+fully-booked+result+using+Drupal+Views+PHP

But, as per my previous post I can't select (it changes it immediately after) CiviCRM Events from the Show pulldown, it automatically reverts to CiviCRM Relationships it changes it immediately after I select it. There's nothing drastically customized on the site, there's no custom hooks or anything like that. I haven't altered the settings files for either drupal or civicrm."

I assume the documentation referred to above is correct. Is there some change in recent versions that are causing this behavior or is the documentation accurate for 4.2.8? We're stuck until we can resolve this problem.

Thanks very much for the help.

Thank you, that's useful to know.