Sql Issues trying to load menu to category items

[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

[Milbo]

Just use the tableupdater. It seems that somenhow the column "searchable" was not added by the update.