Regression : File fields export results in DB error
It was possible to export fields earlier as the file field was exported as the link
But now it gives DB error as it looks like it is trying to put in content instead.
Database Error Code: Data too long for column 'custom_13' at row 1, 1406
Additional Details:
Array
(
[callback] => Array
(
[0] => CRM_Core_Error
[1] => handle
)
[code] => -1
[message] => DB Error: unknown error
[mode] => 16
[debug_info] =>
INSERT INTO civicrm_tmp_d_export_f8e0146418cb04e43d04334f268fd888 (`id`, `display_name`, `custom_13`, `participant_id`)
VALUES (1,'Mrs. Bernadette Ivanov',' <a href=\"/civicrm/file?reset=1&id=1&eid=42&fcs=66d344b164defb0da239223d1515c8a1b5e2305cd4be3c2527e18a2d6577acc4_1590738546_168\" class=\"crm-image-popup\" title=\"download.jpeg\">\n <i class=\"crm-i fa-file-image-o\" aria-hidden=\"true\"></i>\n </a>','42')
[nativecode=1406 ** Data too long for column 'custom_13' at row 1]
[type] => DB_Error
[user_info] =>
INSERT INTO civicrm_tmp_d_export_f8e0146418cb04e43d04334f268fd888 (`id`, `display_name`, `custom_13`, `participant_id`)
VALUES (1,'Mrs. Bernadette Ivanov',' <a href=\"/civicrm/file?reset=1&id=1&eid=42&fcs=66d344b164defb0da239223d1515c8a1b5e2305cd4be3c2527e18a2d6577acc4_1590738546_168\" class=\"crm-image-popup\" title=\"download.jpeg\">\n <i class=\"crm-i fa-file-image-o\" aria-hidden=\"true\"></i>\n </a>','42')
[nativecode=1406 ** Data too long for column 'custom_13' at row 1]
[to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="
INSERT INTO civicrm_tmp_d_export_f8e0146418cb04e43d04334f268fd888 (`id`, `display_name`, `custom_13`, `participant_id`)
VALUES (1,'Mrs. Bernadette Ivanov',' <a href=\"/civicrm/file?reset=1&id=1&eid=42&fcs=66d344b164defb0da239223d1515c8a1b5e2305cd4be3c2527e18a2d6577acc4_1590738546_168\" class=\"crm-image-popup\" title=\"download.jpeg\">\n <i class=\"crm-i fa-file-image-o\" aria-hidden=\"true\"></i>\n </a>','42')
[nativecode=1406 ** Data too long for column 'custom_13' at row 1]"]
)
Edited by yashodha