Author Topic: How to change "virtuemart_product_id" count in database?  (Read 637 times)

scriner

  • Beginner
  • *
  • Posts: 26
  • A beginner
How to change "virtuemart_product_id" count in database?
« on: September 19, 2022, 08:19:06 am »
Hello,

by the fixing "Empty slug product with id 341, entries exists for language" bug I have made mistake and now have too big count of "virtuemart_product_id" in "joom_virtuemart_products" table. See screenshot.

Anybody know how to return ID count to prevous state? When I delete all new ID - it not helps.

J 3.10.11, VM 4.0.6 10690

GJC Web Design

  • 3rd party VirtueMart Developer
  • Super Hero
  • *
  • Posts: 10638
  • Virtuemart, Joomla & php developer
    • GJC Web Design
  • VirtueMart Version: 3.8.8
Re: How to change "virtuemart_product_id" count in database?
« Reply #1 on: September 19, 2022, 12:35:28 pm »
use phpmyadmin

GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM3 AusPost Shipping Plugin - e-go Shipping Plugin - VM3 Postcode Shipping Plugin - Radius Shipping Plugin - VM3 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

scriner

  • Beginner
  • *
  • Posts: 26
  • A beginner
Re: How to change "virtuemart_product_id" count in database?
« Reply #2 on: September 21, 2022, 06:07:54 am »
I fixed it.

Very big thank you.

How to mark topic as solved?

GJC Web Design

  • 3rd party VirtueMart Developer
  • Super Hero
  • *
  • Posts: 10638
  • Virtuemart, Joomla & php developer
    • GJC Web Design
  • VirtueMart Version: 3.8.8
Re: How to change "virtuemart_product_id" count in database?
« Reply #3 on: September 21, 2022, 10:34:54 am »
No prob - marked solved
GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM3 AusPost Shipping Plugin - e-go Shipping Plugin - VM3 Postcode Shipping Plugin - Radius Shipping Plugin - VM3 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation