Exceptions when running Recalculate question statistics scheduled task

Coding error detected, it must be fixed by a programmer: moodle_database::get_in_or_equal() does not accept empty arrays

Error code: codingerror

* line 770 of /lib/dml/moodle_database.php: coding_exception thrown

* line 441 of /lib/dml/pgsql_native_moodle_database.php: call to moodle_database->get_in_or_equal()

* line 564 of /question/engine/datalib.php: call to pgsql_native_moodle_database->get_in_or_equal()

* line 294 of /question/classes/statistics/questions/calculator.php: call to question_engine_data_mapper->load_questions_usages_latest_steps()

* line 96 of /question/classes/statistics/questions/calculator.php: call to core_question\statistics\questions\calculator->get_latest_steps()

* line 650 of /mod/quiz/report/statistics/report.php: call to core_question\statistics\questions\calculator->calculate()

* line 941 of /mod/quiz/report/statistics/report.php: call to quiz_statistics_report->get_all_stats_and_analysis()

* line 105 of /mod/quiz/report/statistics/classes/task/recalculate.php: call to quiz_statistics_report->calculate_questions_stats_for_question_bank()

* line 253 of /lib/cronlib.php: call to quiz_statistics\task\recalculate->execute()

* line 120 of /lib/cronlib.php: call to cron_run_inner_scheduled_task()

* line 73 of /lib/cronlib.php: call to cron_run_scheduled_tasks()

* line 178 of /admin/cli/cron.php: call to cron_run()

Coding error detected, it must be fixed by a programmer: Unknown question type subquestion_replacement

Error code: codingerror

* line 95 of /question/engine/bank.php: coding_exception thrown

* line 319 of /question/type/multianswer/questiontype.php: call to question_bank::get_qtype()

* line 471 of /question/classes/statistics/questions/calculator.php: call to qtype_multianswer->get_random_guess_score()

* line 162 of /question/classes/statistics/questions/calculator.php: call to core_question\statistics\questions\calculator->get_random_guess_score()

* line 650 of /mod/quiz/report/statistics/report.php: call to core_question\statistics\questions\calculator->calculate()

* line 941 of /mod/quiz/report/statistics/report.php: call to quiz_statistics_report->get_all_stats_and_analysis()

* line 105 of /mod/quiz/report/statistics/classes/task/recalculate.php: call to quiz_statistics_report->calculate_questions_stats_for_question_bank()

* line 253 of /lib/cronlib.php: call to quiz_statistics\task\recalculate->execute()

* line 120 of /lib/cronlib.php: call to cron_run_inner_scheduled_task()

* line 73 of /lib/cronlib.php: call to cron_run_scheduled_tasks()

* line 178 of /admin/cli/cron.php: call to cron_run()

Error reading from database

ERROR:  invalid input syntax for type bigint: "s1794781"

CONTEXT:  unnamed portal parameter $1 = '...'

SELECT q.*,

                   qc.id as category,

                   qv.status,

                   qv.id as versionid,

                   qv.version,

                   qv.questionbankentryid,

                   qc.contextid as contextid

              FROM mdl_question q

              JOIN mdl_question_versions qv

                ON qv.questionid = q.id

              JOIN mdl_question_bank_entries qbe

                ON qbe.id = qv.questionbankentryid

              JOIN mdl_question_categories qc

                ON qc.id = qbe.questioncategoryid

              WHERE q.id IN ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14)

[array (

  0 => 's1794781',

  1 => 's1794780',

  2 => '16880965',

  3 => '16880966',

  4 => '16880955',

  5 => '16880957',

  6 => '16880959',

  7 => '16880961',

  8 => '16880958',

  9 => '16880956',

  10 => '16880934',

  11 => '16880932',

  12 => '16880931',

  13 => '16880962',

)]

Error code: dmlreadexception

* line 486 of /lib/dml/moodle_database.php: dml_read_exception thrown

* line 291 of /lib/dml/moodle_read_slave_trait.php: call to moodle_database->query_end()

