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

User filtering problems with multiple filters

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 2.2.6, 2.3.3, 2.4
    • Fix Version/s: 2.2.7, 2.3.4
    • Component/s: Administration
    • Labels:
    • Testing Instructions:
      Hide

      Test 1:

      Run MDLQA-4823

      Test 2:

      1. Go to browse users
      2. Add 'suspended' filter
      3. Add a 'auth' filter
      4. Click add filter and you should not see any error and check result if it's correct
      5. Add a 'confirmed' filter and you should not see any error
      6. Remove 'suspended' filter and no error should occur.
      7. Try adding filter on bulk user actions page and you should not see any error
      Show
      Test 1: Run MDLQA-4823 Test 2: Go to browse users Add 'suspended' filter Add a 'auth' filter Click add filter and you should not see any error and check result if it's correct Add a 'confirmed' filter and you should not see any error Remove 'suspended' filter and no error should occur. Try adding filter on bulk user actions page and you should not see any error
    • Affected Branches:
      MOODLE_22_STABLE, MOODLE_23_STABLE, MOODLE_24_STABLE
    • Fixed Branches:
      MOODLE_22_STABLE, MOODLE_23_STABLE
    • Pull Master Branch:
      wip-mdl-36767

      Description

      Discovered while testing http://tracker.moodle.org/browse/MDLQA-4823

      Steps to reproduce:

      1. Go to browse users or to bulk user actions
      2. Add a 'confirmed' or 'suspended' filter
      3. Add a 'auth' filter

      When you press the 'Filter' button an error is thrown.

      Debug info: 
      Error code: invalidqueryparam
      Stack trace:
      line 800 of /lib/dml/moodle_database.php: dml_exception thrown
      line 1018 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->fix_sql_params()
      line 425 of /lib/datalib.php: call to mysqli_native_moodle_database->get_records_sql()
      line 186 of /admin/user.php: call to get_users_listing()
      

      I've also reproduced the problem in latests moodle 23 integration and moodle 22 integration

      Debug info: 
      Error code: invalidqueryparam
      Stack trace:
      line 783 of /lib/dml/moodle_database.php: dml_exception thrown
      line 961 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->fix_sql_params()
      line 318 of /lib/datalib.php: call to mysqli_native_moodle_database->get_records_sql()
      line 186 of /admin/user.php: call to get_users_listing()
      

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Votes:
                  0 Vote for this issue
                  Watchers:
                  0 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:
                    Fix Release Date:
                    14/Jan/13