@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%

https://github.com/LimeSurvey/LimeSurvey/pull/4307

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=38860

Fixed in Release 6.14.2+250610