Problema CiviCase durante la visualizzazione del file del caso

Aug 20 2020

Ho un grosso problema con Civicase,

Ogni volta che provo a visualizzare o cercare un file del caso, ricevo un errore. Non ho problemi a creare nuovi file di caso, non ho problemi a creare nuovi tipi di caso, ma nel momento in cui provo a rivedere un file di caso ricevo un errore

Questo è il backTrace

#0 /home2/blahblah/public_html/sites/all/modules/civicrm/CRM/Core/Error.php(148): CRM_Core_Error::backtrace()
#1 /home2/blahblah/public_html/sites/all/modules/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php(922): CRM_Core_Error::handle(Object(DB_Error))
#2 /home2/blahblah/public_html/sites/all/modules/civicrm/packages/DB.php(997): PEAR_Error->__construct("DB Error: unknown error", -1, 16, (Array:2), " SELECT COUNT(*) FROM (SELECT civicrm_case.id as case_id, civicrm_case.subjec...")
#3 /home2/blahblah/public_html/sites/all/modules/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php(575): DB_Error->__construct(-1, 16, (Array:2), " SELECT COUNT(*) FROM (SELECT civicrm_case.id as case_id, civicrm_case.subjec...")
#4 /home2/blahblah/public_html/sites/all/modules/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php(223): PEAR->_raiseError(Object(DB_mysqli), NULL, -1, 16, (Array:2), " SELECT COUNT(*) FROM (SELECT civicrm_case.id as case_id, civicrm_case.subjec...", "DB_Error", TRUE)
#5 /home2/blahblah/public_html/sites/all/modules/civicrm/packages/DB/common.php(1925): PEAR->__call("raiseError", (Array:7))
#6 /home2/blahblah/public_html/sites/all/modules/civicrm/packages/DB/mysqli.php(936): DB_common->raiseError(-1, NULL, NULL, " SELECT COUNT(*) FROM (SELECT civicrm_case.id as case_id, civicrm_case.subjec...", "1045 ** Access denied for user 'bvitrave_advisor'@'localhost' (using password...")
#7 /home2/blahblah/public_html/sites/all/modules/civicrm/packages/DB/mysqli.php(406): DB_mysqli->mysqliRaiseError()
#8 /home2/blahblah/public_html/sites/all/modules/civicrm/packages/DB/common.php(1231): DB_mysqli->simpleQuery(" SELECT COUNT(*) FROM (SELECT civicrm_case.id as case_id, civicrm_case.subjec...")
#9 /home2/blahblah/public_html/sites/all/modules/civicrm/packages/DB/DataObject.php(2696): DB_common->query(" SELECT COUNT(*) FROM (SELECT civicrm_case.id as case_id, civicrm_case.subjec...")
#10 /home2/blahblah/public_html/sites/all/modules/civicrm/packages/DB/DataObject.php(1829): DB_DataObject->_query(" SELECT COUNT(*) FROM (SELECT civicrm_case.id as case_id, civicrm_case.subjec...")
#11 /home2/blahblah/public_html/sites/all/modules/civicrm/CRM/Core/DAO.php(439): DB_DataObject->query(" SELECT COUNT(*) FROM (SELECT civicrm_case.id as case_id, civicrm_case.subjec...")
#12 /home2/blahblah/public_html/sites/all/modules/civicrm/CRM/Core/DAO.php(1599): CRM_Core_DAO->query(" SELECT COUNT(*) FROM (SELECT civicrm_case.id as case_id, civicrm_case.subjec...", TRUE)
#13 /home2/blahblah/public_html/sites/all/modules/civicrm/CRM/Case/BAO/Case.php(537): CRM_Core_DAO::singleValueQuery(" SELECT COUNT(*) FROM (SELECT civicrm_case.id as case_id, civicrm_case.subjec...")
#14 /home2/blahblah/public_html/sites/all/modules/civicrm/CRM/Case/Page/DashBoard.php(71): CRM_Case_BAO_Case::getCases(NULL, (Array:0), "dashboard", TRUE)
#15 /home2/blahblah/public_html/sites/all/modules/civicrm/CRM/Case/Page/DashBoard.php(100): CRM_Case_Page_DashBoard->preProcess()
#16 /home2/blahblah/public_html/sites/all/modules/civicrm/CRM/Core/Invoke.php(312): CRM_Case_Page_DashBoard->run((Array:2), NULL)
#17 /home2/blahblah/public_html/sites/all/modules/civicrm/CRM/Core/Invoke.php(68): CRM_Core_Invoke::runItem((Array:15))
#18 /home2/blahblah/public_html/sites/all/modules/civicrm/CRM/Core/Invoke.php(36): CRM_Core_Invoke::_invoke((Array:2))
#19 /home2/blahblah/public_html/sites/all/modules/civicrm/drupal/civicrm.module(454): CRM_Core_Invoke::invoke((Array:2))
#20 /home2/blahblah/public_html/includes/menu.inc(527): civicrm_invoke("case")
#21 /home2/blahblah/public_html/index.php(21): menu_execute_active_handler()
#22 {main}

Sulla base del traceroute, si dice che l'accesso al mio nome utente / password SQL è negato. Ma non riesco a capire perché ciò si verifica solo quando tento di visualizzare un file di caso ... Per favore, aiutami

Risposte

Demerit Aug 20 2020 at 23:37

Sono abbastanza sicuro che sia perché il proprietario delle viste del database è un utente del database diverso (forse ti sei spostato o importato da qualche parte?). CiviCase utilizza le viste mysql.