[Skip to main content](#vessel-content) # Product are not imported from RedShop (1064) ## - **[Labas](/forum/user/39243-labas "View Labas's Profile")** - [![Labas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar39243.jpg)](/forum/user/39243-labas "View Labas's Profile") Topic Author - [ Offline](/forum/user/39243-labas) Less More - Posts: 37 - Thank you received: 0 - - - 10 years 11 months ago - 10 years 11 months ago [\#221585](#221585) by [Labas](/forum/user/39243-labas "View Labas's Profile") *[Product are not imported from RedShop (1064)](/forum/37-import-export-csv-xls/880636-product-are-not-imported-from-redshop-1064#221585 "-- HikaShop version -- : Starter -- Joomla version -- : 3.4.5 -- PHP version -- : 5.5.19 -- Browser(s) name and version -- : FF 42 -- Error-message(debug-mod must be tuned on) -- : "1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '81,'product',(...)" Hello HikaShop World! :) After a long time, i decided to migrate from RedShop to HikaShop. I am working on my local machine for tests. I have installed HikaShop, and started import from RedShop. Unfortunatelly, after step 4, i get error like attached. I see manufacturers, categories, taxes ect ... but products are not imported :( I was searching for solution, but couldn't find :/ I am using MySQLi Maybe can you suggest something ?? Maybe ESSENTIAL version will handle that?? EDIT: I tried to import via CSV file but i get blang page in result :( Best Regards Wojciech")* was created by *[Labas](/forum/user/39243-labas "View Labas's Profile")* -- HikaShop version -- : Starter -- Joomla version -- : 3.4.5 -- PHP version -- : 5.5.19 -- Browser(s) name and version -- : FF 42 -- Error-message(debug-mod must be tuned on) -- : "1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '81,'product',(...)" Hello HikaShop World! ![:)](/media/kunena/emoticons/8.png ":)") After a long time, i decided to migrate from RedShop to HikaShop. I am working on my local machine for tests. I have installed HikaShop, and started import from RedShop. Unfortunatelly, after step 4, i get error like attached. I see manufacturers, categories, taxes ect ... but products are not imported ![:(](/media/kunena/emoticons/5.png ":(") I was searching for solution, but couldn't find ![:/](/irritated.gif ":/") I am using MySQLi Maybe can you suggest something ?? Maybe ESSENTIAL version will handle that?? EDIT: I tried to import via CSV file but i get blang page in result ![:(](/media/kunena/emoticons/5.png ":(") Best Regards Wojciech Last edit: 10 years 11 months ago by [Labas](/forum/user/39243-labas "View Labas's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84ODA2MzYtcHJvZHVjdC1hcmUtbm90LWltcG9ydGVkLWZyb20tcmVkc2hvcC0xMDY0P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[charlesdh](/forum/user/33634-charlesdh "View charlesdh's Profile")** - [![charlesdh's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar33634.jpg)](/forum/user/33634-charlesdh "View charlesdh's Profile") - [ Offline](/forum/user/33634-charlesdh) - Proficient with Excel Less More - Posts: 36 - Thank you received: 5 - - - - 10 years 11 months ago [\#221675](#221675) by [charlesdh](/forum/user/33634-charlesdh "View charlesdh's Profile") Replied by *[charlesdh](/forum/user/33634-charlesdh "View charlesdh's Profile")* on topic *[Product are not imported from RedShop (1064)](/forum/37-import-export-csv-xls/880636-product-are-not-imported-from-redshop-1064#221675 "-- HikaShop version -- : Starter -- Joomla version -- : 3.4.5 -- PHP version -- : 5.5.19 -- Browser(s) name and version -- : FF 42 -- Error-message(debug-mod must be tuned on) -- : "1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '81,'product',(...)" Hello HikaShop World! :) After a long time, i decided to migrate from RedShop to HikaShop. I am working on my local machine for tests. I have installed HikaShop, and started import from RedShop. Unfortunatelly, after step 4, i get error like attached. I see manufacturers, categories, taxes ect ... but products are not imported :( I was searching for solution, but couldn't find :/ I am using MySQLi Maybe can you suggest something ?? Maybe ESSENTIAL version will handle that?? EDIT: I tried to import via CSV file but i get blang page in result :( Best Regards Wojciech")* Hi, I'm not a "HikaShop" expert. But, I believe if the Header for your CSV file is not correct this may be the problem. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84ODA2MzYtcHJvZHVjdC1hcmUtbm90LWltcG9ydGVkLWZyb20tcmVkc2hvcC0xMDY0P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86287 - Thank you received: 14264 - - 10 years 11 months ago [\#221684](#221684) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Product are not imported from RedShop (1064)](/forum/37-import-export-csv-xls/880636-product-are-not-imported-from-redshop-1064#221684 "-- HikaShop version -- : Starter -- Joomla version -- : 3.4.5 -- PHP version -- : 5.5.19 -- Browser(s) name and version -- : FF 42 -- Error-message(debug-mod must be tuned on) -- : "1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '81,'product',(...)" Hello HikaShop World! :) After a long time, i decided to migrate from RedShop to HikaShop. I am working on my local machine for tests. I have installed HikaShop, and started import from RedShop. Unfortunatelly, after step 4, i get error like attached. I see manufacturers, categories, taxes ect ... but products are not imported :( I was searching for solution, but couldn't find :/ I am using MySQLi Maybe can you suggest something ?? Maybe ESSENTIAL version will handle that?? EDIT: I tried to import via CSV file but i get blang page in result :( Best Regards Wojciech")* Hi, Upgrading to the Essential edition won't help. You'll get the same error. Could you try again with the "debug mode" setting of the Joomla configuration turned on ? Do you get additional debug data on the page when that error happen ? If so, could you provide it ? It would help in understanding what's going on. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84ODA2MzYtcHJvZHVjdC1hcmUtbm90LWltcG9ydGVkLWZyb20tcmVkc2hvcC0xMDY0P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Labas](/forum/user/39243-labas "View Labas's Profile")** - [![Labas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar39243.jpg)](/forum/user/39243-labas "View Labas's Profile") Topic Author - [ Offline](/forum/user/39243-labas) Less More - Posts: 37 - Thank you received: 0 - - - 10 years 11 months ago - 10 years 11 months ago [\#221698](#221698) by [Labas](/forum/user/39243-labas "View Labas's Profile") Replied by *[Labas](/forum/user/39243-labas "View Labas's Profile")* on topic *[Product are not imported from RedShop (1064)](/forum/37-import-export-csv-xls/880636-product-are-not-imported-from-redshop-1064#221698 "-- HikaShop version -- : Starter -- Joomla version -- : 3.4.5 -- PHP version -- : 5.5.19 -- Browser(s) name and version -- : FF 42 -- Error-message(debug-mod must be tuned on) -- : "1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '81,'product',(...)" Hello HikaShop World! :) After a long time, i decided to migrate from RedShop to HikaShop. I am working on my local machine for tests. I have installed HikaShop, and started import from RedShop. Unfortunatelly, after step 4, i get error like attached. I see manufacturers, categories, taxes ect ... but products are not imported :( I was searching for solution, but couldn't find :/ I am using MySQLi Maybe can you suggest something ?? Maybe ESSENTIAL version will handle that?? EDIT: I tried to import via CSV file but i get blang page in result :( Best Regards Wojciech")* Hi, @charlesdh, CSV file is generated in RedShop, and i think it is "standard" CSV file, with "standard" header. @nicolas Sure, i checked it with Debug mode on, and all what i get is: Code: Call stack # Function Location 1 JApplicationCms->execute() C:\xampp\htdocs\fryzjer\administrator\index.php:47 2 JApplicationAdministrator->doExecute() C:\xampp\htdocs\fryzjer\libraries\cms\application\cms.php:252 3 JApplicationAdministrator->dispatch() C:\xampp\htdocs\fryzjer\libraries\cms\application\administrator.php:152 4 JComponentHelper::renderComponent() C:\xampp\htdocs\fryzjer\libraries\cms\application\administrator.php:98 5 JComponentHelper::executeComponent() C:\xampp\htdocs\fryzjer\libraries\cms\component\helper.php:372 6 require_once() C:\xampp\htdocs\fryzjer\libraries\cms\component\helper.php:392 7 hikashopController->execute() C:\xampp\htdocs\fryzjer\administrator\components\com_hikashop\hikashop.php:54 8 JControllerLegacy->execute() C:\xampp\htdocs\fryzjer\administrator\components\com_hikashop\helpers\helper.php:1601 9 ImportController->import() C:\xampp\htdocs\fryzjer\libraries\legacy\controller\legacy.php:728 10 ImportController->_redshop() C:\xampp\htdocs\fryzjer\administrator\components\com_hikashop\controllers\import.php:102 11 hikashopImportredsHelper->importFromRedshop() C:\xampp\htdocs\fryzjer\administrator\components\com_hikashop\controllers\import.php:151 12 hikashopImportredsHelper->doImport() C:\xampp\htdocs\fryzjer\administrator\components\com_hikashop\helpers\import\reds.php:41 13 hikashopImportredsHelper->importCategories() C:\xampp\htdocs\fryzjer\administrator\components\com_hikashop\helpers\import\reds.php:94 14 JDatabase->query() C:\xampp\htdocs\fryzjer\administrator\components\com_hikashop\helpers\import\reds.php:753 15 RDatabaseDriverMysqli->execute() C:\xampp\htdocs\fryzjer\libraries\joomla\database\database.php:33 16 JDatabaseDriverMysqli->execute() C:\xampp\htdocs\fryzjer\libraries\redcore\database\driver\mysqli.php:71 That is all. Thank you for you time. EDIT: I tried today on backup of site on my server (second FTP) , but result was the same. No products imported. Last edit: 10 years 11 months ago by [Labas](/forum/user/39243-labas "View Labas's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84ODA2MzYtcHJvZHVjdC1hcmUtbm90LWltcG9ydGVkLWZyb20tcmVkc2hvcC0xMDY0P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86287 - Thank you received: 14264 - - 10 years 11 months ago [\#221704](#221704) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Product are not imported from RedShop (1064)](/forum/37-import-export-csv-xls/880636-product-are-not-imported-from-redshop-1064#221704 "-- HikaShop version -- : Starter -- Joomla version -- : 3.4.5 -- PHP version -- : 5.5.19 -- Browser(s) name and version -- : FF 42 -- Error-message(debug-mod must be tuned on) -- : "1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '81,'product',(...)" Hello HikaShop World! :) After a long time, i decided to migrate from RedShop to HikaShop. I am working on my local machine for tests. I have installed HikaShop, and started import from RedShop. Unfortunatelly, after step 4, i get error like attached. I see manufacturers, categories, taxes ect ... but products are not imported :( I was searching for solution, but couldn't find :/ I am using MySQLi Maybe can you suggest something ?? Maybe ESSENTIAL version will handle that?? EDIT: I tried to import via CSV file but i get blang page in result :( Best Regards Wojciech")* Hi, But could you provide the full query mentioned in the error message ? You should be able to see it either in the queries debug area at the bottom, or just below the "1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '81,'product',(...)" error message. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84ODA2MzYtcHJvZHVjdC1hcmUtbm90LWltcG9ydGVkLWZyb20tcmVkc2hvcC0xMDY0P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Labas](/forum/user/39243-labas "View Labas's Profile")** - [![Labas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar39243.jpg)](/forum/user/39243-labas "View Labas's Profile") Topic Author - [ Offline](/forum/user/39243-labas) Less More - Posts: 37 - Thank you received: 0 - - - 10 years 11 months ago - 10 years 11 months ago [\#221747](#221747) by [Labas](/forum/user/39243-labas "View Labas's Profile") Replied by *[Labas](/forum/user/39243-labas "View Labas's Profile")* on topic *[Product are not imported from RedShop (1064)](/forum/37-import-export-csv-xls/880636-product-are-not-imported-from-redshop-1064#221747 "-- HikaShop version -- : Starter -- Joomla version -- : 3.4.5 -- PHP version -- : 5.5.19 -- Browser(s) name and version -- : FF 42 -- Error-message(debug-mod must be tuned on) -- : "1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '81,'product',(...)" Hello HikaShop World! :) After a long time, i decided to migrate from RedShop to HikaShop. I am working on my local machine for tests. I have installed HikaShop, and started import from RedShop. Unfortunatelly, after step 4, i get error like attached. I see manufacturers, categories, taxes ect ... but products are not imported :( I was searching for solution, but couldn't find :/ I am using MySQLi Maybe can you suggest something ?? Maybe ESSENTIAL version will handle that?? EDIT: I tried to import via CSV file but i get blang page in result :( Best Regards Wojciech")* Hi, Please see att. There is all what i see. Debug mode is ON in config. [ ![error.png](/forum/attachment/27934) ](/forum/attachment/27934 "error.png") Nicolas, if you want, i can give you admin acces to online site (test), where i have the same issue. If yes, please PM me. - [ ![error.png](/forum/attachment/27934) ](/forum/attachment/27934 "error.png") [ ](/forum/attachment/27934?download=1 "error.png") Last edit: 10 years 11 months ago by [Labas](/forum/user/39243-labas "View Labas's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84ODA2MzYtcHJvZHVjdC1hcmUtbm90LWltcG9ydGVkLWZyb20tcmVkc2hvcC0xMDY0P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86287 - Thank you received: 14264 - - 10 years 10 months ago [\#221804](#221804) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Product are not imported from RedShop (1064)](/forum/37-import-export-csv-xls/880636-product-are-not-imported-from-redshop-1064#221804 "-- HikaShop version -- : Starter -- Joomla version -- : 3.4.5 -- PHP version -- : 5.5.19 -- Browser(s) name and version -- : FF 42 -- Error-message(debug-mod must be tuned on) -- : "1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '81,'product',(...)" Hello HikaShop World! :) After a long time, i decided to migrate from RedShop to HikaShop. I am working on my local machine for tests. I have installed HikaShop, and started import from RedShop. Unfortunatelly, after step 4, i get error like attached. I see manufacturers, categories, taxes ect ... but products are not imported :( I was searching for solution, but couldn't find :/ I am using MySQLi Maybe can you suggest something ?? Maybe ESSENTIAL version will handle that?? EDIT: I tried to import via CSV file but i get blang page in result :( Best Regards Wojciech")* Hi, Change the line: Code: $id = $ids[$data->category_id]; to: Code: $id = (int)$ids[$data->category_id]; in the file administrator/components/com_hikashop/helpers/import/reds.php and that should hopefully fix the problem. The following user(s) said Thank You: [Labas](/forum/user/39243-labas "View Labas's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84ODA2MzYtcHJvZHVjdC1hcmUtbm90LWltcG9ydGVkLWZyb20tcmVkc2hvcC0xMDY0P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Labas](/forum/user/39243-labas "View Labas's Profile")** - [![Labas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar39243.jpg)](/forum/user/39243-labas "View Labas's Profile") Topic Author - [ Offline](/forum/user/39243-labas) Less More - Posts: 37 - Thank you received: 0 - - - 10 years 10 months ago - 10 years 10 months ago [\#221856](#221856) by [Labas](/forum/user/39243-labas "View Labas's Profile") Replied by *[Labas](/forum/user/39243-labas "View Labas's Profile")* on topic *[Product are not imported from RedShop (1064)](/forum/37-import-export-csv-xls/880636-product-are-not-imported-from-redshop-1064#221856 "-- HikaShop version -- : Starter -- Joomla version -- : 3.4.5 -- PHP version -- : 5.5.19 -- Browser(s) name and version -- : FF 42 -- Error-message(debug-mod must be tuned on) -- : "1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '81,'product',(...)" Hello HikaShop World! :) After a long time, i decided to migrate from RedShop to HikaShop. I am working on my local machine for tests. I have installed HikaShop, and started import from RedShop. Unfortunatelly, after step 4, i get error like attached. I see manufacturers, categories, taxes ect ... but products are not imported :( I was searching for solution, but couldn't find :/ I am using MySQLi Maybe can you suggest something ?? Maybe ESSENTIAL version will handle that?? EDIT: I tried to import via CSV file but i get blang page in result :( Best Regards Wojciech")* Thank You Nicolas, Product import works perfect. Unfortunatelly i see another issue. After import, product is not assigned to manufacturer (on localhost manufacturers were imported, online - no ![:/](/irritated.gif ":/") , but on localhost product also do not have assigned manufacturer). Product code is wrong, tax is not assigned, quantity of all is set to 0 and ... i do not see products on frontpage (yes, they are published ![:)](/media/kunena/emoticons/8.png ":)") ). ![:/](/irritated.gif ":/") I have some time, but editing almost 1300 products will take a veeeery long time ![:/](/irritated.gif ":/") EDIT: I will uninstall Hikashop and try everythinf again with your fix. EDIT2: After new installation (tables in DB also deleted), only products were imported. No Manufacturers, Users, Orders, taxes ect ... ![:(](/media/kunena/emoticons/5.png ":(") Last edit: 10 years 10 months ago by [Labas](/forum/user/39243-labas "View Labas's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84ODA2MzYtcHJvZHVjdC1hcmUtbm90LWltcG9ydGVkLWZyb20tcmVkc2hvcC0xMDY0P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86287 - Thank you received: 14264 - - 10 years 10 months ago [\#221870](#221870) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Product are not imported from RedShop (1064)](/forum/37-import-export-csv-xls/880636-product-are-not-imported-from-redshop-1064#221870 "-- HikaShop version -- : Starter -- Joomla version -- : 3.4.5 -- PHP version -- : 5.5.19 -- Browser(s) name and version -- : FF 42 -- Error-message(debug-mod must be tuned on) -- : "1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '81,'product',(...)" Hello HikaShop World! :) After a long time, i decided to migrate from RedShop to HikaShop. I am working on my local machine for tests. I have installed HikaShop, and started import from RedShop. Unfortunatelly, after step 4, i get error like attached. I see manufacturers, categories, taxes ect ... but products are not imported :( I was searching for solution, but couldn't find :/ I am using MySQLi Maybe can you suggest something ?? Maybe ESSENTIAL version will handle that?? EDIT: I tried to import via CSV file but i get blang page in result :( Best Regards Wojciech")* Hi, Well it's hard to say. The import from RedShop was written a few years ago. If you have a recent version of RedShop, I suppose many things changed since then, and not many people migrate from RedShop, so I suppose that it might require changes in the code of the import to support the changes of the recent version of RedShop in order to have something working smoothly and it won't be easy either. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84ODA2MzYtcHJvZHVjdC1hcmUtbm90LWltcG9ydGVkLWZyb20tcmVkc2hvcC0xMDY0P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Labas](/forum/user/39243-labas "View Labas's Profile")** - [![Labas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar39243.jpg)](/forum/user/39243-labas "View Labas's Profile") Topic Author - [ Offline](/forum/user/39243-labas) Less More - Posts: 37 - Thank you received: 0 - - - 10 years 10 months ago [\#221993](#221993) by [Labas](/forum/user/39243-labas "View Labas's Profile") Replied by *[Labas](/forum/user/39243-labas "View Labas's Profile")* on topic *[Product are not imported from RedShop (1064)](/forum/37-import-export-csv-xls/880636-product-are-not-imported-from-redshop-1064#221993 "-- HikaShop version -- : Starter -- Joomla version -- : 3.4.5 -- PHP version -- : 5.5.19 -- Browser(s) name and version -- : FF 42 -- Error-message(debug-mod must be tuned on) -- : "1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '81,'product',(...)" Hello HikaShop World! :) After a long time, i decided to migrate from RedShop to HikaShop. I am working on my local machine for tests. I have installed HikaShop, and started import from RedShop. Unfortunatelly, after step 4, i get error like attached. I see manufacturers, categories, taxes ect ... but products are not imported :( I was searching for solution, but couldn't find :/ I am using MySQLi Maybe can you suggest something ?? Maybe ESSENTIAL version will handle that?? EDIT: I tried to import via CSV file but i get blang page in result :( Best Regards Wojciech")* Hi Nicolas, I understand, and i will try to migrate manually. Thank you for your time and help. Best Regards Wojciech Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84ODA2MzYtcHJvZHVjdC1hcmUtbm90LWltcG9ydGVkLWZyb20tcmVkc2hvcC0xMDY0P3RtcGw9bWFya2Rvd24=) 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.367 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)