CB

Way to replicate:

User list with following:

View Access Level: Public
User Group to allow access to: Everybody
User Groups to Include in List: Registered

When trying to view such a user list in frontend I get following error:

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 ') ORDER BY ordering' at line 1 SQL=SELECT listid, title FROM jos_comprofiler_lists WHERE published=1 AND viewaccesslevel IN (1) AND useraccessgroupid IN () ORDER BY ordering
You may not be able to visit this page because of:

an out-of-date bookmark/favourite
a search engine that has an out-of-date listing for this site
a mistyped address
you have no access to this page
The requested resource was not found.
An error has occurred while processing your request.
Please try one of the following pages:

Home Page
If difficulties persist, please contact the System Administrator of this site.

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 ') ORDER BY ordering' at line 1 SQL=SELECT listid, title FROM jos_comprofiler_lists WHERE published=1 AND viewaccesslevel IN (1) AND useraccessgroupid IN () ORDER BY ordering

1. Function Location
   1 JSite->dispatch() /Users/nick/Documents/JOOMLAPOLIS/DEV/SITES/j1525/index.php:68
   2 JComponentHelper->renderComponent() /Users/nick/Documents/JOOMLAPOLIS/DEV/SITES/j1525/includes/application.php:124
   3 require_once() /Users/nick/Documents/JOOMLAPOLIS/DEV/SITES/j1525/libraries/joomla/application/component/helper.php:162
   4 usersList() /Users/nick/Documents/JOOMLAPOLIS/DEV/SITES/j1525/components/com_comprofiler/comprofiler.php:108
   5 cbUsersList->drawUsersList() /Users/nick/Documents/JOOMLAPOLIS/DEV/SITES/j1525/components/com_comprofiler/comprofiler.php:804
   6 CBdatabase->loadObjectList() /Users/nick/Documents/JOOMLAPOLIS/DEV/SITES/j1525/administrator/components/com_comprofiler/library/cb/cb.lists.php:89
   7 CBdatabase->query() /Users/nick/Documents/JOOMLAPOLIS/DEV/SITES/j1525/administrator/components/com_comprofiler/library/cb/cb.database.php:861
   8 JDatabaseMySQL->query() /Users/nick/Documents/JOOMLAPOLIS/DEV/SITES/j1525/administrator/components/com_comprofiler/library/cb/cb.database.php:695
   9 JError->raiseError() /Users/nick/Documents/JOOMLAPOLIS/DEV/SITES/j1525/libraries/joomla/database/database/mysql.php:231
   10 JError->raise() /Users/nick/Documents/JOOMLAPOLIS/DEV/SITES/j1525/libraries/joomla/error/error.php:171
   11 JException->__construct() /Users/nick/Documents/JOOMLAPOLIS/DEV/SITES/j1525/libraries/joomla/error/error.php:136