Error when importing from virtuemart

  • Posts: 21
  • Thank you received: 3
10 years 3 months ago #166319

-- HikaShop version -- : 2.3.2
-- Joomla version -- : 3.3.3
-- PHP version -- : 5.3

I'm getting the following error when trying to import from virtuemart:

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 '' at line 1 SQL=INSERT IGNORE INTO `dmqzj_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 ;

What can I do to fix this?

Please Log in or Create an account to join the conversation.

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
10 years 3 months ago #166376

Hi,

Replace the file "administrator/components/com_hikashop/helpers/importvm.php with the one in the archive enclosed and try again. That should avoid the problem.

File Attachment:

File Name: importvm.zip
File Size:14 KB

Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 21
  • Thank you received: 3
10 years 3 months ago #166391

That worked. Thanks!

Please Log in or Create an account to join the conversation.

Time to create page: 0.062 seconds
Powered by Kunena Forum