Searchable Multicheckbox Field Match - "OR" option

Joomla 1.5.25 CB 1.7
The first problem I get when I enable the debug mode is:

500 - JDatabaseMySQL::query: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 SQL=SELECT name AS mysqlfield FROM jos_users WHERE id =

The rest is in the attachment.

You've a fatal SQL error that's coming from CB MySQL Field (plug_cbmysqlfield). We're not this plugins developer please contact the developer of your plugin for further support. For the time being I recommend disabling the plugin or removing the field.

My guess is it performs a database query and outputs the results as a field; we've an official plugin to provide that (CB Query Field) as is available from our forge. It's possible if you supplied the query your self there could be an error in the query.

Once issues with the field are resolved please confirm if your userlist issue persists.

Here is the new file with information.




I still have the problem.
When I search the word Helikopter I also get Mini-Helikopter.

Thanks for the help.
By the way: plug_cbmysqlfield is much easier to find on the Joomlapolis.com website than CB Query Field.

The below filter/search criteria appears to be applied.

Which specifically is the field you're searching on? Everything looks correct from what I can tell.

I also have term Mini-Helikopter.

When I am searching on Helikopter, I don't want to have the Mini-Helikopter in my results.
Is that possible?

Yes, but you'll have to set your userlist to Simple search "is". The way it is set now is it'll take what you searched for and match anything that contains that word. So for example if you search "Helikopter" then it will always also show "Mini-Helikopter" as it contains "Helikopter". Simple "is" searching is an exact match meaning the value must exactly match what you searched.