* line 338 of /lib/dml/pgsql_native_moodle_database.php: call to pgsql_native_moodle_database->read_slave_query_end()

* line 1017 of /lib/dml/pgsql_native_moodle_database.php: call to pgsql_native_moodle_database->query_end()

* line 905 of /lib/questionlib.php: call to pgsql_native_moodle_database->get_records_sql()

* line 924 of /lib/questionlib.php: call to question_preload_questions()

* line 852 of /mod/quiz/report/statistics/report.php: call to question_load_questions()

* line 939 of /mod/quiz/report/statistics/report.php: call to quiz_statistics_report->load_and_initialise_questions_for_calculations()

* line 105 of /mod/quiz/report/statistics/classes/task/recalculate.php: call to quiz_statistics_report->calculate_questions_stats_for_question_bank()

* line 253 of /lib/cronlib.php: call to quiz_statistics\task\recalculate->execute()

* line 120 of /lib/cronlib.php: call to cron_run_inner_scheduled_task()

* line 73 of /lib/cronlib.php: call to cron_run_scheduled_tasks()

* line 178 of /admin/cli/cron.php: call to cron_run()

Error writing to database

ERROR:  numeric field overflow

DETAIL:  A field with precision 12, scale 7 cannot hold an infinite value.

INSERT INTO mdl_question_statistics (hashcode,timemodified,questionid,slot,subquestion,s,effectiveweight,negcovar,discriminationindex,discriminativeefficiency,sd,facility,subquestions,maxmark,positions,randomguessscore,variant) VALUES($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17) 

[array (

  'hashcode' => '63b8150b9998197bf4af7909c6ebcd6d57ce421f',

  'timemodified' => 1674968969,

  'questionid' => '20660117',

  'slot' => 14,

  'subquestion' => 0,

  's' => 5,

  'effectiveweight' => NULL,

  'negcovar' => 0,

  'discriminationindex' => NULL,

  'discriminativeefficiency' => NULL,

  'sd' => 0.0,

  'facility' => NULL,

  'subquestions' => '',

  'maxmark' => '0.0000000',

  'positions' => 12,

  'randomguessscore' => INF,

  'variant' => NULL,

)]

Error code: dmlwriteexception

* line 489 of /lib/dml/moodle_database.php: dml_write_exception thrown

* line 291 of /lib/dml/moodle_read_slave_trait.php: call to moodle_database->query_end()

* line 338 of /lib/dml/pgsql_native_moodle_database.php: call to pgsql_native_moodle_database->read_slave_query_end()

* line 1122 of /lib/dml/pgsql_native_moodle_database.php: call to pgsql_native_moodle_database->query_end()

* line 1170 of /lib/dml/pgsql_native_moodle_database.php: call to pgsql_native_moodle_database->insert_record_raw()

* line 231 of /question/classes/statistics/questions/calculated.php: call to pgsql_native_moodle_database->insert_record()

* line 259 of /question/classes/statistics/questions/all_calculated_for_qubaid_condition.php: call to core_question\statistics\questions\calculated->cache()

* line 258 of /question/classes/statistics/questions/calculator.php: call to core_question\statistics\questions\all_calculated_for_qubaid_condition->cache()

* line 650 of /mod/quiz/report/statistics/report.php: call to core_question\statistics\questions\calculator->calculate()

* line 941 of /mod/quiz/report/statistics/report.php: call to quiz_statistics_report->get_all_stats_and_analysis()

* line 105 of /mod/quiz/report/statistics/classes/task/recalculate.php: call to quiz_statistics_report->calculate_questions_stats_for_question_bank()

* line 253 of /lib/cronlib.php: call to quiz_statistics\task\recalculate->execute()

* line 120 of /lib/cronlib.php: call to cron_run_inner_scheduled_task()

* line 73 of /lib/cronlib.php: call to cron_run_scheduled_tasks()

* line 178 of /admin/cli/cron.php: call to cron_run()