You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
GET /api/platform/v1/admin/mentorship/cycles/{cycleId}/applications?status=... returns 500 Internal Server Error whenever the cycle has no applications matching the requested statuses. The endpoint cannot legitimately return an empty list — every admin portal tab that queries an empty bucket (common on a fresh cycle or QA environment) fails instead of showing "no results".
Steps to reproduce
In the admin portal, open the applications view for a cycle that has no applications in PENDING or MENTOR_REVIEWING.
Observe the failed network call to GET /admin/mentorship/cycles/{cycleId}/applications?status=PENDING,MENTOR_REVIEWING.
Or call directly with X-API-KEY and a bearer token on any cycle / status combination that matches no records.
Expected
200 OK with an empty array [].
Actual
500 Internal Server Error. Server logs show BadSqlGrammarException with the underlying message syntax error at or near ")" from a generated query of the shape SELECT * FROM mentees WHERE mentee_id IN ().
GET /api/platform/v1/admin/mentorship/cycles/{cycleId}/applications?status=...returns500 Internal Server Errorwhenever the cycle has no applications matching the requested statuses. The endpoint cannot legitimately return an empty list — every admin portal tab that queries an empty bucket (common on a fresh cycle or QA environment) fails instead of showing "no results".Steps to reproduce
PENDINGorMENTOR_REVIEWING.GET /admin/mentorship/cycles/{cycleId}/applications?status=PENDING,MENTOR_REVIEWING.X-API-KEYand a bearer token on any cycle / status combination that matches no records.Expected
200 OKwith an empty array[].Actual
500 Internal Server Error. Server logs showBadSqlGrammarExceptionwith the underlying messagesyntax error at or near ")"from a generated query of the shapeSELECT * FROM mentees WHERE mentee_id IN ().