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

check/access/riskbackup has non unique first column in sql

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Minor Minor
    • 3.11.5
    • 4.0
    • Performance
    • MOODLE_400_STABLE
    • MOODLE_311_STABLE
    • Hide
      1. Log in as admin
      2. Create two new courses (Course 1 & Course 2)
      3. For each course:
        • Navigate to Participants > Permissions
        • Add "Teacher" to "Roles with permission" for the "moodle/backup:userinfo" capability
      4. Navigate to Reports > Security checks in site administration
      5. Press More info for the Backup of user info check
      6. Confirm under These active overrides give users [...] you see:
        • Teacher in Course: Course 1
        • Teacher in Course: Course 2
      7. Confirm there is no warning about undefined property
      8. Confirm there is no exception about unknown class
      Show
      Log in as admin Create two new courses ( Course 1 & Course 2 ) For each course: Navigate to Participants > Permissions Add " Teacher"  to " Roles with permission" for the "moodle/backup:userinfo" capability Navigate to Reports > Security checks in site administration Press More info for the Backup of user info check Confirm under These active overrides give users [...] you see: Teacher in Course: Course 1 Teacher in Course: Course 2 Confirm there is no warning about undefined property Confirm there is no exception about unknown class

      This is debugging happens in some environments: 

      ++ Did you remember to make the first column something unique in your call to get_records? Duplicate value '3' found in column 'id'. ++

      • line 973 of /lib/dml/pgsql_native_moodle_database.php: call to debugging()
      • line 72 of /lib/classes/check/access/riskbackup_result.php: call to pgsql_native_moodle_database->get_records_sql()
      • line 66 of /lib/classes/check/access/riskbackup.php: call to core\check\access\riskbackup_result->__construct()

            pholden Paul Holden
            brendanheywood Brendan Heywood
            Brendan Heywood Brendan Heywood
            Sara Arjona (@sarjona) Sara Arjona (@sarjona)
            Gladys Basiana Gladys Basiana
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved:

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 1 hour, 45 minutes
                1h 45m

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