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

Spam cleaner tool Incorrect number of query parameters error

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.0.2
    • Fix Version/s: 2.0.3
    • Component/s: Administration
    • Labels:
    • Difficulty:
      Moderate
    • Affected Branches:
      MOODLE_20_STABLE
    • Fixed Branches:
      MOODLE_20_STABLE

      Description

      Site administration>Reports>Spam cleaner.

      Steps taken
      Enter a set of keywords and click on search
      Or Click on Autodetect spam

      ERROR
      ERROR: Incorrect number of query parameters. Expected x, got 0.
      Where x is the number of keywords you typed plus one

      Stack trace:

      • line 697 of \lib\dml\moodle_database.php: dml_exception thrown
      • line 743 of \lib\dml\mysqli_native_moodle_database.php: call to moodle_database->fix_sql_params()
      • line 165 of \admin\report\spamcleaner\index.php: call to mysqli_native_moodle_database->get_recordset_sql()
      • line 129 of \admin\report\spamcleaner\index.php: call to search_spammers()

      First look comments
      Clearly get_recordset_sql() is missing second set of arguments

        Attachments

          Activity

            People

            Assignee:
            skodak Petr Skoda
            Reporter:
            ankit_frenz Ankit Agarwal
            Tester:
            Sam Hemelryk
            Participants:
            Component watchers:
            Andrew Nicols, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Fix Release Date:
              5/May/11