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?
(https://i.postimg.cc/G29dNg7K/Lazeck-M-ch-Administrace.png) (https://postimg.cc/phNw5Ct5)
PHP: Linux 7.3.2
DB: 5.5.5-10.3.12-MariaDB
Joomla! 3.9.11
VirtueMart 3.4.2
This is an older version - please test on the latest version
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?
3.6.0 is stable and intended for live
Test fully on NON LIVE first!
thx
In update to 3.6 i see error:
ALTER TABLE causes auto_increment resequencing, resulting in duplicate entry '447' for key 'PRIMARY'
But, after updating, the problem of adding prices after saving the product still remained :(
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?
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
And?
Quote from: marvays on August 29, 2019, 05:41:13 AM
In update to 3.6 i see error:
ALTER TABLE causes auto_increment resequencing, resulting in duplicate entry '447' for key 'PRIMARY'
I was try uninstall all parts. Was Stay only on joomla and VM. But the problem still persists.
What is entry 447, which file in the dbase?
Jörgen
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.
Quote from: Jörgen on August 29, 2019, 15:51:19 PM
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.
Verify all table with prefix #__virtuemart_product .
#_ is the table prefix in your Joomla config
Quote from: marvays on August 30, 2019, 08:20:42 AM
Quote from: Jörgen on August 29, 2019, 15:51:19 PM
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.
In this table I have on line 447 product with double prize. Second prize I was deleted.
Now I have problem with 557. I was delete this product from administrator - products, but the error still remained :(
Now I havent product with ID 557, but the error still remained. OMG
In the administration, I replaced all my data with a demo. Then everything works correctly. Error must be somewhere in my settings or in my products :(