Fatal error when searching a contact
On CiviCRM 5.69.1 when I do a simple contact search I get this error and can't see the contact
$Fatal Error Details = array:3 [
"message" => """
Unexpected result from getcountArray\n
(\n
[error_code] => -2\n
[sql] => \n
[debug_info] => SELECT count(*) as c\n
FROM civicrm_activity a\n
LEFT JOIN civicrm_case_activity actjoin_case_id ON (actjoin_case_id.activity_id = a.id)\n
WHERE (((`a`.`activity_type_id` Array)))\n
AND (a.id IN (SELECT activity_id FROM civicrm_activity_contact WHERE contact_id = "27478"))\n
AND (actjoin_case_id.case_id IS NULL)\n
AND (a.is_current_revision = "1")\n
AND (a.activity_type_id IN ("1", "55", "56", "57", "58", "59", "70", "71", "2", "3", "4", "5", "6", "7", "8", "9", "10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20", "21", "22", "23", "24", "25", "26", "27", "28", "29", "30", "31", "32", "33", "34", "35", "36", "37", "38", "39", "40", "41", "44", "45", "46", "47", "48", "49", "50", "51", "52", "53", "54", "60", "61", "62", "63", "64", "65", "66", "67", "68", "69", "72", "73", "74", "75", "76", "77", "78", "80", "82", "84", "86", "88", "89"))\n
AND (a.is_test = "0")\n
AND (a.is_deleted = "0")\n
[nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'Array)))\n
AND (a.id IN (SELECT activity_id FROM civicrm_activity_contact WHE...' at line 4]\n
[entity] => Activity\n
[action] => get\n
[is_error] => 1\n
[error_message] => case_id is not valid : 1\n
[debug_information] => \n
)\n
"""
"code" => null
"exception" => CRM_Core_Exception {#36862
-errorData: array:5 [
"error_code" => 0
"entity" => "Activity"
"action" => "getcount"
"is_error" => 1
"error_message" => """
Unexpected result from getcountArray\n
(\n
[error_code] => -2\n
[sql] => \n
[debug_info] => SELECT count(*) as c\n
FROM civicrm_activity a\n
LEFT JOIN civicrm_case_activity actjoin_case_id ON (actjoin_case_id.activity_id = a.id)\n
WHERE (((`a`.`activity_type_id` Array)))\n
AND (a.id IN (SELECT activity_id FROM civicrm_activity_contact WHERE contact_id = "27478"))\n
AND (actjoin_case_id.case_id IS NULL)\n
AND (a.is_current_revision = "1")\n
AND (a.activity_type_id IN ("1", "55", "56", "57", "58", "59", "70", "71", "2", "3", "4", "5", "6", "7", "8", "9", "10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20", "21", "22", "23", "24", "25", "26", "27", "28", "29", "30", "31", "32", "33", "34", "35", "36", "37", "38", "39", "40", "41", "44", "45", "46", "47", "48", "49", "50", "51", "52", "53", "54", "60", "61", "62", "63", "64", "65", "66", "67", "68", "69", "72", "73", "74", "75", "76", "77", "78", "80", "82", "84", "86", "88", "89"))\n
AND (a.is_test = "0")\n
AND (a.is_deleted = "0")\n
[nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'Array)))\n
AND (a.id IN (SELECT activity_id FROM civicrm_activity_contact WHE...' at line 4]\n
[entity] => Activity\n
[action] => get\n
[is_error] => 1\n
[error_message] => case_id is not valid : 1\n
[debug_information] => \n
)\n
"""
]
#cause: null
-_trace: null
#message: """
Unexpected result from getcountArray\n
(\n
[error_code] => -2\n
[sql] => \n
[debug_info] => SELECT count(*) as c\n
FROM civicrm_activity a\n
LEFT JOIN civicrm_case_activity actjoin_case_id ON (actjoin_case_id.activity_id = a.id)\n
WHERE (((`a`.`activity_type_id` Array)))\n
AND (a.id IN (SELECT activity_id FROM civicrm_activity_contact WHERE contact_id = "27478"))\n
AND (actjoin_case_id.case_id IS NULL)\n
AND (a.is_current_revision = "1")\n
AND (a.activity_type_id IN ("1", "55", "56", "57", "58", "59", "70", "71", "2", "3", "4", "5", "6", "7", "8", "9", "10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20", "21", "22", "23", "24", "25", "26", "27", "28", "29", "30", "31", "32", "33", "34", "35", "36", "37", "38", "39", "40", "41", "44", "45", "46", "47", "48", "49", "50", "51", "52", "53", "54", "60", "61", "62", "63", "64", "65", "66", "67", "68", "69", "72", "73", "74", "75", "76", "77", "78", "80", "82", "84", "86", "88", "89"))\n
AND (a.is_test = "0")\n
AND (a.is_deleted = "0")\n
[nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'Array)))\n
AND (a.id IN (SELECT activity_id FROM civicrm_activity_contact WHE...' at line 4]\n
[entity] => Activity\n
[action] => get\n
[is_error] => 1\n
[error_message] => case_id is not valid : 1\n
[debug_information] => \n
)\n
"""
#code: 0
#file: "/var/www/vhosts/domain/httpdocs/wp-content/plugins/civicrm/civicrm/api/api.php"
#line: 138
trace: {
/var/www/vhosts/domain/httpdocs/wp-content/plugins/civicrm/civicrm/api/api.php:138 {
civicrm_api3(string $entity, string $action, array $params = [])
› if (is_array($result) && !empty($result['is_error'])) {
› throw new CRM_Core_Exception($result['error_message'], $result['error_code'] ?? 'undefined', $result);
› }
}
/var/www/vhosts/domain/httpdocs/wp-content/plugins/civicrm/civicrm/CRM/Activity/BAO/Activity.php:898 { …}
/var/www/vhosts/domain/httpdocs/wp-content/plugins/civicrm/civicrm/CRM/Contact/BAO/Contact.php:2641 { …}
/var/www/vhosts/domain/httpdocs/wp-content/plugins/civicrm/civicrm/CRM/Contact/Page/View/Summary.php:434 { …}
/var/www/vhosts/domain/httpdocs/wp-content/plugins/civicrm/civicrm/CRM/Contact/Page/View/Summary.php:255 { …}
/var/www/vhosts/domain/httpdocs/wp-content/plugins/civicrm/civicrm/CRM/Contact/Page/View/Summary.php:83 { …}
/var/www/vhosts/domain/httpdocs/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php:322 { …}
/var/www/vhosts/domain/httpdocs/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php:69 { …}
/var/www/vhosts/domain/httpdocs/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php:36 { …}
/var/www/vhosts/domain/httpdocs/wp-content/plugins/civicrm/civicrm.php:1231 { …}
/var/www/vhosts/domain/httpdocs/wp-includes/class-wp-hook.php:308 { …}
/var/www/vhosts/domain/httpdocs/wp-includes/class-wp-hook.php:332 { …}
/var/www/vhosts/domain/httpdocs/wp-includes/plugin.php:517 { …}
/var/www/vhosts/domain/httpdocs/wp-admin/admin.php:259 { …}
}
}
]
2024-01-08 13:30:57+0100 [debug] $backTrace = #0 /var/www/vhosts/smc-cse.fr/httpdocs/wp-content/plugins/civicrm/civicrm/CRM/Core/Error.php(443): CRM_Core_Error::backtrace("backTrace", TRUE)
#1 /var/www/vhosts/smc-cse.fr/httpdocs/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(39): CRM_Core_Error::handleUnhandledException(Object(CRM_Core_Exception))
#2 /var/www/vhosts/domain/httpdocs/wp-content/plugins/civicrm/civicrm.php(1231): CRM_Core_Invoke::invoke((Array:3))
#3 /var/www/vhosts/domain/httpdocs/wp-includes/class-wp-hook.php(308): CiviCRM_For_WordPress->invoke("")
#4 /var/www/vhosts/domain/httpdocs/wp-includes/class-wp-hook.php(332): WP_Hook->apply_filters("", (Array:1))
#5 /var/www/vhosts/domain/httpdocs/wp-includes/plugin.php(517): WP_Hook->do_action((Array:1))
#6 /var/www/vhosts/domain/httpdocs/wp-admin/admin.php(259): do_action("toplevel_page_CiviCRM")
#7 {main}```