Author Topic: Identical indexes in the product_price table  (Read 506 times)

OskarMaria

  • Beginner
  • *
  • Posts: 9
Identical indexes in the product_price table
« on: February 12, 2016, 17:06:58 pm »
Phpmyadmin says, that there are two identical indexes in the virtuemart product_price table. The first is for the virtuemart_product_id key name, the second for the product_price key name. And one of these indexes can be deleted...

My question is- which one and what is reponsible for this double index?

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 10070
  • VM3.2 Cached and Optimized
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: Identical indexes in the product_price table
« Reply #1 on: February 14, 2016, 11:31:27 am »
virtuemart_product_id is in any case very important and correct, but you should use vm3.0.13.2 and the enhanced tableupdater.
I should fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/