tutor/tutor-credentials
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
tutor-credentials/changelog.d/fix-mysql-concat.md
MuPp3t33r bc96768c69
fix: Update sync_users (#58) 
* fix: Update sync_users

fix issue during "sync credentials.core_user to openedx.auth_user"
ERROR 1292 (22007) at line 1: Truncated incorrect DOUBLE value: 'FirstName'

MySQL does not use + to concatenate strings, so it was treated as a math equation instead.
2025-08-22 10:50:28 +05:00

377 B
Raw Permalink Blame History

  • [Bugfix] Fixed an issue when syncing credentials.core_user to openedx.auth_user where the full_name field population failed with ERROR 1292 (22007): Truncated incorrect DOUBLE value: 'FirstName'.
    MySQL does not support string concatenation with +, so it was incorrectly treated as a numeric operation. Updated to use CONCAT() for proper string concatenation.