Error when importing from virtuemart

  • Posts: 21
  • Thank you received: 3
12 years 4 weeks 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: 86089
  • Thank you received: 14195
  • MODERATOR
12 years 4 weeks 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
12 years 4 weeks ago #166391

That worked. Thanks!

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

Time to create page: 0.074 seconds
Powered by Kunena Forum