mahara-contributors team mailing list archive

[Aaron Wells <1238363@xxxxxxxxxxxxxxxxxx>]

Traced it to the commit 55fe25fe57c2e6e13889f7b66e748607d464911a, in
1.2.0alpha3_release

Prior to this, "unique keys" specified as such in an install.xml file
were actually created as unique indexes. This commit added support for
true unique keys.

That's something to look out for on other upgrades. In fact, I'll file a
bug about seeing if we can find all those legacy indexes and convert
them into keys.

-- 
You received this bug notification because you are a member of Mahara
Contributors, which is subscribed to Mahara.
Matching subscriptions: Subscription for all Mahara Contributors -- please ask on #mahara-dev or mahara.org forum before editing or unsubscribing it!
https://bugs.launchpad.net/bugs/1238363

Title:
  Can't upgrade to 1.8rc1 because block_instance has an index instead of
  a key

Status in Mahara ePortfolio:
  Confirmed

Bug description:
  See https://mahara.org/interaction/forum/topic.php?id=5770

  At least three sites have had fatal errors while attempting to upgrade
  to 1.8rc1, because their block_instance table does not have a key
  called blockinst_viecolord_uk. Instead, the table has a unique index
  called blockinst_viecolord_uix

  This particular key/index is a uniqueness key on the block_instance
  table, across the (view, column, order) columns. In the code, it's
  referred to as "viewcolumnorderuk". As part of the flexible layouts
  update, we replace it with a key on (view, row, column, order). To do
  that, we call drop_key() on the original. Unfortunately, the
  drop_key() method throws a fatal error if the key is not present.

  At least two of the three reporting sites have been around since
  before Mahara version 1.0. However, it's to be expected that many of
  the biggest and highest-profile Mahara sites will have been around for
  a long time, so we should provide them with a clean upgrade path where
  possible.

To manage notifications about this bug go to:
https://bugs.launchpad.net/mahara/+bug/1238363/+subscriptions