Print Page - Sql Issues trying to load menu to category items

Title: Sql Issues trying to load menu to category items
Post by: mlucas77 on October 19, 2016, 08:09:35 AM

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

Title: Re: Sql Issues trying to load menu to category items
Post by: Jörgen on October 19, 2016, 09:36:55 AM

Let´s start here:

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

Do You have any custom field search or filter installed ?

regards

Jörgen @ Kreativ Fotografi

Title: Re: Sql Issues trying to load menu to category items
Post by: Milbo on October 20, 2016, 13:22:24 PM

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

VirtueMart Forum

VirtueMart 2 + 3 + 4 => Virtuemart Development and bug reports => Topic started by: mlucas77 on October 19, 2016, 08:09:35 AM