Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-68459 Fix problems reported in apache logs before 3.9 release
  3. MDL-68951

Problem G: Negative limitfrom query parameter detected. It happen 2-3 times.

    XMLWordPrintable

    Details

    • Testing Instructions:
      Hide
      1. In a console window, tail your web server's logs, i.e. (system-dependant):

        tail -f /var/log/apache2/error.log
        

      2. Open a course with more than 20 participants
      3. Navigate to the participants page
      4. Press the "Show all [count]" link
        1. Confirm that there were no errors in the log you are tailing
      5. Press the "Show 20 per page" link
        1. Confirm that there were no errors in the log you are tailing
      6. Press the "Select all [count]" button
        1. Confirm that there were no errors in the log you are tailing
      7. Press the "Show 20 per page" link
      8. Press the "Enrol users" button
      9. Choose one or more users to enrol
      10. Press the "Enrol users" button
        1. Confirm that you see a message at the top of the page informing you that the users were enrolled
        2. Confirm that the users were added to the course
      Show
      In a console window, tail your web server's logs, i.e. (system-dependant): tail -f /var/log/apache2/error.log Open a course with more than 20 participants Navigate to the participants page Press the "Show all [count] " link Confirm that there were no errors in the log you are tailing Press the "Show 20 per page" link Confirm that there were no errors in the log you are tailing Press the "Select all [count] " button Confirm that there were no errors in the log you are tailing Press the "Show 20 per page" link Press the "Enrol users" button Choose one or more users to enrol Press the "Enrol users" button Confirm that you see a message at the top of the page informing you that the users were enrolled Confirm that the users were added to the course
    • Affected Branches:
      MOODLE_39_STABLE
    • Fixed Branches:
      MOODLE_39_STABLE
    • Pull Master Branch:
      MDL-68951-master

      Description

      77330:[Sat Jun 06 18:29:19.706989 2020] [php7:notice] [pid 15268] [client 172.22.0.5:49594] Debugging: Negative limitfrom parameter detected: -21, did you pass the correct arguments? in
       * line 1060 of /lib/dml/moodle_database.php: call to debugging()
       * line 867 of /lib/dml/sqlsrv_native_moodle_database.php: call to moodle_database->normalise_limit_from_num()
       * line 117 of /user/classes/table/participants_search.php: call to sqlsrv_native_moodle_database->get_recordset_sql()
       * line 416 of /user/classes/table/participants.php: call to core_user\\table\\participants_search->get_participants()
       * line 2024 of /lib/tablelib.php: call to core_user\\table\\participants->query_db()
       * line 210 of /user/classes/table/participants.php: call to table_sql->out()
       * line 262 of /lib/table/classes/external/dynamic/get.php: call to core_user\\table\\participants->out()
       * line 255 of /lib/externallib.php: call to core_table\\external\\dynamic\\get::execute()
       * line 81 of /lib/ajax/service.php: call to external_api::call_external_function()\n
      , referer: http://run43c1f73b3e13e6a1/behatrun3/user/index.php?id=2
      

        Attachments

          Activity

            People

            Assignee:
            dobedobedoh Andrew Nicols
            Reporter:
            dobedobedoh Andrew Nicols
            Peer reviewer:
            Michael Hawkins
            Integrator:
            Jun Pataleta
            Tester:
            Anna Carissa Sadia
            Participants:
            Component watchers:
            Amaia Anabitarte, Carlos Escobedo, Ferran Recio, Sara Arjona (@sarjona), Amaia Anabitarte, Carlos Escobedo, Ferran Recio, Sara Arjona (@sarjona)
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Fix Release Date:
              15/Jun/20

                Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 4 hours, 40 minutes
                4h 40m