Author Topic: product creation  (Read 600 times)


  • Beginner
  • *
  • Posts: 1
product creation
« on: May 08, 2019, 14:53:32 pm »

joomla: 3.9.6
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.

An error has occurred.
1062 Duplicate entry '148-0' for key 'virtuemart_product_id'

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.


  • UK Web Developer & Consultant
  • Global Moderator
  • Super Hero
  • *
  • Posts: 27734
  • Always on vacation
    • Jenkin Hill Internet
Re: product creation
« Reply #1 on: May 08, 2019, 15:49:56 pm »
Is your problem exactly the same as  - the text of which you have copied?

Jenkin Hill Internet,
Lowestoft, Suffolk, UK

Unsolicited PMs/emails will be ignored.

Please mention your VirtueMart, Joomla and PHP versions when asking a question in this forum

Currently using VM 3.8.0 10314 on Joomla 3.9.16 PHP 7.0.33