Author Topic: Sql Issues trying to load menu to category items  (Read 1627 times)

mlucas77

  • Beginner
  • *
  • Posts: 3
  • A beginner
  • Skype Name: webbman77
Sql Issues trying to load menu to category items
« 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

Jörgen

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 3933
    • Kreativ Fotografi
  • VirtueMart Version: 3.4.x
Re: Sql Issues trying to load menu to category items
« Reply #1 on: October 19, 2016, 09:36:55 am »
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

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 10530
  • VM4.0.7 Eagle Owl
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: Sql Issues trying to load menu to category items
« Reply #2 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.
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/