Print Page - [4.0.2] vmError: vmTable store insertObject #__virtuemart

Title: [4.0.2] vmError: vmTable store insertObject #__virtuemart_customs
Post by: balai on June 23, 2022, 12:49:49 PM

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

Code Select

#__virtuemart_customs table.
From the VM install.sql

Code Select

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.

Title: Re: [4.0.2] vmError: vmTable store insertObject #__virtuemart_customs
Post by: hazael on June 23, 2022, 13:44:23 PM

https://forum.virtuemart.net/index.php?topic=148294.0

VirtueMart Forum

VirtueMart 2 + 3 + 4 => Virtuemart Development and bug reports => Topic started by: balai on June 23, 2022, 12:49:49 PM