Pull Request for Issue #41951.

Summary of Changes

Proposed fix for
ERROR: column "mfa.mfaRecords" must appear in the GROUP BY clause or be used in an aggregate function #41951.
Please also see #41952.

Testing Instructions

1. Log in administrator backend.
2. Select Users -> Groups on the menu.
3. Click on any entry on the "Enabled Users" or "Blocked Users" column.

Actual result BEFORE applying this Pull Request

An error has occurred.
500 42803, 7, ERROR: column "mfa.mfaRecords" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: SELECT a.,"mfa"."mfaRecords" ^ 42803, 7, ERROR: column "mfa.mfaRecords" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: SELECT a.,"mfa"."mfaRecords" ^

Expected result AFTER applying this Pull Request

It shows a list of enabled or blocked users with a group.

Link to documentations

Please select:

• Documentation link for docs.joomla.org:

• No documentation changes for docs.joomla.org needed

• Pull Request link for manual.joomla.org:

• No documentation changes for manual.joomla.org needed