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

Update course timemodified on bulk category move

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 3.8
    • Fix Version/s: 3.7.5, 3.8.2
    • Component/s: Course
    • Labels:
    • Testing Instructions:
      Hide

      Requirements

      1. Access to Moodle database.

       

      Testing scenario

      1. Login as admin.
      2. Go to Site administration > Courses > Manage courses and categories.
      3. Create a couple of courses into the "Miscellaneous" category.
      4. Execute the following SQL and take note of their 'timemodified' value: 

        SELECT id, category, fullname, timecreated, timemodified FROM mdl_course ORDER BY id DESC

      1. Check the 'timemodified' is exactly the same as the 'timecreated'.
      2. Go to Site administration > Courses > Manage courses and categories.
      3. Create a course category.
      4. In the 'Miscellaneous' box on the right, mark as selected the courses you've checked in the database.
      5. Select a different category in 'Move selected courses to...' dropdown, and click Move.
      6. Go to Site administration > Reports > Live logs.
      7. Check a new 'Course updated' event has been created for each moved course.
      8. Execute the following SQL:

        SELECT id, category, fullname, timecreated, timemodified FROM mdl_course ORDER BY id DESC

      1. Check in the database 'timemodified' field for those courses has changed.
      Show
      Requirements Access to Moodle database.   Testing scenario Login as admin. Go to Site administration > Courses > Manage courses and categories. Create a couple of courses into the "Miscellaneous" category. Execute the following SQL and take note of their 'timemodified' value:  SELECT id, category, fullname, timecreated, timemodified FROM mdl_course ORDER BY id DESC Check the 'timemodified' is exactly the same as the 'timecreated'. Go to Site administration > Courses > Manage courses and categories. Create a course category. In the 'Miscellaneous' box on the right, mark as selected the courses you've checked in the database. Select a different category in 'Move selected courses to...' dropdown, and click Move. Go to Site administration > Reports > Live logs. Check a new 'Course updated' event has been created for each moved course. Execute the following SQL: SELECT id, category, fullname, timecreated, timemodified FROM mdl_course ORDER BY id DESC Check in the database 'timemodified' field for those courses has changed.
    • Affected Branches:
      MOODLE_38_STABLE
    • Fixed Branches:
      MOODLE_37_STABLE, MOODLE_38_STABLE
    • Pull 3.7 Branch:
    • Pull 3.8 Branch:
    • Pull Master Branch:
      MDL-67638_master

      Description

      When a course is moved from one category to another on the category list screen, its timemodified date should be updated to the current time.

        Attachments

          Activity

            People

            Assignee:
            tiennguyenphuc Tien Nguyen
            Reporter:
            tiennguyenphuc Tien Nguyen
            Peer reviewer:
            Amaia Anabitarte
            Integrator:
            Sara Arjona (@sarjona)
            Tester:
            Janelle Barcega
            Participants:
            Component watchers:
            Amaia Anabitarte, Carlos Escobedo, Ferran Recio, Sara Arjona (@sarjona), Víctor Déniz Falcón
            Votes:
            1 Vote for this issue
            Watchers:
            5 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Fix Release Date:
              9/Mar/20

                Time Tracking

                Estimated:
                Original Estimate - 0 minutes
                0m
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 2 hours, 25 minutes
                2h 25m