Details
-
Type: Bug
-
Status: Done/Fixed
-
Priority: Minor
-
Resolution: Fixed/Completed
-
Affects Version/s: 4.6.2
-
Fix Version/s: 4.6.3
-
Component/s: Drupal Integration Modules
-
Labels:
-
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)