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

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

    XMLWordPrintable

Details

    Description

      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

      Attachments

        Issue Links

          Activity

            People

              skodak Petr Skoda (Inactive)
              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

              Dates

                Created:
                Updated:
                Resolved:

                Clockify

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