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

wrong field setup for mdl_sessions table when using db_sessions for MySQL

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Minor Minor
    • 1.7
    • 1.5.4
    • Database SQL/XMLDB
    • None
    • MySQL
    • MOODLE_15_STABLE
    • MOODLE_17_STABLE

      The sesskey field in mdl_sessions is not set as binary, but binary queries happen on it... this means the index it has is useless.

      ALTER TABLE mdl_sessions CHANGE sesskey sesskey varchar(32) binary NOT NULL default '';

            skodak Petr Skoda (Inactive)
            jgraham Jeff Graham
            Nobody Nobody
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved:

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