G'day all,

I would like to use the volunteer module under Drupal 4.7.

As required I have installed the civiCRM module (not knowing which version works best with the event module I installed v1.5).

I have tried three fresh installations of Drupal 4.7, in each trialling different downloads of the modules such as using civCRM 1.6 beta and older event modules. I even attempted to use civicspace 0.8.5 (which btw successfully got the pre-packaged volunteer module working) and tried to copy the modules across from this civicspace install into my drupal 4.7 install - which as you probably guessed, didnt work.

With the VOLUNTEER module I have tried the HEAD release and tried the files available in the CVS. I have even applied the patch to port the 4.6 version of volunteer into 4.7 found here http://drupal.org/node/60392

If anyone in the community has managed to get drupal 4.7 running with the volunteer module please let me know which releases to use of the civicrm module, event module and any modifications/patches which need to be done on the volunteer module. Also if it helps to identify the cause of my problems I have included two errors below (each one on a different drupal installation)

Thank you for the support

Cheers

Tim

>>I have the following errors coming up-

In one Drupal 4.7 setup

Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => 
    [message] => Fontfile not found or not readable.
    [mode] => 16
    [debug_info] => 
    [type] => pear_error
    [user_info] => 
    [to_string] => [pear_error: message="Fontfile not found or not readable." code=0 mode=callback callback=CRM_Core_Error::handle prefix="" info=""]

