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

Mod Question Create Error reading from database

XMLWordPrintable

    • Icon: Improvement Improvement
    • Resolution: Unresolved
    • Icon: Minor Minor
    • None
    • 4.2.2
    • None
    • 2018051500
    • MOODLE_402_STABLE

      Our Cron shows these errors multiple times:

      Execute scheduled task: Update question creation activity grades (mod_qcreate\task\update_grades) ... started 21:52:20. Current memory use 13.3 MB. ... used 5 dbqueries ... used 0.01939582824707 seconds Scheduled task failed: Update question creation activity grades (mod_qcreate\task\update_grades),Error reading from database (Unknown column 'q.category' in 'where clause' SELECT q.* FROM mdl_question_categories qc, mdl_question q LEFT JOIN mdl_qcreate_grades g ON q.id = g.questionid WHERE g.timemarked IS NULL AND q.createdby IN (9,8051,8228,368,4311,4306,1377,202,627,1393,8289,6699,10,1514,7660,396,1442,4280,5768,680,575,200,3719,1444,1351,786,5,20,634,4664,1873,1571,4460,4088,8288,23,1378,3983,4602,4,20409,785,372,16,3330,4430,705,4939,16851,1959,2044,11,771,1195,17169) AND qc.id = q.category AND q.hidden='0' AND q.parent='0' AND qc.contextid =84539 [array ( )]) Debug info: Unknown column 'q.category' in 'where clause' SELECT q.* FROM mdl_question_categories qc, mdl_question q LEFT JOIN mdl_qcreate_grades g ON q.id = g.questionid WHERE g.timemarked IS NULL AND q.createdby IN (9,8051,8228,368,4311,4306,1377,202,627,1393,8289,6699,10,1514,7660,396,1442,4280,5768,680,575,200,3719,1444,1351,786,5,20,634,4664,1873,1571,4460,4088,8288,23,1378,3983,4602,4,20409,785,372,16,3330,4430,705,4939,16851,1959,2044,11,771,1195,17169) AND qc.id = q.category AND q.hidden='0' AND q.parent='0' AND qc.contextid =84539 [array ( )] Backtrace: * line 293 of /lib/dml/moodle_read_slave_trait.php: call to moodle_database->query_end() * line 1314 of /lib/dml/mysqli_native_moodle_database.php: call to mysqli_native_moodle_database->query_end() * line 67 of /mod/qcreate/classes/task/update_grades.php: call to mysqli_native_moodle_database->get_recordset_sql() * line 405 of /lib/classes/cron.php: call to mod_qcreate\task\update_grades->execute() * line 208 of /lib/classes/cron.php: call to core\cron::run_inner_scheduled_task() * line 125 of /lib/classes/cron.php: call to core\cron::run_scheduled_tasks() * line 186 of /admin/cli/cron.php: call to core\cron::run_main_process()

            Unassigned Unassigned
            elodelta Richard van Iwaarden
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:

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