Details
-
Type: Bug
-
Status: Done/Fixed
-
Priority: Trivial
-
Resolution: Duplicate
-
Affects Version/s: 4.4.3
-
Fix Version/s: 4.4.4
-
Component/s: None
-
Labels:None
Description
On 2 separate DBS I have hit problems installing CiviVolunteer due to the field report_instance.name & report_instance.args not existing. Both databases have been around since before 3.2 when it was added the schema & this is the first time it has appeared to matter. Both on 4.4.3. One has been a Fuzion DB for it's lifetime - the other is new to us
I suspect there are others out there. However, both the ones I hit are now fixed - it may be worth doing an add field if not exists in the upgrade script. Alternatively this might just be one of Mr- Unassigned's good intentions
DB Error: no such field
Error Details
Database Error Code: Unknown column 'name' in 'field list', 1054
Additional Details:
Array
(
[callback] => Array
(
[0] => CRM_Core_Error
[1] => handle
)
[code] => -19
[message] => DB Error: no such field
[mode] => 16
[debug_info] => INSERT INTO `civicrm_report_instance` (`domain_id`, `title`, `report_id`, `name`, `args`, `description`, `permission`, `grouprole`, `form_values`, `is_active`, `email_subject`, `email_to`, `email_cc`, `header`, `footer`, `navigation_id`, `drilldown_id`, `is_reserved`) VALUES
(1, 'Volunteer Report', 'volunteer', NULL, NULL, 'Volunteer Report', 'access CiviReport', NULL, 'a:39:{s:6:"fields";a:10:
s:17:"contact_source_op";s:3:"has";s:20:"contact_source_value";s:0:"";s:19:"contact_assignee_op";s:3:"has";s:22:"contact_assignee_value";s:0:"";s:17:"contact_target_op";s:3:"has";s:20:"contact_target_value";s:0:"";s:15:"current_user_op";s:2:"eq";s:18:"current_user_value";s:1:"0";s:27:"activity_date_time_relative";s:10:"this.month";s:23:"activity_date_time_from";s:0:"";s:21:"activity_date_time_to";s:0:"";s:19:"activity_subject_op";s:3:"has";s:22:"activity_subject_value";s:0:"";s:5:"id_op";s:2:"in";s:8:"id_value";a:0:{}s:12:"status_id_op";s:2:"in";s:15:"status_id_value";a:0:{}s:8:"tagid_op";s:2:"in";s:11:"tagid_value";a:0:{}s:6:"gid_op";s:2:"in";s:9:"gid_value";a:0:{}s:12:"custom_9_min";s:0:"";s:12:"custom_9_max";s:0:"";s:11:"custom_9_op";s:3:"lte";s:14:"custom_9_value";s:0:"";s:13:"custom_10_min";s:0:"";s:13:"custom_10_max";s:0:"";s:12:"custom_10_op";s:3:"lte";s:15:"custom_10_value";s:0:"";s:9:"order_bys";a:2:{i:1;a:2:
{s:6:"column";s:5:"title";s:5:"order";s:3:"ASC";}i:2;a:2:{s:6:"column";s:9:"sort_name";s:5:"order";s:3:"ASC";}}s:11:"description";s:16:"Volunteer Report";s:13:"email_subject";s:0:"";s:8:"email_to";s:0:"";s:8:"email_cc";s:0:"";s:10:"permission";s:17:"access CiviReport";s:9:"parent_id";s:0:"";s:6:"groups";s:0:"";s:11:"instance_id";s:2:"36";}', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0) [nativecode=1054 ** Unknown column 'name' in 'field list']
[type] => DB_Error
[user_info] => INSERT INTO `civicrm_report_instance` (`domain_id`, `title`, `report_id`, `name`, `args`, `description`, `permission`, `grouprole`, `form_values`, `is_active`, `email_subject`, `email_to`, `email_cc`, `header`, `footer`, `navigation_id`, `drilldown_id`, `is_reserved`) VALUES
(1, 'Volunteer Report', 'volunteer', NULL, NULL, 'Volunteer Report', 'access CiviReport', NULL, 'a:39:{s:6:"fields";a:10:
s:17:"contact_source_op";s:3:"has";s:20:"contact_source_value";s:0:"";s:19:"contact_assignee_op";s:3:"has";s:22:"contact_assignee_value";s:0:"";s:17:"contact_target_op";s:3:"has";s:20:"contact_target_value";s:0:"";s:15:"current_user_op";s:2:"eq";s:18:"current_user_value";s:1:"0";s:27:"activity_date_time_relative";s:10:"this.month";s:23:"activity_date_time_from";s:0:"";s:21:"activity_date_time_to";s:0:"";s:19:"activity_subject_op";s:3:"has";s:22:"activity_subject_value";s:0:"";s:5:"id_op";s:2:"in";s:8:"id_value";a:0:{}s:12:"status_id_op";s:2:"in";s:15:"status_id_value";a:0:{}s:8:"tagid_op";s:2:"in";s:11:"tagid_value";a:0:{}s:6:"gid_op";s:2:"in";s:9:"gid_value";a:0:{}s:12:"custom_9_min";s:0:"";s:12:"custom_9_max";s:0:"";s:11:"custom_9_op";s:3:"lte";s:14:"custom_9_value";s:0:"";s:13:"custom_10_min";s:0:"";s:13:"custom_10_max";s:0:"";s:12:"custom_10_op";s:3:"lte";s:15:"custom_10_value";s:0:"";s:9:"order_bys";a:2:{i:1;a:2:
{s:6:"column";s:5:"title";s:5:"order";s:3:"ASC";}i:2;a:2:{s:6:"column";s:9:"sort_name";s:5:"order";s:3:"ASC";}}s:11:"description";s:16:"Volunteer Report";s:13:"email_subject";s:0:"";s:8:"email_to";s:0:"";s:8:"email_cc";s:0:"";s:10:"permission";s:17:"access CiviReport";s:9:"parent_id";s:0:"";s:6:"groups";s:0:"";s:11:"instance_id";s:2:"36";}', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0) [nativecode=1054 ** Unknown column 'name' in 'field list']
[to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO `civicrm_report_instance` (`domain_id`, `title`, `report_id`, `name`, `args`, `description`, `permission`, `grouprole`, `form_values`, `is_active`, `email_subject`, `email_to`, `email_cc`, `header`, `footer`, `navigation_id`, `drilldown_id`, `is_reserved`) VALUES
(1, 'Volunteer Report', 'volunteer', NULL, NULL, 'Volunteer Report', 'access CiviReport', NULL, 'a:39:{s:6:"fields";a:10:
s:17:"contact_source_op";s:3:"has";s:20:"contact_source_value";s:0:"";s:19:"contact_assignee_op";s:3:"has";s:22:"contact_assignee_value";s:0:"";s:17:"contact_target_op";s:3:"has";s:20:"contact_target_value";s:0:"";s:15:"current_user_op";s:2:"eq";s:18:"current_user_value";s:1:"0";s:27:"activity_date_time_relative";s:10:"this.month";s:23:"activity_date_time_from";s:0:"";s:21:"activity_date_time_to";s:0:"";s:19:"activity_subject_op";s:3:"has";s:22:"activity_subject_value";s:0:"";s:5:"id_op";s:2:"in";s:8:"id_value";a:0:{}s:12:"status_id_op";s:2:"in";s:15:"status_id_value";a:0:{}s:8:"tagid_op";s:2:"in";s:11:"tagid_value";a:0:{}s:6:"gid_op";s:2:"in";s:9:"gid_value";a:0:{}s:12:"custom_9_min";s:0:"";s:12:"custom_9_max";s:0:"";s:11:"custom_9_op";s:3:"lte";s:14:"custom_9_value";s:0:"";s:13:"custom_10_min";s:0:"";s:13:"custom_10_max";s:0:"";s:12:"custom_10_op";s:3:"lte";s:15:"custom_10_value";s:0:"";s:9:"order_bys";a:2:{i:1;a:2:
{s:6:"column";s:5:"title";s:5:"order";s:3:"ASC";}i:2;a:2:{s:6:"column";s:9:"sort_name";s:5:"order";s:3:"ASC";}}s:11:"description";s:16:"Volunteer Report";s:13:"email_subject";s:0:"";s:8:"email_to";s:0:"";s:8:"email_cc";s:0:"";s:10:"permission";s:17:"access CiviReport";s:9:"parent_id";s:0:"";s:6:"groups";s:0:"";s:11:"instance_id";s:2:"36";}', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0) [nativecode=1054 ** Unknown column 'name' in 'field list']"]
)