Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-45945

MS-SQL Collation in Temp Tables (as seen in LDAP Auth Import)

XMLWordPrintable

      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

            skodak Petr Skoda
            haniscor Ryan Hanisco
            Dan Poltawski Dan Poltawski
            Eloy Lafuente (stronk7) Eloy Lafuente (stronk7)
            Eloy Lafuente (stronk7) Eloy Lafuente (stronk7)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved:

                Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.