Hi I have a file named 14052014-5-CLEAN-CSV-XXX XXXXX XXXXX XXXXXX Competition.csv,

which throws the below error.

The fix was i had to shorten the csv file name too: 14052014-6-CLEAN-CSV

Thanks

Type php
Date Wednesday, 14 May 2014 - 9:18am
User superuser
Location http://xxxxxxxxxxx.com/admin/people/user_import/add?render=overlay&rende...
Referrer http://xxxxxxxxxxx.com/admin/people/user_import/add?render=overlay
Message PDOException: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'filename' at row 1: INSERT INTO {user_import} (name, auto_import_directory, filename, oldfilename, filepath, started, pointer, processed, valid, field_match, roles, options, setting) 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, :db_insert_placeholder_8, :db_insert_placeholder_9, :db_insert_placeholder_10, :db_insert_placeholder_11, :db_insert_placeholder_12); Array ( [:db_insert_placeholder_0] => [:db_insert_placeholder_1] => [:db_insert_placeholder_2] => 14052014-6-CLEAN-CSV-XXX XXXXX XXXXX XXXXX Competition.csv [:db_insert_placeholder_3] => 14052014-6-CLEAN-CSV-XXX XXXXX XXXXX XXXXX Competition.csv [:db_insert_placeholder_4] => private://user_import/processing/14052014-6-CLEAN-XXX XXXXX XXXXX XXXXX Competition.csv [:db_insert_placeholder_5] => 1400030316 [:db_insert_placeholder_6] => 0 [:db_insert_placeholder_7] => 0 [:db_insert_placeholder_8] => 0 [:db_insert_placeholder_9] => a:0:{} [:db_insert_placeholder_10] => s:0:""; [:db_insert_placeholder_11] => a:5:{s:11:"file_upload";s:0:"";s:9:"delimiter";s:1:",";s:4:"next";s:4:"Next";s:9:"file_info";O:8:"stdClass":10:{s:3:"uid";s:1:"1";s:6:"status";i:0;s:8:"filename";s:60:"14052014-6-CLEAN-CSV-Eat Drink Perth AirAsia Competition.csv";s:3:"uri";s:72:"temporary://14052014-6-CLEAN-XXX XXXXX XXXXX XXXXX Competition.csv";s:8:"filemime";s:8:"text/csv";s:8:"filesize";i:44281;s:6:"source";s:11:"file_upload";s:11:"destination";s:72:"temporary://14052014-6-CLEAN-XXX XXXXX XXXXX XXXXX Competition.csv";s:9:"timestamp";i:1400030316;s:3:"fid";s:5:"16802";}s:3:"ftp";b:0;} [:db_insert_placeholder_12] => file set ) in user_import_import_set() (line 624 of /home/XXXXXX/public_html/sites/all/modules/user_import/user_import.module).
Severity error
Hostname 202.89.190.71

CommentFileSizeAuthor
#4 2266913-4.patch3.91 KBlohndaniel
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

Eric_A’s picture

Version: 7.x-2.1 » 7.x-2.x-dev

First thing that is needed is validation. Second: why a limit of 50 chars? Core uses varchar 255 for filename in file_managed.

Joran Lafleuriel’s picture

I also had to reduce csv filename to get import possible...
7.x-2.2+2-dev

ryank76’s picture

I had this with version 7.x-2.2.

Reducing filename allowed import.

lohndaniel’s picture

FileSize
3.91 KB

I've created a little patch for user import callback. This patch handle user update/insert error with watchdog exception and display a more user friendly error message.