Details
-
Type:
Bug
-
Status: Done/Fixed
-
Priority:
Trivial
-
Resolution: Cannot Reproduce
-
Affects Version/s: 4.6.2
-
Fix Version/s: None
-
Component/s: CiviEvent, Core CiviCRM
-
Labels:None
-
Documentation Required?:None
Description
Upgraded from 4.4.14 to 4.6.2
When click on the participant name from "Counted" link in Events dashboards, returns "DB Error: No Such Fields". Log from civicrm Below.
EDIT: Its happening using contact link from search result too.
EDIT 1: I was able to create the same error in another install.
Apr 20 09:25:03 [info] Ignoring exception thrown by nullHandler: -2, DB Error: syntax error
Apr 20 09:25:03 [info] $backTrace = #0 /www/demo/sites/all/modules/civicrm/CRM/Core/Error.php(908): CRM_Core_Error::backtrace("backTrace", TRUE)
#1 [internal function](): CRM_Core_Error::nullHandler(Object(DB_Error))
#2 /www/demo/sites/all/modules/civicrm/packages/PEAR.php(931): call_user_func((Array:2), Object(DB_Error))
#3 /www/demo/sites/all/modules/civicrm/packages/DB.php(976): PEAR_Error->PEAR_Error("DB Error: syntax error", -2, 16, (Array:2), "\nINSERT INTO civicrm_prevnext_cache ( entity_table, entity_id1, entity_id2, ...")
#4 /www/demo/sites/all/modules/civicrm/packages/PEAR.php(564): DB_Error->DB_Error(-2, 16, (Array:2), "\nINSERT INTO civicrm_prevnext_cache ( entity_table, entity_id1, entity_id2, ...")
#5 /www/demo/sites/all/modules/civicrm/packages/DB/common.php(1905): PEAR->raiseError(NULL, -2, NULL, NULL, "\nINSERT INTO civicrm_prevnext_cache ( entity_table, entity_id1, entity_id2, ...", "DB_Error", TRUE)
#6 /www/demo/sites/all/modules/civicrm/packages/DB/mysql.php(899): DB_common->raiseError(-2, NULL, NULL, NULL, "1064 ** You have an error in your SQL syntax; check the manual that correspon...")
#7 /www/demo/sites/all/modules/civicrm/packages/DB/mysql.php(328): DB_mysql->mysqlRaiseError()
#8 /www/demo/sites/all/modules/civicrm/packages/DB/common.php(1216): DB_mysql->simpleQuery("\nINSERT INTO civicrm_prevnext_cache ( entity_table, entity_id1, entity_id2, ...")
#9 /www/demo/sites/all/modules/civicrm/packages/DB/DataObject.php(2442): DB_common->query("\nINSERT INTO civicrm_prevnext_cache ( entity_table, entity_id1, entity_id2, ...")
#10 /www/demo/sites/all/modules/civicrm/packages/DB/DataObject.php(1634): DB_DataObject->_query("\nINSERT INTO civicrm_prevnext_cache ( entity_table, entity_id1, entity_id2, ...")
#11 /www/demo/sites/all/modules/civicrm/CRM/Core/DAO.php(325): DB_DataObject->query("\nINSERT INTO civicrm_prevnext_cache ( entity_table, entity_id1, entity_id2, ...")
#12 /www/demo/sites/all/modules/civicrm/CRM/Core/DAO.php(1179): CRM_Core_DAO->query("\nINSERT INTO civicrm_prevnext_cache ( entity_table, entity_id1, entity_id2, ...", TRUE)
#13 /www/demo/sites/all/modules/civicrm/CRM/Contact/Selector.php(1041): CRM_Core_DAO::executeQuery("\nINSERT INTO civicrm_prevnext_cache ( entity_table, entity_id1, entity_id2, ...")
#14 /www/demo/sites/all/modules/civicrm/CRM/Contact/Selector.php(893): CRM_Contact_Selector->fillupPrevNextCache(Object(CRM_Utils_Sort), "civicrm search 4ac379396330813776e7e251ac6cc64b_3247", 0, 500)
#15 /www/demo/sites/all/modules/civicrm/CRM/Contact/Selector/Custom.php(367): CRM_Contact_Selector->buildPrevNextCache(Object(CRM_Utils_Sort))
#16 /www/demo/sites/all/modules/civicrm/CRM/Core/Selector/Controller.php(403): CRM_Contact_Selector_Custom->getRows(4, 0, 50, Object(CRM_Utils_Sort), 1, NULL)
#17 /www/demo/sites/all/modules/civicrm/CRM/Core/Selector/Controller.php(340): CRM_Core_Selector_Controller->getRows(Object(CRM_Contact_Selector_Controller))
#18 /www/demo/sites/all/modules/civicrm/CRM/Contact/Form/Search.php(876): CRM_Core_Selector_Controller->run()
#19 /www/demo/sites/all/modules/civicrm/CRM/Contact/Form/Search/Custom.php(171): CRM_Contact_Form_Search->postProcess()
#20 /www/demo/sites/all/modules/civicrm/CRM/Contact/Form/Search.php(716): CRM_Contact_Form_Search_Custom->postProcess()
#21 /www/demo/sites/all/modules/civicrm/CRM/Contact/Form/Search/Custom.php(83): CRM_Contact_Form_Search->preProcess()
#22 /www/demo/sites/all/modules/civicrm/CRM/Core/Form.php(455): CRM_Contact_Form_Search_Custom->preProcess()
#23 /www/demo/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Display.php(94): CRM_Core_Form->buildForm()
#24 /www/demo/sites/all/modules/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Display->perform(Object(CRM_Contact_Form_Search_Custom), "display")
#25 /www/demo/sites/all/modules/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Contact_Form_Search_Custom), "display")
#26 /www/demo/sites/all/modules/civicrm/CRM/Core/Controller.php(353): HTML_QuickForm_Page->handle("display")
#27 /www/demo/sites/all/modules/civicrm/CRM/Core/Invoke.php(312): CRM_Core_Controller->run((Array:4), (Array:0))
#28 /www/demo/sites/all/modules/civicrm/CRM/Core/Invoke.php(86): CRM_Core_Invoke::runItem((Array:12))
#29 /www/demo/sites/all/modules/civicrm/CRM/Core/Invoke.php(54): CRM_Core_Invoke::_invoke((Array:4))
#30 /www/demo/sites/all/modules/civicrm/drupal/civicrm.module(489): CRM_Core_Invoke::invoke((Array:4))
#31 [internal function](): civicrm_invoke("contact", "search", "custom")
#32 /www/demo/includes/menu.inc(519): call_user_func_array("civicrm_invoke", (Array:3))
#33 /www/demo/index.php(21): menu_execute_active_handler()
#34