New Install 1.4.2 getting error when uploading CVS files

[bobcompton]

Hi All
New Install 1.4.2 getting error when uploading CVS files. Here is a sample of some of the errors.


2025-06-05 15:45:27 - Converting file /home3/sensory/public_html/admin/system/data/import_php20PKqf.txt to array. Start row number: 0. Rows count: 1
2025-06-05 15:45:27 - Starting import data from array. Mode: commit
2025-06-05 15:45:27 - update for table customers done successfully
2025-06-05 15:45:27 - insert data error in addresses. SQL Error: Duplicate entry '5' for key 'PRIMARY'\nError No: 1062\nSQL: INSERT INTO `sensoryaddresses` SET `customer_id` = '4', `address_id` = '5', `company` = '', `firstname` = 'XXX', `lastname` = 'XXXX', `address_1` = 'XXXXXX', `address_2` = '', `postcode` = 'XXXX', `city` = 'Fort Wayne', `country_id` = '223', `zone_id` = '3636'
2025-06-05 15:45:27 - update data error in addresses. SQL Error: Duplicate entry '5' for key 'PRIMARY'\nError No: 1062\nSQL: INSERT INTO `sensoryaddresses` SET `customer_id` = '4', `address_id` = '5', `company` = '', `firstname` = xxxx', `lastname` = 'xxxx', `address_1` = 'xxxxxxx', `address_2` = '', `postcode` = 'xxxxxx', `city` = 'xxxxxxxx', `country_id` = '223', `zone_id` = '3636'
2025-06-05 15:45:27 - update data error in addresses. SQL Error: Duplicate entry '5' for key 'PRIMARY'\nError No: 1062\nSQL: INSERT INTO `sensoryaddresses` SET `customer_id` = '4', `address_id` = '5', `company` = '', `firstname` = 'xxxx', `lastname` = 'xxxxxxxx', `address_1` = 'xxxxxxx', `address_2` = '', `postcode` = 'xxxxxx', `city` = 'xxxxxxxx', `country_id` = '223', `zone_id` = '3636'
2025-06-05 15:45:27 - Converting file /home3/sensory/public_html/admin/system/data/import_php20PKqf.txt to array. Start row number: 1. Rows count: 1
2025-06-05 15:45:27 - Starting import data from array. Mode: commit
2025-06-05 15:45:27 - update data error in customers. SQL Error: Duplicate entry '5' for key 'PRIMARY'\nError No: 1062\nSQL: INSERT INTO `sensoryaddresses` SET `customer_id` = '4', `address_id` = '5', `company` = '', `firstname` = 'xxxx', `lastname` = 'xxxxxx', `address_1` = 'xxxxxxx', `address_2` = '', `postcode` = 'xxxxxxx', `city` = 'xxxxxxx', `country_id` = '223', `zone_id` = '3636'
2025-06-05 15:45:27 - insert data error in addresses. SQL Error: Duplicate entry '6' for key 'PRIMARY'\nError No: 1062\nSQL: INSERT INTO `sensoryaddresses` SET `customer_id` = '5', `address_id` = '6', `company` = 'xxxxx', `firstname` = 'xxxxxx', `lastname` = 'xxxxxx', `address_1` = 'xxxxxxx', `address_2` = '', `postcode` = 'xxxxxx', `city` = 'xxxxxxx', `country_id` = '223', `zone_id` = '3639'
2025-06-05 15:45:27 - insert data error in addresses. SQL Error: Duplicate entry '7' for key 'PRIMARY'\nError No: 1062\nSQL: INSERT INTO `sensoryaddresses` SET `customer_id` = '5', `address_id` = '7', `company` = 'xxxxxx', `firstname` = 'xxxxxx', `lastname` = 'xxxxxx', `address_1` = 'xxxxxxxxx', `address_2` = '', `postcode` = 'xxxxxx', `city` = 'xxxxx', `country_id` = '223', `zone_id` = '3639'
2025-06-05 15:45:27 - Converting file /home3/sensory/public_html/admin/system/data/import_php20PKqf.txt to array. Start row number: 2. Rows count: 1

Thanks, for any help.

[Basara]

Hello.
What exactly are you importing? (Customers? Orders? Products? Something else?). Could you also attach your CSV file

[bobcompton]

When I try to load my customers it thoughts the errors. I have attached the error.txt, task_log.txt and both import.txt.
Thanks for looking at this.
Bob

[Basara]

Hello.
Please attach your CSV file