Uploaded image for project: 'CiviCRM'
  1. CiviCRM
  2. CRM-13349

On data export, data too long for columns 'contribution_note', 'current_employer' and with custom fields

    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.',
      ...

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              rares Rares P
            • Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: