VirtueMart Forum

VirtueMart 2 + 3 + 4 => Virtuemart Development and bug reports => Topic started by: Roderic on April 28, 2023, 11:32:22 AM

Title: vmError: bindParameterable key/value pair not valid
Post by: Roderic on April 28, 2023, 11:32:22 AM
Joomla 3.10.11 / VM 4.0.18.10847

The log is flooded with the following error:
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.
Title: Re: vmError: bindParameterable key/value pair not valid
Post by: Roderic on April 30, 2023, 11:58:45 AM
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.
Title: Re: vmError: bindParameterable key/value pair not valid
Post by: Roderic on May 10, 2023, 11:25:12 AM
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.
Title: Re: vmError: bindParameterable key/value pair not valid
Post by: Alexb65 on May 25, 2023, 14:05:17 PM
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