- Posts: 193
- Thank you received: 76
Categories from Virtuemart not imported
11 years 11 months ago #175816
by korzo
Categories from Virtuemart not imported was created by korzo
-- 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
solved the problem and categories were imported, but it's horrible hack.
-- 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
Code:
SELECT *,vmc.virtuemart_category_id ...
Please Log in or Create an account to join the conversation.
11 years 11 months ago - 11 years 11 months ago #175838
by Jerome
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.
Replied by Jerome on topic Categories from Virtuemart not imported
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
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,
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
Code:
SELECT *, vmc.virtuemart_category_id as vmid, hkvm.vm_id as vm_cat_id, hkvmp.vm_id as vm_parent_id FROM
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: 11 years 11 months ago by Jerome.
Please Log in or Create an account to join the conversation.
Time to create page: 0.137 seconds