Skip to content

GitLab

Closed
Created by seamuslee@seamusleeDeveloper

Cannot import preferred language field using label

Overview

Trying to import contacts including the preferred language column which contains Option Labels e.g. English (Australia) doesn't work, causes a DB error as it tries to insert in a too long a string.

Reproduction steps

  1. Create a CSV to import contacts including the preferred language field with at least one entry containing the language option value.
  2. Perform import process.
  3. Got an error "Fatal error: DB unknown error". Due to field content being too long

Current behaviour

Import fails

Expected behaviour

Import succeeds

Environment information

  • CiviCRM: Master
  • PHP: 7.3
  • CMS: Drupal 7

@JoeMurray

To upload designs, you'll need to enable LFS and have an admin enable hashed storage. More information