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

SiteAdmin->Users->permission->defineroles => allow roles switches tab page has SQL errors.

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 2.0
    • Fix Version/s: 2.0
    • Component/s: Administration
    • Labels:
      None
    • Affected Branches:
      MOODLE_20_STABLE
    • Fixed Branches:
      MOODLE_20_STABLE

      Description

      has the table

      {roles}

      been renamed to

      {role}

      recently?
      admin/roles/allow.php?mode=switch is broke

      Debug info: Table 'moodle.mdl_roles' doesn't exist
      SELECT roleid, 1 FROM mdl_roles ORDER BY id
      [array (
      )]
      Stack trace:

      • line 378 of /lib/dml/moodle_database.php: dml_read_exception thrown
      • line 632 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
      • line 1048 of /lib/dml/moodle_database.php: call to mysqli_native_moodle_database->get_records_sql()
      • line 997 of /lib/dml/moodle_database.php: call to moodle_database->get_records_select()
      • line 1088 of /lib/dml/moodle_database.php: call to moodle_database->get_records()
      • line 1447 of /admin/roles/lib.php: call to moodle_database->get_records_menu()
      • line 1268 of /admin/roles/lib.php: call to role_allow_switch_page->load_required_roles()
      • line 1441 of /admin/roles/lib.php: call to role_allow_role_page->__construct()
      • line 47 of /admin/roles/allow.php: call to role_allow_switch_page->__construct()

        Attachments

          Activity

            People

            • Assignee:
              nebgor Aparup Banerjee
              Reporter:
              nebgor Aparup Banerjee
              Tester:
              Nobody
              Participants:
              Component watchers:
              Andrew Nicols, Mathew May, Michael Hawkins, Shamim Rezaie, Simey Lameze
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Fix Release Date:
                24/Nov/10