Categories from Virtuemart not imported

  • Posts: 193
  • Thank you received: 76
10 years 1 month ago #175816

-- HikaShop version -- : 2.3.3
-- Joomla version -- : 2.5.27
-- PHP version -- : 5.3.16

Today I tried import from Virtuemart 2.6.10 and categories are not imported to Hikashop.
The problem is in the file administrator\components\com_hikashop\helpers\importvm.php at the line 857.

Result set from this query has several columns virtuemart_category_id and last one is always NULL.
Because of this $c->virtuemart_category_id on following lines is always NULL, array $ids has only one element and queries on lines 1018 and 1034 silently fail with duplicate keys error.

This change

SELECT *,vmc.virtuemart_category_id ...
solved the problem and categories were imported, but it's horrible hack.

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

  • Posts: 26158
  • Thank you received: 4028
  • MODERATOR
10 years 1 month ago #175838

Hi,

Thanks for your feedback.
I worked on the VM import Monday and I changed some elements in the import of categories.
We changed some elements in the queries in order to have a better import with high number of categories (like it was for VM1).
The query now starts with

SELECT *, vmc.virtuemart_category_id as vmid, hkvm.vm_id as vm_cat_id, hkvmp.vm_id as vm_parent_id FROM
And we use "vmid" instead of "virtuemart_category_id" (and we also use "vm_cat_id" and "vm_parent_id" for the import resume).

The improvements of the import will be in HikaShop 2.3.4 that we want to release next week.

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.
Last edit: 10 years 1 month ago by Jerome.

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

Time to create page: 0.057 seconds
Powered by Kunena Forum