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

User filtering problems with multiple filters

XMLWordPrintable

    • MOODLE_22_STABLE, MOODLE_23_STABLE, MOODLE_24_STABLE
    • MOODLE_22_STABLE, MOODLE_23_STABLE
    • wip-mdl-36767
    • 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

      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()

            rajeshtaneja Rajesh Taneja
            dmonllao David Monllaó
            Aparup Banerjee Aparup Banerjee
            David Monllaó David Monllaó
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved:

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