Product are not imported from RedShop (1064)

-- 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.

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:

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

Hi,
Please see att. There is all what i see. Debug mode is ON in config.

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 :/ , 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 ).
:/
I have some time, but editing almost 1300 products will take a veeeery long time :/

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 ...

Hi Nicolas,
I understand, and i will try to migrate manually.
Thank you for your time and help.

Best Regards
Wojciech