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

Exception when applying sorting on some system reports

XMLWordPrintable

    • MOODLE_500_STABLE
    • MOODLE_500_STABLE
    • Hide
      1. Log in as admin
      2. Navigate to Users > Permissions > User policies in site administration
      3. Set Alternative full name format to "firstname middlename lastname"
      4. Navigate to your profile
      5. Press Edit profile
        • Set Middle name to "Zebra"
        • Set List of interests to "Lionel"
      6. Create a new user:
        • First name: Zoe
        • Last name: Apple
        • Middle name: Peach
      7. Navigate to Users > Accounts > Browse list of users
      8. Confirm you can sort the users by all of First name / Middle name / Last name fields (click the table header)
      9. Log out
      10. Log in as test user
      11. Navigate to your profile
      12. Press Edit profile
        • Set List of interests to "Lions"
      13. Log out
      14. Log in as admin
      15. Navigate to Appearance > Manage tags in site administration
      16. Press Default collection
      17. Confirm you can sort the users by all of First name / Middle name / Last name fields (click the table header)
      Show
      Log in as admin Navigate to Users > Permissions > User policies in site administration Set Alternative full name format to "firstname middlename lastname" Navigate to your profile Press Edit profile Set Middle name to "Zebra" Set List of interests to "Lionel" Create a new user: First name: Zoe Last name: Apple Middle name: Peach Navigate to Users > Accounts > Browse list of users Confirm you can sort the users by all of First name / Middle name / Last name fields (click the table header) Log out Log in as test user Navigate to your profile Press Edit profile Set List of interests to "Lions" Log out Log in as admin Navigate to Appearance > Manage tags in site administration Press Default collection Confirm you can sort the users by all of First name / Middle name / Last name fields (click the table header)
    • Hide

      Code verified against automated checks.

      Checked MDL-84789 using repository: https://github.com/paulholden/moodle/

      More information about this report

      Built on: Tue Mar 11 12:00:26 UTC 2025

      Show
      Code verified against automated checks. Checked MDL-84789 using repository: https://github.com/paulholden/moodle/ main (0 errors / 0 warnings) [branch: MDL-84789 | CI Job ] More information about this report Built on: Tue Mar 11 12:00:26 UTC 2025
    • Hide

      Launching automatic jobs for branch MDL-84789

      Built on: Tue Mar 11 11:28:35 UTC 2025

      Show
      Launching automatic jobs for branch MDL-84789 https://ci.moodle.org/view/Testing/job/DEV.01%20-%20Developer-requested%20Behat/63432/ Behat (Chrome - boost - pgsql / --tags @core_reportbuilder) https://ci.moodle.org/view/Testing/job/DEV.01%20-%20Developer-requested%20Behat/63433/ Behat (Chrome - boost - mariadb / --tags @core_reportbuilder) https://ci.moodle.org/view/Testing/job/DEV.01%20-%20Developer-requested%20Behat/63434/ Behat (Chrome - boost - sqlsrv / --tags @core_reportbuilder) https://ci.moodle.org/view/Testing/job/DEV.01%20-%20Developer-requested%20Behat/63435/ Behat (Chrome - boost - mysqli / --tags @core_reportbuilder) Built on: Tue Mar 11 11:28:35 UTC 2025

      We are getting an exception when applying sorting on the "Config changes" report:

      You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DESC, c1_timemodified DESC LIMIT 0, 30' at line 1
      		 
      SELECT results.*, 2888 AS rbalias14 FROM (SELECT rbalias0.timemodified AS c1_timemodified, rbalias1.firstname AS c2_firstname, rbalias1.middlename AS c2_middlename, rbalias1.lastname AS c2_lastname, rbalias1.id AS c2_id, rbalias0.plugin AS c3_plugin, rbalias0.name AS c4_name, rbalias0.value AS c5_value, rbalias0.oldvalue AS c6_oldvalue FROM mdl_config_log rbalias0 LEFT JOIN mdl_user rbalias1 ON rbalias1.id = rbalias0.userid WHERE 1=1 ) results ORDER BY  DESC, c1_timemodified DESC LIMIT 0, 30
      		 
      [array (
      		 
      )]

      It seems that the same is happening in the "Comments" and "Tag collections" report.

       

        1. (1) 17 Passed -- (Main)MDL-84789.png
          (1) 17 Passed -- (Main)MDL-84789.png
          65 kB
        2. (1) 8 Passed -- (Main)MDL-84789.png
          (1) 8 Passed -- (Main)MDL-84789.png
          135 kB

            pholden Paul Holden
            davidcarrillo David Carrillo
            Carlos Castillo Carlos Castillo
            David Carrillo David Carrillo
            Kim Jared Lucas Kim Jared Lucas
            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 - 2 hours, 40 minutes
                2h 40m

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