SearchBot 2.0.1 with CB 2.0.1 sql error

After installation of CB 2.0.1 and CB search bot 2.0.1 we have sql error for searching

We have to unpublish the plugin for now

Error is :
1241
Operand should contain 1 column(s) SQL=SELECT u.* FROM yq0g1_users AS u LEFT JOIN yq0g1_comprofiler AS ue ON u.id = ue.id WHERE u.block = 0 AND ue.approved = 1 AND ue.confirmed = 1 AND (((u.`username` LIKE '%machuro%')) OR ((ue.`cb_company` LIKE '%machuro%'))) AND u.block = 0 AND ue.approved = 1 AND ue.confirmed = 1 AND u.id NOT IN ( (41, 42) ) ORDER BY u.username ASC LIMIT 0, 60

Can you tell me what to correct ?

Uninstall CB Search Bot 2.0.0 and CB Search Bot 2.0.1. Now re-install CB Search Bot 2.0.1. and see if issue resolves. The XML of 2.0.0 is bugged and it ends up installing as a Content plugin so there is probably some wonky conflict going on. If issue persists please let me know and will debug further.

Uninstalled all and reinstall 2.0.1 and I get the same mysql error.

Seams to be working ok here. Edit your CB Search Bot within Extension > Plug-in Manager and ensure you've selected some valid fields. As a test please select only the Username field and see if it works ok.

Yes it was a problem on a field that has been replaced when upgrading to CB 2.0

Thanks

activha wrote: Yes it was a problem on a field that has been replaced when upgrading to CB 2.0

Thanks

Thanks for posting solution - what field was replaced?