Resolved Import products Joomla Virtuemart unkown column error

Hello,

When I try to import products with some custom_fields, the import throws an error "Unknown column created_on in fields list"

I am using VM 4.0.7 version. created_on field is from #__virtuemart_products table and not from #__virtuemart_products_customfields table. See attached screenshot. Do you have this field in #__virtuemart_products table?

Now I could add the missing columns to the virtuemart_products_customfields table, but it seems that the new version of Virtuemart does not add them anymore. And I'm afraid that if I would update Virtuemart the columns will be removed and the CSVI would throw the error again.

Looks like something has gone wrong with your VM update. Try adding created_on field to #__virtuemart_products table and see if that fixes the issue.

I've tried to update the field list and do a database repair, but that did not fix the issue

Database repair in RO CSVI is to fix CSVI tables and does not fix VM tables.

Is this something that needs to be changed in the CSVI plugin?

This is not related to CSVI plugin. Please try my suggestion of adding the field to #__virtuemart_products table and see if it fixes the issue.

Hi Tharuna,

Thank you for your quick reply.

I am using VM 4.0.7 version. created_on field is from #__virtuemart_products table and not from #__virtuemart_products_customfields table. See attached screenshot. Do you have this field in #__virtuemart_products table?

Yes I do have those columns in my #__virtuemart_products table.

When I import the products without any custom_fields the import does not throw any errors. Also when I add the missing columns to the #__virtuemart_product_customfield table and run the import (with custom_fields) it also does not throw any errors. So it seems to me the import of products with custom_fields wants to have that column available in that particular table.

Looks like something has gone wrong with your VM update

That's would be weird, cause It's on a clean install of Joomla! with Virtuemart, with the default installer from the Virtuemart website. Not said that it would be possible something went wrong with the installation, but I've tested it on 3 websites now and all 3 (1 local) throws the same error and are missing the same columns.

I know that in previous versions of Virtuemart (vm 3.8.8) the created_on field was also added to the #__virtuemart_product_customfields table.

Hello,

When I import the products without any custom_fields the import does not throw any errors. Also when I add the missing columns to the #__virtuemart_product_customfield table and run the import (with custom_fields) it also does not throw any errors. So it seems to me the import of products with custom_fields wants to have that column available in that particular table.

Please send me the import file and template XML file to check. To get the template XML file, in RO CSVI maintenance menu select RO CSVI on first option, backup templates on second option, select the import template and download the XML file. Post the XML file.

I know that in previous versions of Virtuemart (vm 3.8.8) the created_on field was also added to the #__virtuemart_product_customfields table.

Yes, You're right. VirtueMart 3.8 version has created_on and few more fields in #__virtuemart_product_customfields table and that has been removed with VirtueMart 4 version. That is the reason you are seeing the error with VM 4 version.

Hi Tharuna,

Thanks for your reply.

I've added the import file and XML template as attachment

Kind regards

Hi Tharuna,

Thanks for the patch, I loaded the patch and ran the import. The issue seems to be resolved as far as I can see.

Thanks again for the support