DB and CiviCRM Errors with Volunteer Module under Drupal 4.7
TimmyB - December 14, 2006 - 10:13
| Project: | volunteer |
| Version: | HEAD |
| Component: | Code |
| Category: | bug report |
| Priority: | critical |
| Assigned: | Unassigned |
| Status: | active |
Jump to:
Description
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)
>>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
#1