[Skip to main content](#vessel-content) # Duplicate Primary on Import ## - **[shank8888](/forum/user/57765-shank8888 "View shank8888's Profile")** - [![shank8888's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/57765-shank8888 "View shank8888's Profile") Topic Author - [ Offline](/forum/user/57765-shank8888) Less More - Posts: 8 - Thank you received: 0 - - 7 years 11 months ago - 7 years 11 months ago [\#300781](#300781) by [shank8888](/forum/user/57765-shank8888 "View shank8888's Profile") *[Duplicate Primary on Import](/forum/37-import-export-csv-xls/896284-duplicate-primary-on-import#300781 "-- HikaShop version -- : 4.0.0 -- Joomla version -- : 3.9.0 -- PHP version -- : 7.2.1 -- Error-message(debug-mod must be tuned on) -- Whenever I try to import from Opencart 3.0.2 I am getting this error, It will upload some categories but no subcategories and no products or images.")* was created by *[shank8888](/forum/user/57765-shank8888 "View shank8888's Profile")* -- HikaShop version -- : 4.0.0 -- Joomla version -- : 3.9.0 -- PHP version -- : 7.2.1 -- Error-message(debug-mod must be tuned on) -- Code: An error has occurred. 1062 Duplicate entry '27' for key 'PRIMARY' /home/spasso5/public_html/libraries/joomla/database/driver/mysqli.php:661 Call stack # Function Location 1 () JROOT/libraries/joomla/database/driver/mysqli.php:661 2 JDatabaseDriverMysqli->execute() JROOT/administrator/components/com_hikashop/helpers/import/openc.php:851 3 hikashopImportopencHelper->importCategories() JROOT/administrator/components/com_hikashop/helpers/import/openc.php:172 4 hikashopImportopencHelper->doImport() JROOT/administrator/components/com_hikashop/helpers/import/openc.php:61 5 hikashopImportopencHelper->importFromOpenc() JROOT/administrator/components/com_hikashop/controllers/import.php:160 6 ImportController->_opencart() JROOT/administrator/components/com_hikashop/controllers/import.php:106 7 ImportController->import() JROOT/libraries/src/MVC/Controller/BaseController.php:710 8 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_hikashop/helpers/helper.php:1854 9 hikashopController->execute() JROOT/administrator/components/com_hikashop/hikashop.php:72 10 require_once() JROOT/libraries/src/Component/ComponentHelper.php:402 11 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 12 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/AdministratorApplication.php:101 13 Joomla\CMS\Application\AdministratorApplication->dispatch() JROOT/libraries/src/Application/AdministratorApplication.php:159 14 Joomla\CMS\Application\AdministratorApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 15 Joomla\CMS\Application\CMSApplication->execute() JROOT/administrator/index.php:51 Whenever I try to import from Opencart 3.0.2 I am getting this error, It will upload some categories but no subcategories and no products or images. Last edit: 7 years 11 months ago by [Jerome](/forum/user/80-jerome "View Jerome's Profile"). Reason: [code] is nice Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84OTYyODQtZHVwbGljYXRlLXByaW1hcnktb24taW1wb3J0P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26400 - Thank you received: 4079 - - [](http://obsi.dev) - 7 years 11 months ago [\#300808](#300808) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Duplicate Primary on Import](/forum/37-import-export-csv-xls/896284-duplicate-primary-on-import#300808 "-- HikaShop version -- : 4.0.0 -- Joomla version -- : 3.9.0 -- PHP version -- : 7.2.1 -- Error-message(debug-mod must be tuned on) -- Whenever I try to import from Opencart 3.0.2 I am getting this error, It will upload some categories but no subcategories and no products or images.")* Hello, It looks like that you have the same issue than in that thread (where the user did not confirm that the patch fixed the issue, so the patch might not be integrated into HikaShop) [ www.hikashop.com/forum/import-export-csv...g-from-opencart.html](https://www.hikashop.com/forum/import-export-csv-xls/888538-error-when-importing-from-opencart.html) Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84OTYyODQtZHVwbGljYXRlLXByaW1hcnktb24taW1wb3J0P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[shank8888](/forum/user/57765-shank8888 "View shank8888's Profile")** - [![shank8888's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/57765-shank8888 "View shank8888's Profile") Topic Author - [ Offline](/forum/user/57765-shank8888) Less More - Posts: 8 - Thank you received: 0 - - 7 years 11 months ago - 7 years 11 months ago [\#300811](#300811) by [shank8888](/forum/user/57765-shank8888 "View shank8888's Profile") Replied by *[shank8888](/forum/user/57765-shank8888 "View shank8888's Profile")* on topic *[Duplicate Primary on Import](/forum/37-import-export-csv-xls/896284-duplicate-primary-on-import#300811 "-- HikaShop version -- : 4.0.0 -- Joomla version -- : 3.9.0 -- PHP version -- : 7.2.1 -- Error-message(debug-mod must be tuned on) -- Whenever I try to import from Opencart 3.0.2 I am getting this error, It will upload some categories but no subcategories and no products or images.")* Hi That is line 508? 1062 Duplicate entry '62' for key 'PRIMARY'? It seems to be creating a strange loop where it imports the main categories then tries to import the main categories under the main ones again and again eventually creating a BIGINT database error. If i go to delete the categories: An error has occurred. 1690 BIGINT UNSIGNED value is out of range in '(`spasso5_seosnap`.`#__hikashop_category`.`category_left` - 2)' Last edit: 7 years 11 months ago by [shank8888](/forum/user/57765-shank8888 "View shank8888's Profile"). Reason: added information Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84OTYyODQtZHVwbGljYXRlLXByaW1hcnktb24taW1wb3J0P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26400 - Thank you received: 4079 - - [](http://obsi.dev) - 7 years 11 months ago [\#300835](#300835) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Duplicate Primary on Import](/forum/37-import-export-csv-xls/896284-duplicate-primary-on-import#300835 "-- HikaShop version -- : 4.0.0 -- Joomla version -- : 3.9.0 -- PHP version -- : 7.2.1 -- Error-message(debug-mod must be tuned on) -- Whenever I try to import from Opencart 3.0.2 I am getting this error, It will upload some categories but no subcategories and no products or images.")* Hello, The bigint issue is because there is no more category, so the "category_left" is consider to be "0" and if you remove 2, you got a negative value (which is a problem when it has to contain only positive values). You should not delete the core categories. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84OTYyODQtZHVwbGljYXRlLXByaW1hcnktb24taW1wb3J0P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop Install & Update Product & Category Display Content Creation Sales and Orders Orders management Reports & Statistics Customers Checkout Payment Methods Shipping Methods Import & Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel & Slider Mass Actions Filters & Search Discount & Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.078 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)