Author Topic: Change in virtuemart waitingusers table  (Read 105 times)

mhs_pro

  • Beginner
  • *
  • Posts: 15
  • A beginner
Change in virtuemart waitingusers table
« on: October 13, 2019, 15:44:09 pm »
Hi
Better make the following changes to the waitingusers table
In Root/administrator/components/com_virtuemart/install/install.sql line 1340 & 1341
replase
  KEY `virtuemart_product_id` (`virtuemart_product_id`),
  KEY `notify_email` (`notify_email`)
with
UNIQUE KEY `product_and_email` (`virtuemart_product_id`,`notify_email`)