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

-- url of the page with the problem -- : www.hirtenweg.ch/component/search/?searc...hrase=all&Itemid=114
-- HikaShop version -- : 6.6.0
-- Joomla version -- : ‎6.1.3
-- PHP version -- : 8.4.11
-- Browser(s) name and version -- : all latest Version Browsers
-- Error-message(debug-mod must be tuned on) -- : 1054 Unknown column ''%balis%'' in 'where clause'

Hello,
when searching an article in the hikashop, this error appears all the time.

www.hirtenweg.ch/angebot

1054 Unknown column ''%balis%'' in 'where clause'

Can you help me?

Thank you

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.

Ohhhh yes, you’re right! It was the search plugin from SP Page Builder. I disabled it, and now it works. Thank you!
Happy