Product category issues post virtuemart upgrade

[ufo_hk]

Hi,

Site: www.firstmoments.co.nz
joomla: 3.9.0
Virtuemart: 3.4.2
php: 7.1.6

Recently upgraded this site (joomla and virtuemart) and am now experiencing problems with assigning categories to new products or changing the category of an existing product.

The "Product Categories" list shows only the option: Do Not Store

While the "Force canonical category" shows the full list of categories.

When I add a new category to the Product Categories - it adds it to the "Force canonical category" list. ??

When I create a new product from scratch or via clone and I save the product I get an error msg: 1062 Duplicate entry '99-0' for key 'virtuemart_product_id'

The product is saved - however the "Product Category" column has "CanonCat:" in it for that product.

Things I have tried:
Clear caches and different browsers - no change.
Enabled Debug mode - but don't see any messages which seem relevant.

Any assistance in sorting this issue will be appreciated.
Thanks

[hellorain]

Hello,

i can help you!!


Best Regards,
hellorain.

[chrisb_]

Hello,
I have exactly the same problem. Is there any solution yet?

Thanks

[jenkinhill]

Have you tried the latest VM 3.4.3.9989 ?

[chrisb_]

Yes i have that version installed

[GJC Web Design]

have you an admin template over rides?

[chrisb_]

No, I don't have template overrides.

But, I have also noticed a javascript error in product edit page:
TypeError: n.fancybox.defaults is undefined

[jenkinhill]

See http://forum.virtuemart.net/index.php?topic=137040.msg484373#msg484373

and see http://forum.virtuemart.net/index.php?topic=137040.msg491184#msg491184  and below.