[Skip to main content](#vessel-content) # error while importing data from mijoshop 3 ## - **[ialmotery](/forum/user/35782-ialmotery "View ialmotery's Profile")** - [![ialmotery's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/35782-ialmotery "View ialmotery's Profile") Topic Author - [ Offline](/forum/user/35782-ialmotery) Less More - Posts: 2 - Thank you received: 0 - - 11 years 9 months ago - 11 years 9 months ago [\#187072](#187072) by [ialmotery](/forum/user/35782-ialmotery "View ialmotery's Profile") *[error while importing data from mijoshop 3](/forum/25-install-update/874318-error-while-importing-data-from-mijoshop-3#187072 "-- HikaShop version -- : 2.3.5 -- Joomla version -- : 3.3.6 -- Error-message(debug-mod must be tuned on) -- : An error has occurred. 1054 Unknown column 'SAR' in 'field list' SQL=INSERT IGNORE INTO jos_hikashop_discount (`discount_type`,`discount_start`,`discount_end`,`discount_quota`,`discount_quota_per_user`,`discount_published`,`discount_code`,`discount_currency_id`,`discount_flat_amount`,`discount_percent_amount`) SELECT 'coupon',date_start,date_end,0,uses_customer,status,code,SAR,case when type = 'F' then discount else 0 end,case when type = 'P' then discount else 0 end FROM jos_mijoshop_coupon WHERE coupon_id > 0 Hi, appears while importing from mijoshop, products are imported correctly, but orders and address not.")* was created by *[ialmotery](/forum/user/35782-ialmotery "View ialmotery's Profile")* -- HikaShop version -- : 2.3.5 -- Joomla version -- : 3.3.6 -- Error-message(debug-mod must be tuned on) -- : An error has occurred. 1054 Unknown column 'SAR' in 'field list' SQL=INSERT IGNORE INTO jos_hikashop_discount (`discount_type`,`discount_start`,`discount_end`,`discount_quota`,`discount_quota_per_user`,`discount_published`,`discount_code`,`discount_currency_id`,`discount_flat_amount`,`discount_percent_amount`) SELECT 'coupon',date_start,date_end,0,uses_customer,status,code,SAR,case when type = 'F' then discount else 0 end,case when type = 'P' then discount else 0 end FROM jos_mijoshop_coupon WHERE coupon_id > 0 Hi, appears while importing from mijoshop, products are imported correctly, but orders and address not. Last edit: 11 years 9 months ago by [ialmotery](/forum/user/35782-ialmotery "View ialmotery's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg3NDMxOC1lcnJvci13aGlsZS1pbXBvcnRpbmctZGF0YS1mcm9tLW1pam9zaG9wLTM/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 9 months ago [\#187074](#187074) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[error while importing data from mijoshop 3](/forum/25-install-update/874318-error-while-importing-data-from-mijoshop-3#187074 "-- HikaShop version -- : 2.3.5 -- Joomla version -- : 3.3.6 -- Error-message(debug-mod must be tuned on) -- : An error has occurred. 1054 Unknown column 'SAR' in 'field list' SQL=INSERT IGNORE INTO jos_hikashop_discount (`discount_type`,`discount_start`,`discount_end`,`discount_quota`,`discount_quota_per_user`,`discount_published`,`discount_code`,`discount_currency_id`,`discount_flat_amount`,`discount_percent_amount`) SELECT 'coupon',date_start,date_end,0,uses_customer,status,code,SAR,case when type = 'F' then discount else 0 end,case when type = 'P' then discount else 0 end FROM jos_mijoshop_coupon WHERE coupon_id > 0 Hi, appears while importing from mijoshop, products are imported correctly, but orders and address not.")* Hi, The Mijoshop import is compatible with Mijoshop 2.x ; not with Mijoshop 3. I guess that the database structure is different ; that's why you got the SQL error and some data are not imported properly. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg3NDMxOC1lcnJvci13aGlsZS1pbXBvcnRpbmctZGF0YS1mcm9tLW1pam9zaG9wLTM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[ialmotery](/forum/user/35782-ialmotery "View ialmotery's Profile")** - [![ialmotery's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/35782-ialmotery "View ialmotery's Profile") Topic Author - [ Offline](/forum/user/35782-ialmotery) Less More - Posts: 2 - Thank you received: 0 - - 11 years 9 months ago [\#187166](#187166) by [ialmotery](/forum/user/35782-ialmotery "View ialmotery's Profile") Replied by *[ialmotery](/forum/user/35782-ialmotery "View ialmotery's Profile")* on topic *[error while importing data from mijoshop 3](/forum/25-install-update/874318-error-while-importing-data-from-mijoshop-3#187166 "-- HikaShop version -- : 2.3.5 -- Joomla version -- : 3.3.6 -- Error-message(debug-mod must be tuned on) -- : An error has occurred. 1054 Unknown column 'SAR' in 'field list' SQL=INSERT IGNORE INTO jos_hikashop_discount (`discount_type`,`discount_start`,`discount_end`,`discount_quota`,`discount_quota_per_user`,`discount_published`,`discount_code`,`discount_currency_id`,`discount_flat_amount`,`discount_percent_amount`) SELECT 'coupon',date_start,date_end,0,uses_customer,status,code,SAR,case when type = 'F' then discount else 0 end,case when type = 'P' then discount else 0 end FROM jos_mijoshop_coupon WHERE coupon_id > 0 Hi, appears while importing from mijoshop, products are imported correctly, but orders and address not.")* Don't know much about that but, I assumed the problem was the default currency of my hikashop which was SAR, saudi arabian riyal. When I changed it to dollar, and tried importing again, it continues to import with no problem but it stopped at "downloadable products" step. with that error below. ---- 1054 Unknown column 'mjd.remaining' in 'field list' SQL=INSERT IGNORE INTO `jos_hikashop_download` (`file_id`,`order_id`,`download_number`) SELECT hkf.file_id,hko.order_id,(50- mjd.remaining) FROM `jos_mijoshop_download` AS mjd INNER JOIN `jos_mijoshop_download_description` mjdd ON mjd.download_id = mjdd.download_id INNER JOIN `jos_hikashop_file` AS hkf ON ( CONVERT(hkf.file_name USING utf8) = CONVERT(mjdd.name USING utf8) )INNER JOIN `jos_mijoshop_product_to_download` AS mjpd ON mjd.download_id = mjpd.download_id INNER JOIN `jos_mijoshop_order_product` AS mjop ON mjpd.product_id = mjop.product_id INNER JOIN `jos_hikashop_order` AS hko ON hko.order_mijo_id = mjop.order_id WHERE mjd.download_id > 0 ---- Are there any plans to update the mijoshop import thing? soon? or to fix this problem. thank you Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg3NDMxOC1lcnJvci13aGlsZS1pbXBvcnRpbmctZGF0YS1mcm9tLW1pam9zaG9wLTM/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 9 months ago [\#187212](#187212) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[error while importing data from mijoshop 3](/forum/25-install-update/874318-error-while-importing-data-from-mijoshop-3#187212 "-- HikaShop version -- : 2.3.5 -- Joomla version -- : 3.3.6 -- Error-message(debug-mod must be tuned on) -- : An error has occurred. 1054 Unknown column 'SAR' in 'field list' SQL=INSERT IGNORE INTO jos_hikashop_discount (`discount_type`,`discount_start`,`discount_end`,`discount_quota`,`discount_quota_per_user`,`discount_published`,`discount_code`,`discount_currency_id`,`discount_flat_amount`,`discount_percent_amount`) SELECT 'coupon',date_start,date_end,0,uses_customer,status,code,SAR,case when type = 'F' then discount else 0 end,case when type = 'P' then discount else 0 end FROM jos_mijoshop_coupon WHERE coupon_id > 0 Hi, appears while importing from mijoshop, products are imported correctly, but orders and address not.")* Hi, I created a task in the TODO list but I can't provide any schedule. When we create the first mijoshop import ; it was for a customer request, which allow us to have a guy on the project at full time and which also gave us the package and a "sample store". Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg3NDMxOC1lcnJvci13aGlsZS1pbXBvcnRpbmctZGF0YS1mcm9tLW1pam9zaG9wLTM/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.136 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)