VirtueMart Forum

VirtueMart 2 + 3 + 4 => General Questions => Topic started by: Xakart on September 22, 2016, 22:14:47 PM

Title: error 1054 on display category
Post by: Xakart on September 22, 2016, 22:14:47 PM
I deleted categories and created new and now when I go into any virtuemart  category I see this error

1054
Unknown column 'searchable' in 'where clause' SQL=SELECT c.* FROM #__virtuemart_customs as c INNER JOIN #__virtuemart_product_customfields as pc on (c.virtuemart_custom_id=pc.virtuemart_custom_id) INNER JOIN #__virtuemart_product_categories as cat ON (pc.virtuemart_product_id=cat.virtuemart_product_id) WHERE virtuemart_category_id="20" and searchable="1" and (field_type="S" or field_type="P") GROUP BY c.virtuemart_custom_id

I am a rookie and this is my first job, I'm studying to be an application developer and now I do not have much knowledge
Title: Re: error 1054 on display category
Post by: GJC Web Design on September 23, 2016, 00:34:38 AM
As  a beginner you would do your self a service by learning to search for information..
This was discussed last week on here

http://forum.virtuemart.net/index.php?topic=135329.0

also read the stickies and follow the directions

http://forum.virtuemart.net/index.php?topic=104795.0
http://forum.virtuemart.net/index.php?topic=79799.0