[Skip to main content](#vessel-content) # Import from mijoshop error ## - **[Sigizmunt](/forum/user/36822-sigizmunt "View Sigizmunt's Profile")** - [![Sigizmunt's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/36822-sigizmunt "View Sigizmunt's Profile") Topic Author - [ Offline](/forum/user/36822-sigizmunt) Less More - Posts: 3 - Thank you received: 0 - - 11 years 6 months ago - 11 years 6 months ago [\#197587](#197587) by [Sigizmunt](/forum/user/36822-sigizmunt "View Sigizmunt's Profile") *[Import from mijoshop error](/forum/37-import-export-csv-xls/876218-import-from-mijoshop-error#197587 "-- HikaShop version -- : 2.4.0 -- Joomla version -- : 3.4.1 -- Error-message(debug-mod must be tuned on) -- : Error Hello. Can't import data from mijoshop. There's an error message: Duplicate entry '27' for key 'PRIMARY' SQL=INSERT INTO `w21aqq_hikashop_category` (`category_id`,`category_parent_id`,`category_type`,`category_name`,`category_description`,`category_published`,`category_ordering`,`category_namekey`,`category_created`,`category_modified`,`category_access`,`category_menu`) VALUES (27,2,'product','Колье Рё украшения РЅР° шею','',1,7,'2__10777','1391672241','1427228343','all',0),(27,2,'product','Колье Рё украшения РЅР° шею','',1,7,'2__15070','1391672241','1427228343','all',0),(29,2,'product','Комплекты','',1,10,'2__25791','1391672265','1427228349','all',0),(29,2,'product','Комплекты','',1,10,'2__18316','1391672265','1427228349','all',0),(31,2,'product','Серьги','',1,10,'2__20181','1391672286','1427228355','all',0),(31,2,'product','Серьги','',1,10,'2__9962','1391672286','1427228355','all',0),(33,2,'product','Украшения РЅР° голову','',1,19,'2__3547','1391672326','1427228362','all',0),(33,2,'product','Украшения РЅР° голову','',1,19,'2__20600','1391672326','1427228362','all',0),(35,2,'product','Браслеты','',1,22,'2__849','1391672356','1427228331','all',0),(35,2,'product','Браслеты','',1,22,'2__18358','1391672356','1427228331','all',0),(37,2,'product','Броши','',1,25,'2__11447','1391672386','1427228338','all',0),(37,2,'product','Броши','',1,25,'2__31780','1391672386','1427228338','all',0); What's wrong?Thanks.")* was created by *[Sigizmunt](/forum/user/36822-sigizmunt "View Sigizmunt's Profile")* -- HikaShop version -- : 2.4.0 -- Joomla version -- : 3.4.1 -- Error-message(debug-mod must be tuned on) -- : Error Hello. Can't import data from mijoshop. There's an error message: Duplicate entry '27' for key 'PRIMARY' SQL=INSERT INTO `w21aqq_hikashop_category` (`category_id`,`category_parent_id`,`category_type`,`category_name`,`category_description`,`category_published`,`category_ordering`,`category_namekey`,`category_created`,`category_modified`,`category_access`,`category_menu`) VALUES (27,2,'product','Колье Рё украшения РЅР° шею','',1,7,'2__10777','1391672241','1427228343','all',0),(27,2,'product','Колье Рё украшения РЅР° шею','',1,7,'2__15070','1391672241','1427228343','all',0),(29,2,'product','Комплекты','',1,10,'2__25791','1391672265','1427228349','all',0),(29,2,'product','Комплекты','',1,10,'2__18316','1391672265','1427228349','all',0),(31,2,'product','Серьги','',1,10,'2__20181','1391672286','1427228355','all',0),(31,2,'product','Серьги','',1,10,'2__9962','1391672286','1427228355','all',0),(33,2,'product','Украшения РЅР° голову','',1,19,'2__3547','1391672326','1427228362','all',0),(33,2,'product','Украшения РЅР° голову','',1,19,'2__20600','1391672326','1427228362','all',0),(35,2,'product','Браслеты','',1,22,'2__849','1391672356','1427228331','all',0),(35,2,'product','Браслеты','',1,22,'2__18358','1391672356','1427228331','all',0),(37,2,'product','Броши','',1,25,'2__11447','1391672386','1427228338','all',0),(37,2,'product','Броши','',1,25,'2__31780','1391672386','1427228338','all',0); What's wrong?Thanks. Last edit: 11 years 6 months ago by [Sigizmunt](/forum/user/36822-sigizmunt "View Sigizmunt's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NzYyMTgtaW1wb3J0LWZyb20tbWlqb3Nob3AtZXJyb3I/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Xavier](/forum/user/4105-xavier "View Xavier's Profile")** - [![Xavier's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar4105.png)](/forum/user/4105-xavier "View Xavier's Profile") - [ Offline](/forum/user/4105-xavier) Less More - Posts: 13201 - Thank you received: 2322 - - - - [](http://www.kidiweb.fr) - 11 years 6 months ago [\#197602](#197602) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[Import from mijoshop error](/forum/37-import-export-csv-xls/876218-import-from-mijoshop-error#197602 "-- HikaShop version -- : 2.4.0 -- Joomla version -- : 3.4.1 -- Error-message(debug-mod must be tuned on) -- : Error Hello. Can't import data from mijoshop. There's an error message: Duplicate entry '27' for key 'PRIMARY' SQL=INSERT INTO `w21aqq_hikashop_category` (`category_id`,`category_parent_id`,`category_type`,`category_name`,`category_description`,`category_published`,`category_ordering`,`category_namekey`,`category_created`,`category_modified`,`category_access`,`category_menu`) VALUES (27,2,'product','Колье Рё украшения РЅР° шею','',1,7,'2__10777','1391672241','1427228343','all',0),(27,2,'product','Колье Рё украшения РЅР° шею','',1,7,'2__15070','1391672241','1427228343','all',0),(29,2,'product','Комплекты','',1,10,'2__25791','1391672265','1427228349','all',0),(29,2,'product','Комплекты','',1,10,'2__18316','1391672265','1427228349','all',0),(31,2,'product','Серьги','',1,10,'2__20181','1391672286','1427228355','all',0),(31,2,'product','Серьги','',1,10,'2__9962','1391672286','1427228355','all',0),(33,2,'product','Украшения РЅР° голову','',1,19,'2__3547','1391672326','1427228362','all',0),(33,2,'product','Украшения РЅР° голову','',1,19,'2__20600','1391672326','1427228362','all',0),(35,2,'product','Браслеты','',1,22,'2__849','1391672356','1427228331','all',0),(35,2,'product','Браслеты','',1,22,'2__18358','1391672356','1427228331','all',0),(37,2,'product','Броши','',1,25,'2__11447','1391672386','1427228338','all',0),(37,2,'product','Броши','',1,25,'2__31780','1391672386','1427228338','all',0); What's wrong?Thanks.")* Hi, In the file "administrator/components/com_hikashop/helpers/import/mijo.php" could you try to replace the two occurrences of : Code: INSERT INTO `#__hikashop_category` By: Code: INSERT IGNORE INTO `#__hikashop_category` Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NzYyMTgtaW1wb3J0LWZyb20tbWlqb3Nob3AtZXJyb3I/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Sigizmunt](/forum/user/36822-sigizmunt "View Sigizmunt's Profile")** - [![Sigizmunt's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/36822-sigizmunt "View Sigizmunt's Profile") Topic Author - [ Offline](/forum/user/36822-sigizmunt) Less More - Posts: 3 - Thank you received: 0 - - 11 years 6 months ago [\#197674](#197674) by [Sigizmunt](/forum/user/36822-sigizmunt "View Sigizmunt's Profile") Replied by *[Sigizmunt](/forum/user/36822-sigizmunt "View Sigizmunt's Profile")* on topic *[Import from mijoshop error](/forum/37-import-export-csv-xls/876218-import-from-mijoshop-error#197674 "-- HikaShop version -- : 2.4.0 -- Joomla version -- : 3.4.1 -- Error-message(debug-mod must be tuned on) -- : Error Hello. Can't import data from mijoshop. There's an error message: Duplicate entry '27' for key 'PRIMARY' SQL=INSERT INTO `w21aqq_hikashop_category` (`category_id`,`category_parent_id`,`category_type`,`category_name`,`category_description`,`category_published`,`category_ordering`,`category_namekey`,`category_created`,`category_modified`,`category_access`,`category_menu`) VALUES (27,2,'product','Колье Рё украшения РЅР° шею','',1,7,'2__10777','1391672241','1427228343','all',0),(27,2,'product','Колье Рё украшения РЅР° шею','',1,7,'2__15070','1391672241','1427228343','all',0),(29,2,'product','Комплекты','',1,10,'2__25791','1391672265','1427228349','all',0),(29,2,'product','Комплекты','',1,10,'2__18316','1391672265','1427228349','all',0),(31,2,'product','Серьги','',1,10,'2__20181','1391672286','1427228355','all',0),(31,2,'product','Серьги','',1,10,'2__9962','1391672286','1427228355','all',0),(33,2,'product','Украшения РЅР° голову','',1,19,'2__3547','1391672326','1427228362','all',0),(33,2,'product','Украшения РЅР° голову','',1,19,'2__20600','1391672326','1427228362','all',0),(35,2,'product','Браслеты','',1,22,'2__849','1391672356','1427228331','all',0),(35,2,'product','Браслеты','',1,22,'2__18358','1391672356','1427228331','all',0),(37,2,'product','Броши','',1,25,'2__11447','1391672386','1427228338','all',0),(37,2,'product','Броши','',1,25,'2__31780','1391672386','1427228338','all',0); What's wrong?Thanks.")* It works, but there is another error ![:)](/media/kunena/emoticons/8.png ":)") Unknown column 'mjd.remaining' in 'field list' SQL=INSERT IGNORE INTO `w21aq_hikashop_download` (`file_id`,`order_id`,`download_number`) SELECT hkf.file_id,hko.order_id,(50- mjd.remaining) FROM `w21aq_mijoshop_download` AS mjd INNER JOIN `w21aq_mijoshop_download_description` mjdd ON mjd.download_id = mjdd.download_id INNER JOIN `w21aq_hikashop_file` AS hkf ON ( CONVERT(hkf.file_name USING utf8) = CONVERT(mjdd.name USING utf8) )INNER JOIN `w21aq_mijoshop_product_to_download` AS mjpd ON mjd.download_id = mjpd.download_id INNER JOIN `w21aq_mijoshop_order_product` AS mjop ON mjpd.product_id = mjop.product_id INNER JOIN `w21aq_hikashop_order` AS hko ON hko.order_mijo_id = mjop.order_id WHERE mjd.download_id > 0 Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NzYyMTgtaW1wb3J0LWZyb20tbWlqb3Nob3AtZXJyb3I/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Sigizmunt](/forum/user/36822-sigizmunt "View Sigizmunt's Profile")** - [![Sigizmunt's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/36822-sigizmunt "View Sigizmunt's Profile") Topic Author - [ Offline](/forum/user/36822-sigizmunt) Less More - Posts: 3 - Thank you received: 0 - - 11 years 6 months ago - 11 years 6 months ago [\#197680](#197680) by [Sigizmunt](/forum/user/36822-sigizmunt "View Sigizmunt's Profile") Replied by *[Sigizmunt](/forum/user/36822-sigizmunt "View Sigizmunt's Profile")* on topic *[Import from mijoshop error](/forum/37-import-export-csv-xls/876218-import-from-mijoshop-error#197680 "-- HikaShop version -- : 2.4.0 -- Joomla version -- : 3.4.1 -- Error-message(debug-mod must be tuned on) -- : Error Hello. Can't import data from mijoshop. There's an error message: Duplicate entry '27' for key 'PRIMARY' SQL=INSERT INTO `w21aqq_hikashop_category` (`category_id`,`category_parent_id`,`category_type`,`category_name`,`category_description`,`category_published`,`category_ordering`,`category_namekey`,`category_created`,`category_modified`,`category_access`,`category_menu`) VALUES (27,2,'product','Колье Рё украшения РЅР° шею','',1,7,'2__10777','1391672241','1427228343','all',0),(27,2,'product','Колье Рё украшения РЅР° шею','',1,7,'2__15070','1391672241','1427228343','all',0),(29,2,'product','Комплекты','',1,10,'2__25791','1391672265','1427228349','all',0),(29,2,'product','Комплекты','',1,10,'2__18316','1391672265','1427228349','all',0),(31,2,'product','Серьги','',1,10,'2__20181','1391672286','1427228355','all',0),(31,2,'product','Серьги','',1,10,'2__9962','1391672286','1427228355','all',0),(33,2,'product','Украшения РЅР° голову','',1,19,'2__3547','1391672326','1427228362','all',0),(33,2,'product','Украшения РЅР° голову','',1,19,'2__20600','1391672326','1427228362','all',0),(35,2,'product','Браслеты','',1,22,'2__849','1391672356','1427228331','all',0),(35,2,'product','Браслеты','',1,22,'2__18358','1391672356','1427228331','all',0),(37,2,'product','Броши','',1,25,'2__11447','1391672386','1427228338','all',0),(37,2,'product','Броши','',1,25,'2__31780','1391672386','1427228338','all',0); What's wrong?Thanks.")* Ok. I've deleted $sql = 'INSERT IGNORE INTO `#__hikashop_download` (`'.implode('`,`',array_keys($data)).'`) '. 'SELECT '.implode(',',$data).' FROM `#__mijoshop_download` AS mjd '. 'INNER JOIN `#__mijoshop_download_description` mjdd ON mjd.download_id = mjdd.download_id '. 'INNER JOIN `#__hikashop_file` AS hkf ON ( CONVERT(hkf.file_name USING utf8) = CONVERT(mjdd.name USING utf8) )'. 'INNER JOIN `#__mijoshop_product_to_download` AS mjpd ON mjd.download_id = mjpd.download_id '. 'INNER JOIN `#__mijoshop_order_product` AS mjop ON mjpd.product_id = mjop.product_id '. 'INNER JOIN `#__hikashop_order` AS hko ON hko.order_mijo_id = mjop.order_id '. 'WHERE mjd.download_id > '.$this->options->last_mijo_pfile; $this->db->setQuery($sql); $this->db->query(); $total = $this->db->getAffectedRows(); in "administrator/components/com_hikashop/helpers/import/mijo.php" and looks like import is over. But i can see only few categories from mijoshop, smallest categories. If i add an item to a cart and then remove it on the site, then i can see the list of all items i was need to import. They've been impoted! But i can't see them in admin panel. How i can see them there? Last edit: 11 years 6 months ago by [Sigizmunt](/forum/user/36822-sigizmunt "View Sigizmunt's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NzYyMTgtaW1wb3J0LWZyb20tbWlqb3Nob3AtZXJyb3I/dG1wbD1tYXJrZG93bg==) 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: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 11 years 6 months ago [\#198106](#198106) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Import from mijoshop error](/forum/37-import-export-csv-xls/876218-import-from-mijoshop-error#198106 "-- HikaShop version -- : 2.4.0 -- Joomla version -- : 3.4.1 -- Error-message(debug-mod must be tuned on) -- : Error Hello. Can't import data from mijoshop. There's an error message: Duplicate entry '27' for key 'PRIMARY' SQL=INSERT INTO `w21aqq_hikashop_category` (`category_id`,`category_parent_id`,`category_type`,`category_name`,`category_description`,`category_published`,`category_ordering`,`category_namekey`,`category_created`,`category_modified`,`category_access`,`category_menu`) VALUES (27,2,'product','Колье Рё украшения РЅР° шею','',1,7,'2__10777','1391672241','1427228343','all',0),(27,2,'product','Колье Рё украшения РЅР° шею','',1,7,'2__15070','1391672241','1427228343','all',0),(29,2,'product','Комплекты','',1,10,'2__25791','1391672265','1427228349','all',0),(29,2,'product','Комплекты','',1,10,'2__18316','1391672265','1427228349','all',0),(31,2,'product','Серьги','',1,10,'2__20181','1391672286','1427228355','all',0),(31,2,'product','Серьги','',1,10,'2__9962','1391672286','1427228355','all',0),(33,2,'product','Украшения РЅР° голову','',1,19,'2__3547','1391672326','1427228362','all',0),(33,2,'product','Украшения РЅР° голову','',1,19,'2__20600','1391672326','1427228362','all',0),(35,2,'product','Браслеты','',1,22,'2__849','1391672356','1427228331','all',0),(35,2,'product','Браслеты','',1,22,'2__18358','1391672356','1427228331','all',0),(37,2,'product','Броши','',1,25,'2__11447','1391672386','1427228338','all',0),(37,2,'product','Броши','',1,25,'2__31780','1391672386','1427228338','all',0); What's wrong?Thanks.")* Hi, Thanks for your feedback and report. Which version of Mijoshop are you using ? It looks like the table "mijoshop_download_description" has changed and does not have the column "remaining" anymore ; so I'm wondering where that information is now stored. About the products, the best is to check in your backend. It is possible that the product has been imported in the the root category instead of the right product category (which has not been imported for an unknown reason ; but if you say that few categories has been imported, I think that could explain the products in a wrong category) Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NzYyMTgtaW1wb3J0LWZyb20tbWlqb3Nob3AtZXJyb3I/dG1wbD1tYXJrZG93bg==) 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.303 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)