Details
-
Type: Bug
-
Status: Won't Do
-
Priority: Major
-
Resolution: Won't Do
-
Affects Version/s: 4.3.5, 4.4.6, 4.5
-
Fix Version/s: Unscheduled
-
Component/s: None
-
Labels:
-
Versioning Impact:Patch (backwards-compatible bug fixes)
-
Documentation Required?:None
Description
Possibly related: CRM-12309
Received this error while creating an export that included a contribution note field.
[nativecode=1406 ** Data too long for column 'contribution_note' at row 1]
The contribution note text was 145 characters long in this case.
Checked the table definition and it was limited to 64 characters.
SHOW CREATE TABLE civicrm_export_temp_xxx;
CREATE TABLE `civicrm_export_temp_77eef60135ffb5c5a2df752c9f6d0621` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
...
`contribution_note` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
...
However, in civicrm_note it is not limited:
CREATE TABLE `civicrm_note` (
...
`note` text COMMENT 'Note and/or Comment.',
...