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

'null' string in m_analytics_models since MDL-64739

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Major Major
    • 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;

      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.

            dmonllao David Monllaó
            dmonllao David Monllaó
            Peter Dias Peter Dias
            Eloy Lafuente (stronk7) Eloy Lafuente (stronk7)
            Gladys Basiana Gladys Basiana
            Votes:
            0 Vote for this issue
            Watchers:
            3 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, 51 minutes
                2h 51m

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