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

1.9 beta upgrade error

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.9
    • Fix Version/s: 1.9
    • Component/s: Installation
    • Labels:
      None
    • Environment:
      Moodle 1.8.2+ today's stable, ugrade to 1.9 beta
      MySQL 5.0.45
    • Affected Branches:
      MOODLE_19_STABLE
    • Fixed Branches:
      MOODLE_19_STABLE

      Description

      While doing an upgrade to the 1.9 beta I get this error during the upgrade scripts:

      (mysql): ALTER TABLE mdl_question_multichoice ADD answernumbering enum('abc', 'ABC', '123', 'none') NOT NULL DEFAULT 'abc' after incorrectfeedback

      1291: Column 'answernumbering' has duplicated value 'abc' in ENUM

      ADOConnection._Execute(ALTER TABLE mdl_question_multichoice ADD answernumbering enum('abc', 'ABC', '123', 'none') NOT NULL DEFAULT 'abc' after incorrec..., false) % line 891, file: adodb.inc.php
      ADOConnection.Execute(ALTER TABLE mdl_question_multichoice ADD answernumbering enum('abc', 'ABC', '123', 'none') NOT NULL DEFAULT 'abc' after incorrec...) % line 89, file: dmllib.php
      execute_sql(ALTER TABLE mdl_question_multichoice ADD answernumbering enum('abc', 'ABC', '123', 'none') NOT NULL DEFAULT 'abc' after incorrec..., true) % line 2033, file: dmllib.php
      execute_sql_arr(Array[1], true, true) % line 771, file: ddllib.php
      add_field(Object:XMLDBTable, Object:XMLDBField) % line 43, file: upgrade.php

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              timhunt Tim Hunt
              Reporter:
              smithrn Ryan Smith
              Tester:
              Nobody
              Participants:
              Component watchers:
              Matteo Scaramuccia, Andrew Nicols, Dongsheng Cai, Huong Nguyen, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Fix Release Date:
                3/Mar/08