-
Bug
-
Resolution: Fixed
-
Major
-
2.6.3, 2.7
-
MOODLE_26_STABLE, MOODLE_27_STABLE
-
MOODLE_27_STABLE
-
wip_
MDL-45945_m28_mssqlcol -
When running the LDAP Sync an error message is displayed stating that a collation conflict is causing a compare issue and no records are returned.
This seems to be happening because the collation settings on the MS SQL 2008 R2 Master DB are different from the Collation settings on the Moodle database. When a temp table is created (as it apparently is in the LDAP sync operation) it is created with the collation of the TempDB, by default, which is inherited from the MasterDB.
The creation query of the temp table should be modified to contain 'COLLATE database_default' so that it inherits the collation of the Moodle database rather than the instance default.
The error message is posted at:
https://moodle.org/mod/forum/discuss.php?d=261836
- caused a regression
-
MDL-46327 Oracle phpunit tests stopping after exception
-
- Closed
-