Org Admin 500 error on /individuals/index

[fearanp]

Hi,
When a user who has an org admin role clicks on the individuals menu link it returns this error. Anybody see this before ? As admin i can see the page no issue. Once the org admin is activated on the user i get this error.

2023-09-27 13:46:34 error: [Cake\Database\Exception\DatabaseException] Impossible to generate condition with empty list of values for field (role_id) in /var/www/cerebrate/vendor/cakephp/cakephp/src/Database/Expression/ComparisonExpression.php on line 229
Stack Trace:

• /var/www/cerebrate/vendor/cakephp/cakephp/src/Database/Expression/ComparisonExpression.php:156
• /var/www/cerebrate/vendor/cakephp/cakephp/src/Database/Expression/QueryExpression.php:602
• /var/www/cerebrate/vendor/cakephp/cakephp/src/Database/Expression/QueryExpression.php:602
• /var/www/cerebrate/vendor/cakephp/cakephp/src/Database/Expression/QueryExpression.php:602
• /var/www/cerebrate/vendor/cakephp/cakephp/src/Database/QueryCompiler.php:147
• /var/www/cerebrate/vendor/cakephp/cakephp/src/Database/Query.php:375
• /var/www/cerebrate/vendor/cakephp/cakephp/src/Database/QueryCompiler.php:107
• /var/www/cerebrate/vendor/cakephp/cakephp/src/Database/Driver.php:470
• /var/www/cerebrate/vendor/cakephp/cakephp/src/Database/Connection.php:345
• /var/www/cerebrate/vendor/cakephp/cakephp/src/Database/Query.php:315
• /var/www/cerebrate/vendor/cakephp/cakephp/src/ORM/Query.php:1129
• /var/www/cerebrate/vendor/cakephp/cakephp/src/Database/Driver/Mysql.php:200
• /var/www/cerebrate/vendor/cakephp/cakephp/src/Database/Connection.php:303
• /var/www/cerebrate/vendor/cakephp/cakephp/src/Core/Retry/CommandRetry.php:70
• /var/www/cerebrate/vendor/cakephp/cakephp/src/Database/Connection.php:302
• /var/www/cerebrate/vendor/cakephp/cakephp/src/Database/Connection.php:358
• /var/www/cerebrate/vendor/cakephp/cakephp/src/Core/Retry/CommandRetry.php:70
• /var/www/cerebrate/vendor/cakephp/cakephp/src/Database/Connection.php:357
• /var/www/cerebrate/vendor/cakephp/cakephp/src/Database/Query.php:255
• /var/www/cerebrate/vendor/cakephp/cakephp/src/ORM/Query.php:1148
• /var/www/cerebrate/vendor/cakephp/cakephp/src/Datasource/QueryTrait.php:288
• /var/www/cerebrate/vendor/cakephp/cakephp/src/ORM/Query.php:1096
• /var/www/cerebrate/src/Model/Table/IndividualsTable.php:137
• /var/www/cerebrate/src/Controller/IndividualsController.php:44
• /var/www/cerebrate/vendor/cakephp/cakephp/src/Controller/Controller.php:547
• /var/www/cerebrate/vendor/cakephp/cakephp/src/Controller/ControllerFactory.php:139
• /var/www/cerebrate/vendor/cakephp/cakephp/src/Controller/ControllerFactory.php:114
• /var/www/cerebrate/vendor/cakephp/cakephp/src/Http/BaseApplication.php:320
• /var/www/cerebrate/vendor/cakephp/cakephp/src/Http/Runner.php:86
• /var/www/cerebrate/vendor/cakephp/authentication/src/Middleware/AuthenticationMiddleware.php:124
• /var/www/cerebrate/vendor/cakephp/cakephp/src/Http/Runner.php:82
• /var/www/cerebrate/vendor/cakephp/cakephp/src/Http/Middleware/BodyParserMiddleware.php:157
• /var/www/cerebrate/vendor/cakephp/cakephp/src/Http/Runner.php:82
• /var/www/cerebrate/vendor/cakephp/cakephp/src/Http/Runner.php:86
• /var/www/cerebrate/vendor/cakephp/cakephp/src/Http/Middleware/CsrfProtectionMiddleware.php:174
• /var/www/cerebrate/vendor/cakephp/cakephp/src/Http/Runner.php:82
• /var/www/cerebrate/vendor/cakephp/cakephp/src/Http/Runner.php:67
• /var/www/cerebrate/vendor/cakephp/cakephp/src/Routing/Middleware/RoutingMiddleware.php:192
• /var/www/cerebrate/vendor/cakephp/cakephp/src/Http/Runner.php:82
• /var/www/cerebrate/vendor/cakephp/cakephp/src/Routing/Middleware/AssetMiddleware.php:68
• /var/www/cerebrate/vendor/cakephp/cakephp/src/Http/Runner.php:82
• /var/www/cerebrate/vendor/cakephp/cakephp/src/Error/Middleware/ErrorHandlerMiddleware.php:131
• /var/www/cerebrate/vendor/cakephp/cakephp/src/Http/Runner.php:82
• /var/www/cerebrate/vendor/cakephp/debug_kit/src/Middleware/DebugKitMiddleware.php:60
• /var/www/cerebrate/vendor/cakephp/cakephp/src/Http/Runner.php:82
• /var/www/cerebrate/vendor/cakephp/cakephp/src/Http/Runner.php:67
• /var/www/cerebrate/vendor/cakephp/cakephp/src/Http/Server.php:90
• /var/www/cerebrate/webroot/index.php:40

Request URL: /individuals/index

[fearanp]

Seems to be fixed in v1.17 .