mahara-contributors team mailing list archive

[Ghada El-Zoghbi <ghada@xxxxxxxxxxxxxxx>]

*** This bug is a duplicate of bug 1338410 ***
    https://bugs.launchpad.net/bugs/1338410

** This bug has been marked a duplicate of bug 1338410
   Duplicate primary key upgrading from Mahara 1.1

-- 
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/1346731

Title:
  Upgrade error in 1.10.0dev - block instance

Status in Mahara ePortfolio:
  In Progress

Bug description:
  DB: Postgres
  Mahara: 1.10.0dev 
  OS: Linux
  Browser: FF 30

  An error is generated when upgrading Mahara from 1.1.0 or 1.1.6 or 1.4
  or 1.8 or 1.9 with the following error:

  :( Failed to get a recordset: postgres7 error: [-5: ERROR: duplicate key value violates unique constraint "blocinst_vierowcolord_uk" DETAIL: Key (view, "row", "column", "order")=(1, 1, 1, 3) already exists.] in adodb_throw(INSERT INTO "block_instance" ("id", "blocktype", "title", "configdata", "view", "column", "order", "row") VALUES (?, ?, ?, ?, ?, ?, ?, ?), Array) Command was: INSERT INTO "block_instance" ("id", "blocktype", "title", "configdata", "view", "column", "order", "row") VALUES (?, ?, ?, ?, ?, ?, ?, ?) and values was (73,profileinfo,About me,a:0:{},1,1,3,1)
  Call stack (most recent first):

      insert_record("block_instance", object(stdClass), "id", true) at /var/www/maharacode/mahara/htdocs/blocktype/lib.php:1029
      BlockInstance->commit() at /var/www/maharacode/mahara/htdocs/lib/db/upgrade.php:3245
      xmldb_core_upgrade("2014032708") at /var/www/maharacode/mahara/htdocs/lib/upgrade.php:325
      upgrade_core(object(stdClass)) at /var/www/maharacode/mahara/htdocs/admin/upgrade.json.php:86

  
  I started with a vanilla Mahara install from 1.1.0_RELEASE tag.  Added a view, a blog, resume items, a group, forum blogs, and users.

  Attempted to upgrade from 1.1.0 to 1.10.0dev but received error.

  Then tried:
  - upgraded from 1.1.0 to 1.1.6 - success.
  - tried to upgrade to 1.10.0dev - error

  Then,
  - upgraded from 1.1.6 to 1.4 - success
  - tried to upgrade from 1.4 to 1.10.0 dev - error

  Then,
  - upgraded from 1.4 to 1.8 - success
  - tried to upgrade from 1.8 to 1.10.0 dev - error

  Then,
  - upgraded from 1.8 to 1.9 - success
  - tried to upgrade from 1.9 to 1.10.0 dev - error

  Then,
  - upgraded from 1.9 to 1.10.0dev - error

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