CiviCRM Community Forums (archive)

I've upgraded, all seemed fine - Then my board reports all disappeared. Looking at the views I see that there is a string of missing handlers for all custom data.

civicrm_value_volunteer_activity_review_fields_11 > school_66 doesn't exist!
Error: handler for civicrm_value_volunteer_activity_review_fields_11 > business_partner_67 doesn't exist!
Error: handler for civicrm_value_volunteer_activity_review_fields_11 > programme_33 doesn't exist!
Error: handler for civicrm_value_volunteer_activity_review_fields_11 > number_of_volunteers_35 doesn't exist!
Error: handler for civicrm_value_volunteer_activity_review_fields_11 > number_of_pupils_36 doesn't exist!

These are handlers for custom data items on an activity type.

the view lists and groups numbers and comments from the activity. - a basic activity report - so many volunteers from x company  y school impacting n students - all grouped by programme

Since Views can't handle grouped sub-totals the header of the view has a block of php code that references the same fields and creates a summary:

<?php

$query = "SELECT programme_33, SUM(number_of_volunteers_35) AS 'volunteers', SUM(number_of_pupils_36) AS 'pupils'
FROM {civicrm_value_volunteer_activity_review_fields_11}
WHERE current_best_figures__31 <> 0
GROUP BY programme_33";
   
$result = db_query($query);

// Print out result
//print ' v = volunteers; p = pupils'
while($row = db_fetch_object($result)){
   print l($row->programme_33 . ' has ' . $row->volunteers . '  volunteers serving ' .$row->pupils .' pupils');
   print '<br />';
}

This code works still - just the handlers in the views integration module seems to be missing.

I have:

• Checked that the civicrm views module is still there  
• Cleared the views cache
• Checked the db_prefix array in the settings file is still correct

I'm supposed to be going away on holiday tomorrow hence the panic!

If anyone has a good idea, please share!