Unknown column ''%balis%'' in 'where clause' when searching an article

Hello,

I had a look at the two HikaShop search plugins (products and categories) and they always put the searched text between normal quotes, so I don't see how they could build a condition like this one. The error says MySQL received '%balis%' as a column name, which means some code wrapped the searched text as a field name. I suspect it comes from another search plugin, or from the search component itself (Joomla 6 doesn't include com_search anymore, so yours is an extra extension).

To find which one it is, could you go to System > Plugins, filter on the type "search", and unpublish the search plugins one by one, trying the search again after each one? When the error goes away, the last plugin you unpublished is the one building that query. If it turns out to be one of the HikaShop plugins, tell us and we will look at it right away.