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

Database error when import 30+ multichoice answers for one question

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Duplicate
    • Icon: Major Major
    • None
    • 2.1.6, 2.2.3
    • Questions
    • MOODLE_21_STABLE, MOODLE_22_STABLE
    • Hide

      Increase the auto increment counter on mdl_question_multichoice to a very large number and export/import a mutlichoice question with lots of answers.

      Show
      Increase the auto increment counter on mdl_question_multichoice to a very large number and export/import a mutlichoice question with lots of answers.

      I'm having issues with importing a single question with 30+ multichoice answers and would like to request the multichoice question table be modified in the future to use an additional table for storing answer id?

      Question is stored in the answers field using 167 chars and when exported and imported can't be imported because the answers field content is now 266 chars.

      Original Question mutlichoice answers: 326034,326035,326036,326037,326038,326039,326040,326041,326042,326043,326044,326045,326046,326047,326048,326049,326050,326051,326052,326053,326054,326055,326056,326057

      Imported Question mutlichoice answers: 4574623,4574624,4574625,4574626,4574627,4574628,4574629,4574630,4574631,4574632,4574633,4574634,4574635,4574636,4574637,4574638,4574639,4574640,4574641,4574642,4574643,4574644,4574645,4574646,4574647,4574648,4574649,4574650,4574651,4574652,4574653,4574654,4574655

            timhunt Tim Hunt
            tlock Tim Lock
            Votes:
            5 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved:

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