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

Error when saving calculated question - COLLATION 'utf8mb4_bin' not valid

    XMLWordPrintable

    Details

    • Affected Branches:
      MOODLE_34_STABLE, MOODLE_35_STABLE

      Description

      Hello

      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'
      SELECT a.*
      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
      Stack trace:

      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()

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              kdsciencet Kerrianne Draper
              Participants:
              Component watchers:
              Adrian Greeve, Jake Dallimore, Mathew May, Mihail Geshoski, Peter Dias, Jake Dallimore, Jun Pataleta, Tim Hunt, Andrew Nicols, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: