News:

Support the VirtueMart project and become a member

Main Menu

error 1054 on display category

Started by Xakart, September 22, 2016, 22:14:47 PM

Previous topic - Next topic

Xakart

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

GJC Web Design

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
GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation