0

Our CiviCRM has developed an issue with the Case extension. We can create new cases, we can use advanced search and search for information but we can't access the case dashboard.

The case tab from the contact summary page and we get an error: "Can't connect to network" from the case find. I have restored from two previous backups but the issues remain.

Here is my backTrace for further investigation:

#0 /home/brpcvshome/domains/thecvs.org.uk/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/Error.php(192): CRM_Core_Error::backtrace()
#1 /home/brpcvshome/domains/thecvs.org.uk/public_html/administrator/components/com_civicrm/civicrm/packages/PEAR.php(921): CRM_Core_Error::handle(Object(DB_Error))
#2 /home/brpcvshome/domains/thecvs.org.uk/public_html/administrator/components/com_civicrm/civicrm/packages/DB.php(985): PEAR_Error->__construct("DB Error: no such table", -18, 16, (Array:2), " SELECT COUNT(*) FROM (SELECT civicrm_case.id as case_id, civicrm_case.subjec...")
#3 /home/brpcvshome/domains/thecvs.org.uk/public_html/administrator/components/com_civicrm/civicrm/packages/PEAR.php(575): DB_Error->__construct(-18, 16, (Array:2), " SELECT COUNT(*) FROM (SELECT civicrm_case.id as case_id, civicrm_case.subjec...")
#4 /home/brpcvshome/domains/thecvs.org.uk/public_html/administrator/components/com_civicrm/civicrm/packages/PEAR.php(223): PEAR->_raiseError(Object(DB_mysqli), NULL, -18, 16, (Array:2), " SELECT COUNT(*) FROM (SELECT civicrm_case.id as case_id, civicrm_case.subjec...", "DB_Error", TRUE)
#5 /home/brpcvshome/domains/thecvs.org.uk/public_html/administrator/components/com_civicrm/civicrm/packages/DB/common.php(1907): PEAR->__call("raiseError", (Array:7))
#6 /home/brpcvshome/domains/thecvs.org.uk/public_html/administrator/components/com_civicrm/civicrm/packages/DB/mysqli.php(933): DB_common->raiseError(-18, NULL, NULL, " SELECT COUNT(*) FROM (SELECT civicrm_case.id as case_id, civicrm_case.subjec...", "1146 ** Table 'brpcvshome_cvs.civicrm_view_case_activity_upcoming' doesn't exist")
#7 /home/brpcvshome/domains/thecvs.org.uk/public_html/administrator/components/com_civicrm/civicrm/packages/DB/mysqli.php(403): DB_mysqli->mysqliRaiseError()
#8 /home/brpcvshome/domains/thecvs.org.uk/public_html/administrator/components/com_civicrm/civicrm/packages/DB/common.php(1216): DB_mysqli->simpleQuery(" SELECT COUNT(*) FROM (SELECT civicrm_case.id as case_id, civicrm_case.subjec...")
#9 /home/brpcvshome/domains/thecvs.org.uk/public_html/administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php(2415): DB_common->query(" SELECT COUNT(*) FROM (SELECT civicrm_case.id as case_id, civicrm_case.subjec...")
#10 /home/brpcvshome/domains/thecvs.org.uk/public_html/administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php(1607): DB_DataObject->_query(" SELECT COUNT(*) FROM (SELECT civicrm_case.id as case_id, civicrm_case.subjec...")
#11 /home/brpcvshome/domains/thecvs.org.uk/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/DAO.php(439): DB_DataObject->query(" SELECT COUNT(*) FROM (SELECT civicrm_case.id as case_id, civicrm_case.subjec...")
#12 /home/brpcvshome/domains/thecvs.org.uk/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/DAO.php(1491): CRM_Core_DAO->query(" SELECT COUNT(*) FROM (SELECT civicrm_case.id as case_id, civicrm_case.subjec...", TRUE)
#13 /home/brpcvshome/domains/thecvs.org.uk/public_html/administrator/components/com_civicrm/civicrm/CRM/Case/BAO/Case.php(639): CRM_Core_DAO::singleValueQuery(" SELECT COUNT(*) FROM (SELECT civicrm_case.id as case_id, civicrm_case.subjec...")
#14 /home/brpcvshome/domains/thecvs.org.uk/public_html/administrator/components/com_civicrm/civicrm/CRM/Case/Page/DashBoard.php(87): CRM_Case_BAO_Case::getCases(NULL, (Array:0), "dashboard", TRUE)
#15 /home/brpcvshome/domains/thecvs.org.uk/public_html/administrator/components/com_civicrm/civicrm/CRM/Case/Page/DashBoard.php(116): CRM_Case_Page_DashBoard->preProcess()
#16 /home/brpcvshome/domains/thecvs.org.uk/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php(311): CRM_Case_Page_DashBoard->run((Array:2), NULL)
#17 /home/brpcvshome/domains/thecvs.org.uk/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php(85): CRM_Core_Invoke::runItem((Array:15))
#18 /home/brpcvshome/domains/thecvs.org.uk/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:2))
#19 /home/brpcvshome/domains/thecvs.org.uk/public_html/administrator/components/com_civicrm/civicrm.php(121): CRM_Core_Invoke::invoke((Array:2))
#20 /home/brpcvshome/domains/thecvs.org.uk/public_html/administrator/components/com_civicrm/civicrm.php(40): civicrm_invoke()
#21 /home/brpcvshome/domains/thecvs.org.uk/public_html/libraries/src/Component/ComponentHelper.php(402): require_once("/home/brpcvshome/domains/thecvs.org.uk/public_html/administrator/components/c...")
#22 /home/brpcvshome/domains/thecvs.org.uk/public_html/libraries/src/Component/ComponentHelper.php(377): Joomla\CMS\Component\ComponentHelper::executeComponent("/home/brpcvshome/domains/thecvs.org.uk/public_html/administrator/components/c...")
#23 /home/brpcvshome/domains/thecvs.org.uk/public_html/libraries/src/Application/AdministratorApplication.php(101): Joomla\CMS\Component\ComponentHelper::renderComponent("com_civicrm")
#24 /home/brpcvshome/domains/thecvs.org.uk/public_html/libraries/src/Application/AdministratorApplication.php(159): Joomla\CMS\Application\AdministratorApplication->dispatch()
#25 /home/brpcvshome/domains/thecvs.org.uk/public_html/libraries/src/Application/CMSApplication.php(196): Joomla\CMS\Application\AdministratorApplication->doExecute()
#26 /home/brpcvshome/domains/thecvs.org.uk/public_html/administrator/index.php(51): Joomla\

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.