Text only | Text with Images

VirtueMart Forum

VirtueMart 2 + 3 + 4 => General Questions => Topic started by: limbotron on July 28, 2017, 11:02:10 AM

Title: 1054 - Unknown column 'a.custom_value' in 'field list'
Post by: limbotron on July 28, 2017, 11:02:10 AM
Hi, my problem is: "1054 - Unknown column 'a.custom_value' in 'field list'"
after upgrade VM2 to VM3.
My "#__virtuemart_customs" table column is:
custom_desc
AND table "#__virtuemart_product_customfields" column is:
customfield_value
customfield_price
customfield_params

What is wrong?
Thanks in advance
Title: Re: 1054 - Unknown column 'a.custom_value' in 'field list'
Post by: Studio 42 on July 28, 2017, 16:21:20 PM
You use a product customfield plugin ?
Title: Re: 1054 - Unknown column 'a.custom_value' in 'field list'
Post by: limbotron on August 01, 2017, 07:35:57 AM
I use "Custom Fields for All" plugin.
Title: Re: 1054 - Unknown column 'a.custom_value' in 'field list'
Post by: Ventsi Genchev on August 01, 2017, 08:25:04 AM
The next question is whether you've updated the "Custom Fields for All" plugin?  :)
Title: Re: 1054 - Unknown column 'a.custom_value' in 'field list'
Post by: limbotron on August 01, 2017, 09:00:06 AM
No. I use v1.6. and i don't know how to update automatically
Title: Re: 1054 - Unknown column 'a.custom_value' in 'field list'
Post by: limbotron on August 02, 2017, 12:06:30 PM
I found solution.
Need change "a.custom_value" to "a.customfield_value"
In \templates\theme_name\html\com_virtuemart\category\name-category.php file
Title: Re: 1054 - Unknown column 'a.custom_value' in 'field list'
Post by: Milbo on August 02, 2017, 21:31:23 PM
You may also take a look here https://docs.virtuemart.net/tutorials/development/175-code-adjustments-for-virtuemart-3.html

opentools provided also a nice tutorial
Text only | Text with Images