Database Error Using Include/Exclude Search With Long Group Names
A database error occurs when attempting to do an Include/Exclude search with a group name over 64 characters in length.
[error]
$Fatal Error Details = array:3 [
"message" => "DB Error: unknown error"
"code" => null
"exception" => Civi\Core\Exception\DBQueryException {
-errorData: array:2 [
"exception" => DB_Error {
+error_message_prefix: ""
+mode: 16
+level: 1024
+code: -1
+message: "DB Error: unknown error"
+userinfo: """
INSERT INTO civicrm_tmp_e_iggroup_1d303da385fcd81408e677514935ea99 (contact_id, group_names)
SELECT civicrm_contact.id as contact_id, civicrm_group.title as group_name
FROM civicrm_contact
INNER JOIN civicrm_group_contact
ON civicrm_group_contact.contact_id = civicrm_contact.id
LEFT JOIN civicrm_group
ON civicrm_group_contact.group_id = civicrm_group.id WHERE
civicrm_group_contact.status = 'Added' AND
civicrm_group_contact.group_id IN(3058) [nativecode=1406 ** **Data too long for column** 'group_names' at row 1]
"""
+backtrace: array:29 [
0 => array:6 [
"file" => ".../modules/civicrm/vendor/pear/db/DB.php"
"line" => 997
"function" => "__construct"
"class" => "PEAR_Error"
"type" => "->"
"args" => array:5 [
0 => "DB Error: unknown error"
1 => -1
2 => 16
3 => array:2 [
0 => "CRM_Core_Error"
1 => "exceptionHandler"
]
4 => """
INSERT INTO civicrm_tmp_e_iggroup_1d303da385fcd81408e677514935ea99 (contact_id, group_names)
SELECT civicrm_contact.id as contact_id, civicrm_group.title as group_name
FROM civicrm_contact
INNER JOIN civicrm_group_contact
ON civicrm_group_contact.contact_id = civicrm_contact.id
LEFT JOIN civicrm_group
ON civicrm_group_contact.group_id = civicrm_group.id WHERE
civicrm_group_contact.status = 'Added' AND
civicrm_group_contact.group_id IN(3058) [nativecode=1406 ** **Data too long for column** 'group_names' at row 1]
"""
]
]