[4.0.2] vmError: vmTable store insertObject #__virtuemart_customs

Started by balai, June 23, 2022, 12:49:49 PM

Previous topic - Next topic

balai

After creating some custom fields i am getting the following error:
QuotevmError: vmTable store insertObject #__virtuemart_customs Duplicate entry 'E-0-1' for key 'field_type_searchable_published'

VM 4.0.2 has added a new index in the #__virtuemart_customs table.
From the VM install.sql
UNIQUE KEY field_type_searchable_published  (`field_type`, `searchable`, `published`),

Obviously this key cannot be unique since this mentioned fields combination can be repeated several times.