@DenisChenu Unsure what to do here.

This seems to be failing because there is a corruption in DB.
Maybe linked to #20054.

Question here is if this method should return null if no language is found for that answer.
(or if it should return an "N/A", or a "?" or a "", or just the answer for the first language).
I incline for null.

This only happens with DEBUG, so maybe this is expected: When DEBUG is set and there are inconsistencies, errors should pop up?

This only happens with DEBUG, so maybe this is expected: When DEBUG is set and there are inconsistencies, errors should pop up?

My opinion about debug : it's a developer setting ! NOt a super admin or Survey administrator

Then :

1. DB issue must not throw 500 error
2. DB issue must have a way to be logged every time as error or warning (using Yii::log with specific categorie)
3. Bonus : a warning must be shown to survey admin about an issue in DB
4. Super bonus : a Survey option are allowed to Survey admin (not super admn) to automatically fix such DB issue ( i think i already report such feature : checkintegrity restriced to single survey)

Here : 1+2 are OK in my opinon.

Question here is if this method should return null if no language is found for that answer.
(or if it should return an "N/A", or a "?" or a "", or just the answer for the first language).

If exist In primary language but not in this language : code ? But NULL is OK too. fifty/fifty here .
If it does not exist in any language : NULL : 100%