Uploaded image for project: 'Plugins'
  1. Plugins
  2. CONTRIB-3905

SQL query appears in cron output without any debugging enabled

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Cannot Reproduce
    • Icon: Minor Minor
    • None
    • 2.2
    • Block: Grade me
    • None
    • MOODLE_22_STABLE

      The following appears within the cron output on a site using this block:

      • Processing cron function for grade_me....
                    INSERT 
                    INTO {block_grade_me} (
                        SELECT 
                            gi.id `itemid`
                            , gi.itemname `itemname`
                            , gi.itemtype `itemtype`
                            , gi.itemmodule `itemmodule`
                            , gi.iteminstance `iteminstance`
                            , gi.sortorder `itemsortorder`
                            , c.id `courseid`
                            , c.shortname `coursename`
                            , cm.id `coursemoduleid` 
                        FROM {grade_items} gi 
                        LEFT JOIN {course} c 
                            ON gi.courseid = c.id 
                        LEFT JOIN {modules} m 
                            ON m.name = gi.itemmodule 
                        INNER JOIN {course_modules} cm 
                            ON cm.`course` = c.`id` 
                            AND cm.`module` = m.`id` 
                            AND cm.`instance` = gi.`iteminstance` 
                        WHERE gi.`itemtype` = :itemtype 
                            AND m.`name` IN ('assignment','data','forum','glossary','quiz') 
                        ORDER BY gi.id
                    ) 
                    ON DUPLICATE KEY UPDATE 
                        `itemname` = VALUES(`itemname`)
                        , `itemtype` = VALUES(`itemtype`)
                        , `itemmodule` = VALUES(`itemmodule`)
                        , `iteminstance` = VALUES(`iteminstance`)
                        , `itemsortorder` = VALUES(`itemsortorder`)
                        , `courseid` = VALUES(`courseid`)
                        , `coursename` = VALUES(`coursename`)
                        , `coursemoduleid` = VALUES(`coursemoduleid`)
                
        Updated block_grade_me cache in 0.642211 seconds

      This is from version 4.0 (Build: 2012080500) running on a 2.2.4+ site. It's probably happening in other versions, though, as well.

            dakota.duff Dakota Duff (Inactive)
            jfilip Justin Filip (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved:

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