Hi All,
I am having trouble importing product attributes , I have faithfully copied the exported file. When I do an import (check only) a blank page with "WARNING: An Error occurred, please refresh the page and try again.If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields." appears.
Looking in the server debug log I have found this error
Code:
[15-Sep-2019 12:29:06 UTC] Request URI: /admin/dbio_manager.php?action=file, IP address: 220.000.152.100
#1 trigger_error() called at [/home/u241385883/domains/rm/public_html/includes/classes/db/mysql/query_factory.php:171]
#2 queryFactory->show_error() called at [/home/u241385883/domains/rm/public_html/includes/classes/db/mysql/query_factory.php:143]
#3 queryFactory->set_error() called at [/home/u241385883/domains/rm/public_html/includes/classes/db/mysql/query_factory.php:270]
#4 queryFactory->Execute() called at [/home/u241385883/domains/rm/public_html/admin/includes/classes/dbio/DbIoHandler.php:931]
#5 DbIoHandler->importCsvRecord() called at [/home/u241385883/domains/rm/public_html/admin/includes/classes/dbio/DbIo.php:265]
#6 DbIo->dbioImport() called at [/home/u241385883/domains/rm/public_html/admin/dbio_manager.php:223]
--> PHP Fatal error: 1062:Duplicate entry '0' for key 'PRIMARY' :: INSERT INTO products_attributes_download (`products_attributes_filename`, `products_attributes_maxdays`, `products_attributes_maxcount`)
VALUES ('9', 7, 15) ==> (as called by) /home/u241385883/domains/rm/public_html/admin/includes/classes/dbio/DbIoHandler.php on line 931 <== in /home/u241385883/domains/rm/public_html/includes/classes/db/mysql/query_factory.php on line 171.
Here is a link to a sample CSV file I created . Any help is appreciated :)
https://yadi.sk/d/TscaBWdKATapHA
Bookmarks