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

Db failed to update from 1.8 to 1.9

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.9
    • Fix Version/s: 1.9
    • Labels:
      None
    • Environment:
      LAMP
    • Affected Branches:
      MOODLE_19_STABLE
    • Fixed Branches:
      MOODLE_19_STABLE

      Description

      Just installed today's version of moodle1.9 on a backup system. Installed a backup copy of a mysql database from my working 1.8 system.

      Update program told me that my system met the requirements for 1.9 and then went on to update the database.

      This failed with the following message:

      (mysql): CREATE UNIQUE INDEX mdl_evenhand_evehan_uix ON mdl_events_handlers (eventname, handlermodule) 1071: Specified key was too long; max key length is 1000 bytes

      ADOConnection._Execute(CREATE UNIQUE INDEX mdl_evenhand_evehan_uix ON mdl_events_handlers (eventname, handlermodule), false) % line 891, file: adodb.inc.php
      ADOConnection.Execute(CREATE UNIQUE INDEX mdl_evenhand_evehan_uix ON mdl_events_handlers (eventname, handlermodule)) % line 89, file: dmllib.php
      execute_sql(CREATE UNIQUE INDEX mdl_evenhand_evehan_uix ON mdl_events_handlers (eventname, handlermodule), true) % line 1899, file: dmllib.php
      execute_sql_arr(Array[3], true, true) % line 581, file: ddllib.php
      create_table(Object:XMLDBTable) % line 765, file: upgrade.php

      Main Upgrade failed! See lib/db/upgrade.php

      It did then go on to complete the installation which seems to work, though I have not fully tested it.

        Attachments

          Activity

            People

            Assignee:
            lazyfish Yu Zhang
            Reporter:
            j.ryan John Ryan
            Tester:
            Nobody
            Participants:
            Component watchers:
            Adrian Greeve, Jake Dallimore, Mathew May, Mihail Geshoski, Peter Dias, Sujith Haridasan
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

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