Error when importing from virtuemart

  • Posts: 21
  • Thank you received: 3
11 years 9 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: 85611
  • Thank you received: 14022
  • MODERATOR
11 years 9 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.

This attachment is hidden for guests.
Please log in or register to see it.

This message has an attachment file.
Please log in or register to see it.

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

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

That worked. Thanks!

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

Time to create page: 0.045 seconds
Powered by Kunena Forum