Uploaded image for project: 'CiviCRM'
  1. CiviCRM
  2. CRM-14116

old dbs missing report_instance.name field

    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:16:"contact_assignee";s:1:"1";s:14:"contact_target";s:1:"0";s:7:"project";s:1:"1";s:16:"activity_type_id";s:1:"1";s:16:"activity_subject";s:1:"1";s:18:"activity_date_time";s:1:"1";s:9:"status_id";s:1:"1";s:4:"role";s:1:"1";s:14:"time_scheduled";s:1:"1";s:14:"time_completed";s:1:"1";}

      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:16:"contact_assignee";s:1:"1";s:14:"contact_target";s:1:"0";s:7:"project";s:1:"1";s:16:"activity_type_id";s:1:"1";s:16:"activity_subject";s:1:"1";s:18:"activity_date_time";s:1:"1";s:9:"status_id";s:1:"1";s:4:"role";s:1:"1";s:14:"time_scheduled";s:1:"1";s:14:"time_completed";s:1:"1";}

      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:16:"contact_assignee";s:1:"1";s:14:"contact_target";s:1:"0";s:7:"project";s:1:"1";s:16:"activity_type_id";s:1:"1";s:16:"activity_subject";s:1:"1";s:18:"activity_date_time";s:1:"1";s:9:"status_id";s:1:"1";s:4:"role";s:1:"1";s:14:"time_scheduled";s:1:"1";s:14:"time_completed";s:1:"1";}

      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']"]
      )

        Attachments

          Activity

            People

            • Assignee:
              dgg David Greenberg
              Reporter:
              eileen Eileen McNaughton
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: