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, Andrew Nicols, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze, 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: