I've tried unpublishing. Makes no difference. Same warning and no selection of members. Maybe a solution direction: i also use a plugin to search cb trough the standard joomla search box. That's a global search functionality. It works fine so there is no mysql limitation i presume. I use
extensions.joomla.org/extensions/search-a-indexing/extensions-search/9287
