Import issue on Virtumart 2

-- url of the page with the problem -- : mywebsite.com/mypage
-- HikaShop version -- : 2.3.1
-- Joomla version -- : 3.3
MySQL is localhost 5.5.2
Hi Just tried to run an import from VM and all goes well until it gets to category then it generates:

---

An error has occurred.

1064 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 '34),(,35),(,36)' at line 1 SQL=INSERT IGNORE INTO `izkd4_hikashop_vm_cat` (`vm_id`,`hk_id`) VALUES (5,14),(10,15),(11,16),(12,17),(18,18),(6,19),(7,20),(8,21),(9,22),(20,23),(13,24),(14,25),(15,26),(16,27),(17,28),(21,29),(22,30),(23,31),(24,32),(25,33),(,34),(,35),(,36);

Can you explain and let me know what I need to do to fix and get this loaded in, (do I need to empty any tables?)

Many THanks

Tony

update : I have checed the vm category table and the last 3 entries are their 27.28,29 but the routine is not picking them up.

Hi,
I really need some answers, on this, i have a 3 day deadline to convert the entire customers site or i will likely not bet paid, and not being able to import his vm records is stopping any progress.

Please help
Thanks

Tony

Hi Nicolas,
yes it ran through now without those errors, however as it was going through I did see a few errors saying image already exists which I quess is fine but it still not worked:

1. All categories except for 1 are in twice and only one has a category image
2. virtually no products are showing and the 4 it did import are in the completely wrong category.
3. THe products must exist as I can see them on a customer order with their images.

What do I need to do?

Thanks

Tony

update:
Vat was imported at 2000 not 20 but I have fixed that.
Also I have looked in phymyadmin and all the categories and products are there and the prod/cat refence table looks ok.

I have looked in more detail at the category table and can see the issue, Each category is actual in it 3 times but the last time the category does not point to root it loops in itself, ie category 66 has parent 77 but category 77 has parent 66 .
Is there a way to recreate this table easily?

Thanks

Tony

Hi Nicolas,
As this project was urgent I have managed to correct all the product category issues by directly amending the product/category cross reference table and the vm category cross reference table and now everything looks pretty good. The only thing that I could not find is which database table contains the links to the category images.

If you could tell me this I think that I may be sorted for now and can at least show my customer some progress.

Thanks


Tony

Hi,

The table in question is "#__hikashop_file", in the column "file_type" you can find the "category" type.