News:

You may pay someone to create your store, or you visit our seminar and become a professional yourself with the silver certification

Main Menu

Sql Issues trying to load menu to category items

Started by mlucas77, October 19, 2016, 08:09:35 AM

Previous topic - Next topic

mlucas77

I am getting some sql errors on my virtual mart instalation from just trying to attach a menu to a category, Can anyone help me fix this issue?

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="5" and searchable="1" and (field_type="S" or field_type="P") GROUP BY c.virtuemart_custom_id

Jörgen

Let´s start here:

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

Do You have any custom field search or filter installed ?

regards

Jörgen @ Kreativ Fotografi
Joomla 3.9.18
Virtuemart 3.4.x
Olympiantheme Hera (customized)
This reflects current status when viewing old post.

Milbo

Just use the tableupdater. It seems that somenhow the column "searchable" was not added by the update.
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/