One save product add one new price

[marvays]

Hello. I have a problem. Bug. When I save the product, another copy of the product price is created. When I edit captions, images and other things for a product, I save the product 3 times. A new price is added for each save. As a result, I have 6x price for the product. Where is the problem?



PHP: Linux 7.3.2
DB: 5.5.5-10.3.12-MariaDB
Joomla! 3.9.11
VirtueMart 3.4.2

[AH]

This is an older version - please test on the latest version

[marvays]

Great. I recently checked the version and 3.4.2 was the newest version for a long time. Thank you. So can I use 3.6.0 for a live eshop?

[GJC Web Design]

3.6.0 is stable and intended for live

[AH]

Test fully on NON LIVE first!

[marvays]

thx

[marvays]

In update to 3.6 i see error:
ALTER TABLE causes auto_increment resequencing, resulting in duplicate entry '447' for key 'PRIMARY'

[marvays]

But, after updating, the problem of adding prices after saving the product still remained

[jjk]

Does it happen only when saving this product or with all products? And does the table _virtuemart_products contain a virtuemart_product_id with the value 0?

[Studio 42]

Do you use the default back-end template ?
Perhaps on click, it call twice the save function.
If you have it only on some product, perhaps you have to many data.
You have to increase in this case the post_max_size and max_input_vars PHP parameters

[marvays]

And?

In update to 3.6 i see error:
ALTER TABLE causes auto_increment resequencing, resulting in duplicate entry '447' for key 'PRIMARY'

[marvays]

I was try uninstall all parts. Was Stay only on joomla and VM. But the problem still persists.

[Jörgen]

What is entry 447, which file in the dbase?
Jörgen

[marvays]

The problem is that if I edit any product in the e-shop administration, a duplicate price will be created each time I save it. So for example, the product is then 10 times the same price. Yesterday I gradually uninstalled all the other extensions, until I remained only pure joomla and clean eshop and yet it did. When I placed an order in the e-shop administration that deleted all my products, categories, pricing, countries and overall e-shop settings and uploaded the demo data for demonstration, then everything worked fine. So there will be a problem in the settings. Apparently I have a combination that makes the problem.

[marvays]

What is entry 447, which file in the dbase?
Jörgen

I just do not know, because it is not stated in which table to look.