Details
-
Type:
Bug
-
Status: Done/Fixed
-
Priority:
Major
-
Resolution: Fixed/Completed
-
Affects Version/s: 4.7.7
-
Fix Version/s: 4.7.9
-
Component/s: None
-
Labels:
-
Documentation Required?:None
-
Funding Source:Contributed Code
Description
To reproduce on dmaster:
- Go to Advanced Search
- Display results as Contributions
- Click "search"
In the results, select the "export" task, then export primary fields. This will result in a "DB error".
SQL error is:
"1406 ** Data too long for column 'phone_type_id' at row 1"
INSERT INTO civicrm_export_temp_77054db030c54f58e12bafe56111c0ba (id, civic..."
[...]
#4 /var/aegir/platforms/civicrm-4.7/sites/all/modules/civicrm/packages/PEAR.php(564): DB_Error->DB_Error(-1, 16, (Array:2), "\nINSERT INTO civicrm_export_temp_77054db030c54f58e12bafe56111c0ba (id, civic...")
#5 /var/aegir/platforms/civicrm-4.7/sites/all/modules/civicrm/packages/DB/common.php(1905): PEAR->raiseError(NULL, -1, NULL, NULL, "\nINSERT INTO civicrm_export_temp_77054db030c54f58e12bafe56111c0ba (id, civic...", "DB_Error", TRUE)
#6 /var/aegir/platforms/civicrm-4.7/sites/all/modules/civicrm/packages/DB/mysql.php(895): DB_common->raiseError(-1, NULL, NULL, NULL, "1406 ** Data too long for column 'phone_type_id' at row 1")
#7 /var/aegir/platforms/civicrm-4.7/sites/all/modules/civicrm/packages/DB/mysql.php(328): DB_mysql->mysqlRaiseError()
[...]
#12 /var/aegir/platforms/civicrm-4.7/sites/all/modules/civicrm/CRM/Core/DAO.php(1277): CRM_Core_DAO->query("\nINSERT INTO civicrm_export_temp_77054db030c54f58e12bafe56111c0ba (id, civic...", TRUE)
#13 /var/aegir/platforms/civicrm-4.7/sites/all/modules/civicrm/CRM/Export/BAO/Export.php(1450): CRM_Core_DAO::executeQuery("\nINSERT INTO civicrm_export_temp_77054db030c54f58e12bafe56111c0ba (id, civic...")
#14 /var/aegir/platforms/civicrm-4.7/sites/all/modules/civicrm/CRM/Export/BAO/Export.php(1086): CRM_Export_BAO_Export::writeDetailsToTable("civicrm_export_temp_77054db030c54f58e12bafe56111c0ba", (Array:100), (Array:116))
#15 /var/aegir/platforms/civicrm-4.7/sites/all/modules/civicrm/CRM/Export/Form/Select.php(434): CRM_Export_BAO_Export::exportComponents(TRUE, (Array:563), (Array:27), "receive_date desc", NULL, NULL, 2, " civicrm_contribution.id IN ( 17372,17369,17342,17260,17198,17033,16945,16927...", NULL, 0, 0, (Array:4), "AND")
#16 /var/aegir/platforms/civicrm-4.7/sites/all/modules/civicrm/CRM/Core/Form.php(423): CRM_Export_Form_Select->postProcess()
[...]
Attachments
Issue Links
- links to