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

\quiz_statistics\task\recalculate, Error writing to database - Unknown column 'INF' in 'field list'

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Unresolved
    • Icon: Minor Minor
    • None
    • 4.1.10, 4.2.7, 4.3.4, 4.4
    • Questions
    • MOODLE_401_STABLE, MOODLE_402_STABLE, MOODLE_403_STABLE, MOODLE_404_STABLE

      Adhoc task failed: quiz_statistics\task\recalculate,Error writing to database (Unknown column 'INF' in 'field list'
      Debug info:
      Unknown column 'INF' in 'field list'
      INSERT INTO mdl_question_statistics (hashcode,timemodified,questionid,slot,subquestion,s,effectiveweight,negcovar,discriminationindex,discriminativeefficiency,sd,facility,subquestions,maxmark,positions,randomguessscore,variant) VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
      [array (
      0 => '798be96b0cf600cc5a41bc9c9a18fd1af1c94fa4',
      1 => 1716252616,
      2 => '109762',
      3 => 1,
      4 => 0,
      5 => 34,
      6 => 8.8824614278179137,
      7 => 0,
      8 => 41.303064934605821,
      9 => 50.867049910120862,
      10 => 0.73828079438161687,
      11 => 0.58823531764705894,
      12 => '',
      13 => '4.0000000',
      14 => 1,
      15 => INF,
      16 => NULL,
      )]
      Backtrace:

      • line 293 of /lib/dml/moodle_read_slave_trait.php: call to moodle_database->query_end()
      • line 1371 of /lib/dml/mysqli_native_moodle_database.php: call to mysqli_native_moodle_database->query_end()
      • line 1417 of /lib/dml/mysqli_native_moodle_database.php: call to mysqli_native_moodle_database->insert_record_raw()
      • line 232 of /question/classes/statistics/questions/calculated.php: call to mysqli_native_moodle_database->insert_record()
      • line 290 of /question/classes/statistics/questions/all_calculated_for_qubaid_condition.php: call to core_question\statistics\questions\calculated->cache()
      • line 259 of /question/classes/statistics/questions/calculator.php: call to core_question\statistics\questions\all_calculated_for_qubaid_condition->cache()
      • line 700 of /mod/quiz/report/statistics/report.php: call to core_question\statistics\questions\calculator->calculate()
      • line 1003 of /mod/quiz/report/statistics/report.php: call to quiz_statistics_report->get_all_stats_and_analysis()
      • line 98 of /mod/quiz/report/statistics/classes/task/recalculate.php: call to quiz_statistics_report->calculate_questions_stats_for_question_bank()
      • line 413 of /lib/cronlib.php: call to quiz_statistics\task\recalculate->execute()
      • line 252 of /lib/cronlib.php: call to cron_run_inner_adhoc_task()
      • line 272 of /lib/cronlib.php: call to cron_run_adhoc_task()
      • line 155 of /admin/cli/adhoc_task.php: call to cron_run_failed_adhoc_tasks()

      So far, we couldn't come up with replication steps, but this error was reported earlier in [MDL-77912|https://tracker.moodle.org/browse/MDL-77912
      ]

            Unassigned Unassigned
            vithushau Vithusha Kethiri
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 1 hour, 10 minutes
                1h 10m

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