Truncated incorrect DOUBLE value: '6\00019'
It could be that this is particular to my install but using this extension, i see the following error in the error log:
[error] $Fatal Error Details = Array
(
[callback] => Array
(
[0] => CRM_Core_Error
[1] => exceptionHandler
)
[code] => -1
[message] => DB Error: unknown error
[mode] => 16
[debug_info] => INSERT INTO civicrm_tmp_e_aclccache_50a12e9619b3b7a5c267831d4224c28a (contact_id) SELECT DISTINCT contact_a.id FROM civicrm_contact contact_a LEFT JOIN civicrm_participant otherparticipants ON contact_a.id = otherparticipants.contact_id LEFT JOIN civicrm_participant myparticipants ON myparticipants.role_id IN (12) AND myparticipants.event_id = otherparticipants.event_id LEFT JOIN my_relationships_7137_97127 permrelationships
ON (contact_a.id = permrelationships.contact_id) WHERE ( permrelationships.contact_id IS NOT NULL ) OR (myparticipants.contact_id = 7137) AND (contact_a.is_deleted = 0) [nativecode=1292 ** Truncated incorrect DOUBLE value: '6\00019']
[type] => DB_Error
[user_info] => INSERT INTO civicrm_tmp_e_aclccache_50a12e9619b3b7a5c267831d4224c28a (contact_id) SELECT DISTINCT contact_a.id FROM civicrm_contact contact_a LEFT JOIN civicrm_participant otherparticipants ON contact_a.id = otherparticipants.contact_id LEFT JOIN civicrm_participant myparticipants ON myparticipants.role_id IN (12) AND myparticipants.event_id = otherparticipants.event_id LEFT JOIN my_relationships_7137_97127 permrelationships
ON (contact_a.id = permrelationships.contact_id) WHERE ( permrelationships.contact_id IS NOT NULL ) OR (myparticipants.contact_id = 7137) AND (contact_a.is_deleted = 0) [nativecode=1292 ** Truncated incorrect DOUBLE value: '6\00019']
[to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::exceptionHandler prefix="" info="INSERT INTO civicrm_tmp_e_aclccache_50a12e9619b3b7a5c267831d4224c28a (contact_id) SELECT DISTINCT contact_a.id FROM civicrm_contact contact_a LEFT JOIN civicrm_participant otherparticipants ON contact_a.id = otherparticipants.contact_id LEFT JOIN civicrm_participant myparticipants ON myparticipants.role_id IN (12) AND myparticipants.event_id = otherparticipants.event_id LEFT JOIN my_relationships_7137_97127 permrelationships
ON (contact_a.id = permrelationships.contact_id) WHERE ( permrelationships.contact_id IS NOT NULL ) OR (myparticipants.contact_id = 7137) AND (contact_a.is_deleted = 0) [nativecode=1292 ** Truncated incorrect DOUBLE value: '6\00019']"]
My details:
- CiviCRM: 5.47.beta1
- CMS: Drupal 7.88
- PHP: 7.4.28 (fpm-fcgi)
- Database: 10.6.5-MariaDB-1:10.6.5+maria~bullseye-log engine: InnoDB 10 row format: Dynamic
- Webserver: Apache