- GlobalNET Platform
- 1549784473-m.shime-apcss
1549784473-m.shime-apcss
Description
Unable to bulk import the attached user file
Request Details
Priority:
Medium
Status:
Completed
Age: 5 years 2 months
Category:
Other
Organization
Daniel K. Inouye Asia-Pacific Center for Security Studies
Created: 02/10/2019 - 02:45
Updated: 03/19/2019 - 14:04
Hi Michael, going to close this since I've not heard back in a month. Happy to re-visit as needed. Thanks!
Michael, let me know how your second attempt went. Is this still an issue?
Cheers,
Lisa
Michael, did the second attempt work?
Cheers,
Lisa
Michael,
Try the file again after you reduce to a much shorter first name. If I'm correct with trying to find the error, the problem is the first name field exceeded the limit.
PDOException: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'field_name_first_value' at row 1: INSERT INTO {field_data_field_name_first} (entity_type, entity_id, revision_id, bundle, delta, language, field_name_first_value, field_name_first_format) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6, :db_insert_placeholder_7); Array ( [:db_insert_placeholder_0] => user [:db_insert_placeholder_1] => 292663 [:db_insert_placeholder_2] => 531319 [:db_insert_placeholder_3] => user [:db_insert_placeholder_4] => 0 [:db_insert_placeholder_5] => und [:db_insert_placeholder_6] => Siulolo Poulivaati Ruby Oe A Hau O Badaling [:db_insert_placeholder_7] => ) in field_sql_storage_field_storage_write() (line 514 of /var/www/prod/docroot/modules/field/modules/field_sql_storage/field_sql_storage.module).