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

    • MOODLE_39_STABLE
    • MOODLE_39_STABLE
    • MDL-68951-master
    • 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

      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
      

            dobedobedoh Andrew Lyons
            dobedobedoh Andrew Lyons
            Michael Hawkins Michael Hawkins
            Jun Pataleta Jun Pataleta
            Anna Carissa Sadia Anna Carissa Sadia
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved:

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

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