Resolved vmError: bindParameterable key/value pair not valid

Hello,
Post import file and also template XML file to check. To get the template XML file from RO CSVI templates list page select the import template and click on Backup templates button. Post the downloaded XML file.

Hi Tharuna,
I am sending what you asked for.

I noticed that this error only applies to custom fields. If I import and change the product name or fields like product_weight product_height, everything is ok.
I also refreshed the list of custom fields in CSVI, but without any positive results

Kind regards,
Chris

did you manage to solve the problem because it also appeared for me after the last update

Joomla 4.4.7, Virtuemart 4.2.18, CSVI 8.12.0

I noticed that products imported (corrected) by import have different data saved in the database

the first product from the attachment is imported and the value of the additional field is not displayed on the front end and in the back end it displays an error

the second one is corrected manually and everything is ok


the attachment presents data for two products and one of the additional fields which is affected by the bug,
the problem also concerns other fields but in this example you can clearly see the difference in the data recording
(SELECT * FROM `#_virtuemart_product_customfields` WHERE (`virtuemart_product_id` = 51831 or `virtuemart_product_id` = 51829) and `virtuemart_custom_id` = 15; )

Hello,

We are looking into the problem to see which change caused this. Just a question I have, are you using the default VirtueMart custom fields or are you using any plugin that creates these custom fields, for example the Breakdesign extension Custom Field for All?

For further checking, please post an example of a custom field that no longer imports correctly. By example I mean the settings of this custom field? That will help me to reproduce and identify the issue.

Hi Roland,

sorry for only replying now. I'm currently on vacation. I'll investigate this next week.

Generally, I only imported custom fields from virtuemart. I also did a test import for a single field. The result was always the same.

Best regards,
Chris

Hello Chris,

Enjoy your holiday, we will await your reply.

in my case there were two types of fields in the file: standard fields available in Virtuemart and fields added by Custom Field for All extension by Breakdesign.

The problem occurred in the case of standard fields only.

The difference in how the fields were given in the csv file was that:
- standard fields available in Virtuemart were added as separate columns with a header corresponding to the field name,
- fields added by Breakdesign extension Custom Field for All were added in columns: custom_title, custom_value, custom_param and custom_price.

I changed the way I have scv files generated from another system so that all fields are added in 4 columns and everything is ok now.

Hello,

Glad to hear your issue is resolved but I am still a bit confused. You sorted your problem by putting all values in the custom_title, custom_value, custom_param and custom_price columns?

Having the way you described with standard fields as regular columns and breakdesign as custom_ fields should be fine. Once I understand how you have done it now, we can check why it would not work the way you described.

at the moment I'm facing another problem related to importing and updating products
I'm at the stage of verifying csv files and templates, as soon as I manage to define the problem to the end I'll get back to you

Hello,

That is fine, we will await your feedback.

Hello everyone, after the last RO CSVI update (8.12.1) everything is back to normal. The component works perfectly - the topic can be closed.
Thanks for the quick fix.

Regards,
Chris

my problem is rather related to Custom Field for All extension from Breakdesign

What's wrong with that? I also use this component - I can test it myself if you want

Hello,

my problem is rather related to Custom Field for All extension from Breakdesign

Can you explain on the issue you have? Post the import file you use along with template XML file. Also post import debug log so we can check. To get the template XML file from RO CSVI templates list page select the import template and click on Backup templates button. Post the downloaded XML file. To get the import debug log read How to collect debug information? document. If possible include screenshots of Custom Field for All fields to know the settings you use.

the problem concerns adding new values ​​to custom fields of customfieldsforall type
the problem was reported (yesterday) to the author of the add-on and I am waiting for a response

the problem is not related to ROCSVI so there is probably no need to expand the topic here

Which version of customfieldsforall is this? I haven't updated this VM add-on yet because I don't see any justification for doing so.

Joomla!4.4.8
Virtuemart 4.2.18
Custom Fields for All 4.5.1