and in another setup:

Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -19
    [message] => DB Error: no such field
    [mode] => 16
    [debug_info] => SELECT contact_a.id as contact_id, contact_a.contact_type as contact_type, contact_a.contact_sub_type  as `contact_sub_type`, contact_a.sort_name as sort_name, contact_a.display_name as display_name, civicrm_individual.id as individual_id, civicrm_individual.first_name as `first_name`, civicrm_individual.middle_name as `middle_name`, civicrm_individual.last_name as `last_name`, civicrm_individual.birth_date as `birth_date`, civicrm_gender.id as gender_id, civicrm_gender.name as `gender`, civicrm_location.id as location_id, civicrm_address.id as address_id, civicrm_address.street_address as `street_address`, civicrm_address.supplemental_address_1 as `supplemental_address_1`, civicrm_address.supplemental_address_2 as `supplemental_address_2`, civicrm_address.city as `city`, civicrm_address.postal_code as `postal_code`, civicrm_address.postal_code_suffix as `postal_code_suffix`, civicrm_address.geo_code_1 as `geo_code_1`, civicrm_address.geo_code_2 as `geo_code_2`, civicrm_state_province.id as state_province_id, civicrm_state_province.abbreviation as `state_province`, civicrm_country.id as country_id, civicrm_country.name as `country`, civicrm_phone.id as phone_id, civicrm_phone.phone_type as phone_type, civicrm_phone.phone as `phone`, civicrm_email.id as email_id, civicrm_email.email as `email`, civicrm_im.id as im_id, civicrm_im.name as `im`, contact_a.legal_identifier  as `legal_identifier`, contact_a.external_identifier  as `external_identifier`, contact_a.nick_name  as `nick_name`, contact_a.home_URL  as `home_URL`, contact_a.preferred_mail_format  as `preferred_mail_format`  FROM civicrm_contact contact_a LEFT JOIN civicrm_individual ON (contact_a.id = civicrm_individual.contact_id)  LEFT JOIN civicrm_gender ON civicrm_individual.gender_id = civicrm_gender.id  LEFT JOIN civicrm_location ON (civicrm_location.entity_table = 'civicrm_contact' AND
                                                           contact_a.id = civicrm_location.entity_id AND civicrm_location.is_primary = 1) LEFT JOIN civicrm_address ON civicrm_location.id = civicrm_address.location_id  LEFT JOIN civicrm_state_province ON civicrm_address.state_province_id = civicrm_state_province.id  LEFT JOIN civicrm_country ON civicrm_address.country_id = civicrm_country.id  LEFT JOIN civicrm_email ON (civicrm_location.id = civicrm_email.location_id AND civicrm_email.is_primary = 1)  LEFT JOIN civicrm_phone ON (civicrm_location.id = civicrm_phone.location_id AND civicrm_phone.is_primary = 1)  LEFT JOIN civicrm_im ON (civicrm_location.id = civicrm_im.location_id AND civicrm_im.is_primary = 1)  WHERE  ( contact_a.id = 101 )  LIMIT 0, 25  [nativecode=1054 ** Unknown column 'contact_a.contact_sub_type' in 'field list']
    [type] => db_error
    [user_info] => SELECT contact_a.id as contact_id, contact_a.contact_type as contact_type, contact_a.contact_sub_type  as `contact_sub_type`, contact_a.sort_name as sort_name, contact_a.display_name as display_name, civicrm_individual.id as individual_id, civicrm_individual.first_name as `first_name`, civicrm_individual.middle_name as `middle_name`, civicrm_individual.last_name as `last_name`, civicrm_individual.birth_date as `birth_date`, civicrm_gender.id as gender_id, civicrm_gender.name as `gender`, civicrm_location.id as location_id, civicrm_address.id as address_id, civicrm_address.street_address as `street_address`, civicrm_address.supplemental_address_1 as `supplemental_address_1`, civicrm_address.supplemental_address_2 as `supplemental_address_2`, civicrm_address.city as `city`, civicrm_address.postal_code as `postal_code`, civicrm_address.postal_code_suffix as `postal_code_suffix`, civicrm_address.geo_code_1 as `geo_code_1`, civicrm_address.geo_code_2 as `geo_code_2`, civicrm_state_province.id as state_province_id, civicrm_state_province.abbreviation as `state_province`, civicrm_country.id as country_id, civicrm_country.name as `country`, civicrm_phone.id as phone_id, civicrm_phone.phone_type as phone_type, civicrm_phone.phone as `phone`, civicrm_email.id as email_id, civicrm_email.email as `email`, civicrm_im.id as im_id, civicrm_im.name as `im`, contact_a.legal_identifier  as `legal_identifier`, contact_a.external_identifier  as `external_identifier`, contact_a.nick_name  as `nick_name`, contact_a.home_URL  as `home_URL`, contact_a.preferred_mail_format  as `preferred_mail_format`  FROM civicrm_contact contact_a LEFT JOIN civicrm_individual ON (contact_a.id = civicrm_individual.contact_id)  LEFT JOIN civicrm_gender ON civicrm_individual.gender_id = civicrm_gender.id  LEFT JOIN civicrm_location ON (civicrm_location.entity_table = 'civicrm_contact' AND
                                                           contact_a.id = civicrm_location.entity_id AND civicrm_location.is_primary = 1) LEFT JOIN civicrm_address ON civicrm_location.id = civicrm_address.location_id  LEFT JOIN civicrm_state_province ON civicrm_address.state_province_id = civicrm_state_province.id  LEFT JOIN civicrm_country ON civicrm_address.country_id = civicrm_country.id  LEFT JOIN civicrm_email ON (civicrm_location.id = civicrm_email.location_id AND civicrm_email.is_primary = 1)  LEFT JOIN civicrm_phone ON (civicrm_location.id = civicrm_phone.location_id AND civicrm_phone.is_primary = 1)  LEFT JOIN civicrm_im ON (civicrm_location.id = civicrm_im.location_id AND civicrm_im.is_primary = 1)  WHERE  ( contact_a.id = 101 )  LIMIT 0, 25  [nativecode=1054 ** Unknown column 'contact_a.contact_sub_type' in 'field list']
    [to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT contact_a.id as contact_id, contact_a.contact_type as contact_type, contact_a.contact_sub_type  as `contact_sub_type`, contact_a.sort_name as sort_name, contact_a.display_name as display_name, civicrm_individual.id as individual_id, civicrm_individual.first_name as `first_name`, civicrm_individual.middle_name as `middle_name`, civicrm_individual.last_name as `last_name`, civicrm_individual.birth_date as `birth_date`, civicrm_gender.id as gender_id, civicrm_gender.name as `gender`, civicrm_location.id as location_id, civicrm_address.id as address_id, civicrm_address.street_address as `street_address`, civicrm_address.supplemental_address_1 as `supplemental_address_1`, civicrm_address.supplemental_address_2 as `supplemental_address_2`, civicrm_address.city as `city`, civicrm_address.postal_code as `postal_code`, civicrm_address.postal_code_suffix as `postal_code_suffix`, civicrm_address.geo_code_1 as `geo_code_1`, civicrm_address.geo_code_2 as `geo_code_2`, civicrm_state_province.id as state_province_id, civicrm_state_province.abbreviation as `state_province`, civicrm_country.id as country_id, civicrm_country.name as `country`, civicrm_phone.id as phone_id, civicrm_phone.phone_type as phone_type, civicrm_phone.phone as `phone`, civicrm_email.id as email_id, civicrm_email.email as `email`, civicrm_im.id as im_id, civicrm_im.name as `im`, contact_a.legal_identifier  as `legal_identifier`, contact_a.external_identifier  as `external_identifier`, contact_a.nick_name  as `nick_name`, contact_a.home_URL  as `home_URL`, contact_a.preferred_mail_format  as `preferred_mail_format`  FROM civicrm_contact contact_a LEFT JOIN civicrm_individual ON (contact_a.id = civicrm_individual.contact_id)  LEFT JOIN civicrm_gender ON civicrm_individual.gender_id = civicrm_gender.id  LEFT JOIN civicrm_location ON (civicrm_location.entity_table = 'civicrm_contact' AND

Comments

pwolanin’s picture

If I recall, the volunteer module has not been updated for Drupal 4.7, and it probably only works with older versions of CiviCRM. So, your only real option for now is the old CivicSpace distro.

However, I'm led to believe there will be a major new module developed in the next couple month for handling volunteers for large-scale events.

---
Work: BioRAFT

TimmyB’s picture

Thanks for the reply mate :)

Yeah I am aware of the CiviEvent module due to be released in CiviCRM v1.7, which im guessing is still several months away from development. Hence I was hoping to use the Volunteer Module until it is released.

The reason I ask about using the Volunteer Module under D 4.7 is that it was suppose to be successfully ported in the CVS version http://drupal.org/node/60392 and several peoples replies indicate that they have got it to work. However it is unclear what version of CiviCRM to use. I have tried v1.3, 1.5 and 1.6b - but cannot get v1.4.

If anyone out there has got it working under 4.7, please let me know how you go about getting it to work and what versions of the modules you used - im either doing something wrong, using the wrong version of a module or it never really worked.

I tried CivicSpace 0.8.5 and the Volunteer Module worked fine - but as far as I know this is based on Drupal 4.6, and I need several of the 4.7 modules.

The reason I am after the Volunteer Module, is it seems to be the only event module where users can register for an event, an event coordinator can be setup and users with the appropriate permissions can view all the members who have registered for an event.

Thanks for the support guys,

Cheers

Tim