I'm setting up question banks for my classes and I cannot get calculated questions to work. I cannot get past the first page of saving. When this error message comes up I noticed that the name and question text aren't recognised even though they contain text of similar style to other question types in my question bank.
Debug info: COLLATION 'utf8mb4_bin' is not valid for CHARACTER SET 'utf8'
FROM mdl_question_dataset_definitions a, mdl_question_datasets b
WHERE a.id = b.datasetdefinition AND a.type = '1' AND b.question = ? AND a.name COLLATE utf8mb4_bin = ? [array (
0 => '2758',
1 => 'scalebar',
Error code: dmlreadexception
line 486 of /lib/dml/moodle_database.php: dml_read_exception thrown
line 1245 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
line 1571 of /lib/dml/moodle_database.php: call to mysqli_native_moodle_database->get_records_sql()
line 1509 of /question/type/calculated/questiontype.php: call to moodle_database->get_record_sql()
line 1156 of /question/type/calculated/questiontype.php: call to qtype_calculated->dataset_options_from_database() line 544 of /question/type/calculated/questiontype.php: call to qtype_calculated->dataset_options()
line 656 of /question/type/calculated/questiontype.php: call to qtype_calculated->preparedatasets()
line 273 of /question/question.php: call to qtype_calculated->save_question()