I performed a git pull for the latest version and one of my two "dev" environments resulted in this error
(Sign on, click on Students menu, the error appear immediately below the student find box, covering the Submit button):
11/29/2021 23:34:12
Date
DB Execute Failed. ERROR: more than one row returned by a subquery used as an expression
Failure Notice
SELECT '0' AS ID,'' AS CATEGORY_TITLE,
'CUSTOM_'||cf.ID AS COLUMN_NAME,cf.TYPE,cf.TITLE,cf.SELECT_OPTIONS
FROM CUSTOM_FIELDS cf
WHERE (SELECT CAN_USE
FROM PROFILE_EXCEPTIONS WHERE PROFILE_ID='2'
AND MODNAME='Students/Student.php&category_id='||cf.CATEGORY_ID)='Y'
AND ((SELECT VALUE
FROM PROGRAM_USER_CONFIG
WHERE TITLE=cast(cf.ID AS TEXT)
AND PROGRAM='StudentFieldsSearch'
AND USER_ID='243')='Y')
ORDER BY cf.SORT_ORDER,cf.TITLE
SQL query