[#7504] Searching GJ Users causes error

I've got a similar issue when I'm looking for a groupjive user in the groupjive menu. I can get the users list but if I use the search facility to find one, then I've got the message "Unknown column 'c.category' in 'on clause' ".
here's the debug log I get:
Unknown column 'c.category' in 'on clause'
#0 /var/www/diginet/libraries/joomla/database/driver.php(1734): JDatabaseDriverMysqli->execute() #1 /var/www/diginet/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php(345): JDatabaseDriver->loadResult() #2 /var/www/diginet/libraries/CBLib/CBLib/AhaWow/Model/XmlQuery.php(367): CBLib\Database\Driver\CmsDatabaseDriver->loadResult() #3 /var/www/diginet/libraries/CBLib/CBLib/AhaWow/Controller/Elements/TableBrowser.php(403): CBLib\AhaWow\Model\XmlQuery->queryCount() #4 /var/www/diginet/libraries/CBLib/CBLib/AhaWow/Controller/Elements/TableBrowser.php(2399): CBLib\AhaWow\Controller\Elements\TableBrowser->loadRows() #5 /var/www/diginet/libraries/CBLib/CBLib/AhaWow/View/RegistryEditView.php(2388): CBLib\AhaWow\Controller\Elements\TableBrowser->draw('view') #6 /var/www/diginet/libraries/CBLib/CBLib/AhaWow/View/RegistryEditView.php(1276): CBLib\AhaWow\View\RegistryEditView->renderOneParamAndChildren(Object(CBLib\Xml\SimpleXMLElement), NULL, Object(cbTabs), 'view', 'none') #7 /var/www/diginet/libraries/CBLib/CBLib/AhaWow/View/RegistryEditView.php(446): CBLib\AhaWow\View\RegistryEditView->renderAllParams(Object(CBLib\Xml\SimpleXMLElement), NULL, Object(cbTabs), 'view', 'none') #8 /var/www/diginet/libraries/CBLib/CBLib/AhaWow/Controller/RegistryEditController.php(317): CBLib\AhaWow\View\RegistryEditView->renderEditRowView(Object(CBLib\Xml\SimpleXMLElement), Object(CBLib\Registry\Registry), Object(CBLib\AhaWow\Controller\DrawController), Array, 'view', 'none') #9 /var/www/diginet/libraries/CBLib/CBLib/AhaWow/View/ActionViewAdmin.php(133): CBLib\AhaWow\Controller\RegistryEditController->draw(NULL, NULL, NULL, NULL, NULL, NULL, false, 'view', 'none') #10 /var/www/diginet/libraries/CBLib/CBLib/AhaWow/Controller/ActionController.php(533): CBLib\AhaWow\View\ActionViewAdmin::editPluginView(Array, Array, Object(CBLib\Xml\SimpleXMLElement), NULL, Object(CBLib\AhaWow\Controller\RegistryEditController), Object(CB\Database\Table\PluginTable), 'view', NULL, true) #11 /var/www/diginet/libraries/CBLib/CBLib/AhaWow/Controller/ActionController.php(170): CBLib\AhaWow\Controller\ActionController->drawView('com_comprofiler', 'editPlugin', Object(CBLib\Xml\SimpleXMLElement), 'edit') #12 /var/www/diginet/libraries/CBLib/CBLib/AhaWow/Controller/Controller.php(131): CBLib\AhaWow\Controller\ActionController->handleAction(Array) #13 /var/www/diginet/libraries/CBLib/CBLib/AhaWow/Controller/Controller.php(111): CBLib\AhaWow\Controller\Controller->execute(Array, Object(CBLib\Output\Output)) #14 /var/www/diginet/libraries/CBLib/CBLib/Controller/Controller.php(101): CBLib\AhaWow\Controller\Controller->dispatchRoute(Array) #15 /var/www/diginet/libraries/CBLib/CBLib/Controller/Controller.php(78): CBLib\Controller\Controller->execute('editPluginTask') #16 /var/www/diginet/libraries/CBLib/CBLib/Controller/Dispatcher.php(86): CBLib\Controller\Controller->dispatch('editPluginTask') #17 /var/www/diginet/libraries/CBLib/CBLib/Application/Application.php(132): CBLib\Controller\Dispatcher->dispatch() #18 /var/www/diginet/libraries/CBLib/CBLib/Core/CBLib.php(178): CBLib\Application\Application->dispatch() #19 /var/www/diginet/administrator/components/com_comprofiler/admin.comprofiler.controller.php(201): CBLib\Core\CBLib::execute() #20 /var/www/diginet/administrator/components/com_comprofiler/comprofiler.php(14): require('/var/www/digine...') #21 /var/www/diginet/libraries/src/Component/ComponentHelper.php(402): require_once('/var/www/digine...') #22 /var/www/diginet/libraries/src/Component/ComponentHelper.php(377): Joomla\CMS\Component\ComponentHelper::executeComponent('/var/www/digine...') #23 /var/www/diginet/libraries/src/Application/AdministratorApplication.php(101): Joomla\CMS\Component\ComponentHelper::renderComponent('com_comprofiler') #24 /var/www/diginet/libraries/src/Application/AdministratorApplication.php(159): Joomla\CMS\Application\AdministratorApplication->dispatch() #25 /var/www/diginet/libraries/src/Application/CMSApplication.php(196): Joomla\CMS\Application\AdministratorApplication->doExecute() #26 /var/www/diginet/administrator/index.php(51): Joomla\CMS\Application\CMSApplication->execute() #27 {main}

I can confirm issue mentionned by jperel. Login out of administrator and logging in again shows groupjive userlist again, but when searching again, error appears.

Was able to confirm and have added a bug ticket to fix.

forge.joomlapolis.com/issues/7504

Logout will clear the search. For now don't use the quick search in GJ > Users.