vmError: bindParameterable key/value pair not valid

[Roderic]

Joomla 3.10.11 / VM 4.0.18.10847

The log is flooded with the following error:

Code Select Expand

2023-04-26 20:17:50 ERROR vmError: bindParameterable key/value pair not valid Khaki<pre>#0  vmError() called at [/xxx/administrator/components/com_virtuemart/helpers/vmtable.php:639]
#1  VmTable::bindParameterable() called at [/xxx/administrator/components/com_virtuemart/models/customfields.php:287]
#2  VirtueMartModelCustomfields::bindCustomEmbeddedFieldParams() called at [/xxx/administrator/components/com_virtuemart/models/customfields.php:247]
#3  VirtueMartModelCustomfields->getCustomEmbeddedProductCustomFields() called at [/xxx/administrator/components/com_virtuemart/models/product.php:1380]
#4  VirtueMartModelProduct->getProduct() called at [/xxx/administrator/components/com_virtuemart/models/product.php:2273]
#5  VirtueMartModelProduct->getProducts() called at [/xxx/components/com_virtuemart/views/category/view.html.php:288]
#6  VirtuemartViewCategory->display() called at [/xxx/components/com_virtuemart/controllers/category.php:61]
</pre>

After going back to 4.0.12, the error is gone. So somewhere between 4.0.12 / 4.0.18 this error was introduced.

[Roderic]

I found a download of 4.0.14.10805 and here the problem is also not introduced yet. So either 4.0.16 or 4.0.18.

[Roderic]

Problem still exists with 4.0.20. However, I only have this issue with one website. This websites imports the customfieldsforall values through RO CSVI import. I think there are some values that are not bind properly.
This was no real issue before but since 4.0.18 it throws errors and the virtuemart log file gets big rather quickly.

As soon as I open a product that throws errors, resave the product, the errors are gone for that product.

[Alexb65]

Hi
I had the same problem and discovered that the db field holding product parameters were incorrect so check the products table and fix/clear the options field