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

'null' string in m_analytics_models since MDL-64739

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 3.8
    • 3.8
    • Analytics
    • MOODLE_38_STABLE
    • MOODLE_38_STABLE
    • MDL-67038_master
    • Hide
      1. Go to site admin > analytics > analytics models
      2. Click on Actions > Edit for the Upcoming activities due model
      3. Save changes
      4. You SHOULD not see any debugging nor PHP notice
      5. Click on Actions > Edit for the Upcoming activities due model
      6. Save changes
      7. You SHOULD not see any debugging nor PHP notice
      8. Open your database client and execute the following query. No records should have a 'null' string in the contextids field

        select id, target, contextids from mdl_analytics_models;

      Show
      Go to site admin > analytics > analytics models Click on Actions > Edit for the Upcoming activities due model Save changes You SHOULD not see any debugging nor PHP notice Click on Actions > Edit for the Upcoming activities due model Save changes You SHOULD not see any debugging nor PHP notice Open your database client and execute the following query. No records should have a 'null' string in the contextids field select id, target, contextids from mdl_analytics_models;

    Description

      The upcoming_activities_due model has a 'null' string for the contextids field in the m_analytics_models table. I saw this in my site after upgrading to a weekly with MDL-64739 but I couldn't reproduce it at a later stage and I thought that it was a problem in my dev envinronment. jaked has the same problem so there is something that didn't go well. The field is set as notnull.

      Attachments

        Issue Links

          Activity

            People

              dmonllao David Monllaó
              dmonllao David Monllaó
              Peter Dias Peter Dias
              Eloy Lafuente (stronk7) Eloy Lafuente (stronk7)
              Gladys Basiana Gladys Basiana
              David Woloszyn, Huong Nguyen, Jake Dallimore, Michael Hawkins, Stevani Andolo
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                18/Nov/19

                Time Tracking

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