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

Fatal error on case views on upgrade

    Details

    • Documentation Required?:
      None

      Description

      This appears to be an error in the views specification causing it to look for Label rather than Title

      Database Error Code: Unknown column 'Label' 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] => SELECT id, Label
      FROM civicrm_case_type

      ORDER BY weight
      [nativecode=1054 ** Unknown column 'Label' in 'field list']
      [type] => DB_Error
      [user_info] => SELECT id, Label
      FROM civicrm_case_type

      ORDER BY weight
      [nativecode=1054 ** Unknown column 'Label' 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 id, Label
      FROM civicrm_case_type

      ORDER BY weight
      [nativecode=1054 ** Unknown column 'Label' in 'field list']"]
      )
      backTrace

      #0 /srv/www/fuzion/demo.fuzion.co.nz/sites/all/modules/civicrm/CRM/Core/Error.php(182): CRM_Core_Error::backtrace()
      #1 [internal function](): CRM_Core_Error::handle(Object(DB_Error))
      #2 /srv/www/fuzion/demo.fuzion.co.nz/sites/all/modules/civicrm/packages/PEAR.php(931): call_user_func((Array:2), Object(DB_Error))
      #3 /srv/www/fuzion/demo.fuzion.co.nz/sites/all/modules/civicrm/packages/DB.php(976): PEAR_Error->PEAR_Error("DB Error: no such field", -19, 16, (Array:2), "SELECT id, Label \n FROM civicrm_case_type \n \n \n \n \n ORDER BY weight ...")
      #4 /srv/www/fuzion/demo.fuzion.co.nz/sites/all/modules/civicrm/packages/PEAR.php(564): DB_Error->DB_Error(-19, 16, (Array:2), "SELECT id, Label \n FROM civicrm_case_type \n \n \n \n \n ORDER BY weight ...")
      #5 /srv/www/fuzion/demo.fuzion.co.nz/sites/all/modules/civicrm/packages/DB/common.php(1905): PEAR->raiseError(NULL, -19, NULL, NULL, "SELECT id, Label \n FROM civicrm_case_type \n \n \n \n \n ORDER BY weight ...", "DB_Error", TRUE)
      #6 /srv/www/fuzion/demo.fuzion.co.nz/sites/all/modules/civicrm/packages/DB/mysql.php(899): DB_common->raiseError(-19, NULL, NULL, NULL, "1054 ** Unknown column 'Label' in 'field list'")
      #7 /srv/www/fuzion/demo.fuzion.co.nz/sites/all/modules/civicrm/packages/DB/mysql.php(328): DB_mysql->mysqlRaiseError()
      #8 /srv/www/fuzion/demo.fuzion.co.nz/sites/all/modules/civicrm/packages/DB/common.php(1216): DB_mysql->simpleQuery("SELECT id, Label \n FROM civicrm_case_type \n \n \n \n \n ORDER BY weight \n")
      #9 /srv/www/fuzion/demo.fuzion.co.nz/sites/all/modules/civicrm/packages/DB/DataObject.php(2442): DB_common->query("SELECT id, Label \n FROM civicrm_case_type \n \n \n \n \n ORDER BY weight \n")
      #10 /srv/www/fuzion/demo.fuzion.co.nz/sites/all/modules/civicrm/packages/DB/DataObject.php(441): DB_DataObject->_query("SELECT id, Label \n FROM civicrm_case_type \n \n \n \n \n ORDER BY weight \n")
      #11 /srv/www/fuzion/demo.fuzion.co.nz/sites/all/modules/civicrm/CRM/Core/PseudoConstant.php(590): DB_DataObject->find()
      #12 /srv/www/fuzion/demo.fuzion.co.nz/sites/all/modules/civicrm/CRM/Case/PseudoConstant.php(156): CRM_Core_PseudoConstant::populate(NULL, "CRM_Case_DAO_CaseType", TRUE, "Label", "", NULL, "weight", "id")
      #13 [internal function](): CRM_Case_PseudoConstant::caseType("Label", FALSE)
      #14 /srv/www/fuzion/demo.fuzion.co.nz/sites/all/modules/civicrm/drupal/modules/views/civicrm/civicrm_handler_filter_pseudo_constant.inc(58): call_user_func_array("CRM_Case_PseudoConstant::caseType", (Array:2))
      #15 /srv/www/fuzion/demo.fuzion.co.nz/sites/all/modules/views/includes/handlers.inc(65): civicrm_handler_filter_pseudo_constant->construct()
      #16 /srv/www/fuzion/demo.fuzion.co.nz/sites/all/modules/views/includes/handlers.inc(87): _views_create_handler((Array:8), "handler", "filter")
      #17 /srv/www/fuzion/demo.fuzion.co.nz/sites/all/modules/views/views.module(1257): _views_prepare_handler((Array:4), (Array:21), "case_type", "filter")
      #18 /srv/www/fuzion/demo.fuzion.co.nz/sites/all/modules/date/date_views/includes/date_views_fields.inc(57): views_get_handler("civicrm_case", "case_type", "filter")
      #19 /srv/www/fuzion/demo.fuzion.co.nz/sites/all/modules/date/date_views/date_views.module(135): _date_views_fields("civicrm_relationship")
      #20 /srv/www/fuzion/demo.fuzion.co.nz/sites/all/modules/calendar/includes/calendar.views_template.inc(33): date_views_fields("civicrm_relationship")
      #21 /srv/www/fuzion/demo.fuzion.co.nz/sites/all/modules/views/views.module(1382): calendar_views_templates()
      #22 /srv/www/fuzion/demo.fuzion.co.nz/sites/all/modules/views/views_ui.module(33): views_get_all_templates()
      #23 [internal function](): views_ui_menu()
      #24 /srv/www/fuzion/demo.fuzion.co.nz/includes/menu.inc(2784): call_user_func("views_ui_menu")
      #25 /srv/www/fuzion/demo.fuzion.co.nz/includes/menu.inc(2747): menu_router_build()
      #26 /srv/www/fuzion/demo.fuzion.co.nz/includes/menu.inc(460): menu_rebuild()
      #27 /srv/www/fuzion/demo.fuzion.co.nz/includes/menu.inc(1757): menu_get_item()
      #28 /srv/www/fuzion/demo.fuzion.co.nz/includes/menu.inc(1772): menu_get_custom_theme(TRUE)
      #29 /srv/www/fuzion/demo.fuzion.co.nz/includes/common.inc(5243): menu_set_custom_theme()
      #30 /srv/www/fuzion/demo.fuzion.co.nz/includes/bootstrap.inc(2262): _drupal_bootstrap_full()
      #31 /srv/www/fuzion/demo.fuzion.co.nz/index.php(20): drupal_bootstrap(7)

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved: