mahara-contributors team mailing list archive

[Mahara Bot <960631@xxxxxxxxxxxxxxxxxx>]

Reviewed:  https://reviews.mahara.org/1108
Committed: http://gitorious.org/mahara/mahara/commit/e1ceeff58ee16eeefba5fc880146c66fe1451f9f
Submitter: Francois Marier (francois@xxxxxxxxxxxxxxx)
Branch:    1.5_STABLE

commit e1ceeff58ee16eeefba5fc880146c66fe1451f9f
Author: Richard Mansfield <richard.mansfield@xxxxxxxxxxxxxxx>
Date:   Wed Mar 21 18:21:27 2012 +1300

    Display a message when plpgsql cannot be created (bug #960631)
    
    The upgrade to 1.5 requires that the plpgsql language is available in
    postgres, but sometimes (e.g. versions of postgres < 8.3), the
    database owner doesn't have permission to create the language, and the
    admin will have to do it manually.
    
    During the attempt to issue the CREATE LANGUAGE command, an sql
    exception can be thrown when the db user has insufficient privileges,
    so a generic 'nonrecoverable error occured' message is displayed
    instead of the useful message instructing the admin to create plpgsql.
    Catching the sql exception fixes this problem.
    
    Change-Id: I176bdd1eee2247426ceedc6f165156d33eefbb42
    Signed-off-by: Richard Mansfield <richard.mansfield@xxxxxxxxxxxxxxx>

-- 
You received this bug notification because you are a member of Mahara
Contributors, which is subscribed to Mahara.
https://bugs.launchpad.net/bugs/960631

Title:
  Upgrade to 1.5 fails if Postgres user does not have admin privs

Status in Mahara ePortfolio:
  Fix Committed

Bug description:
  When upgrading from 1.4.x to 1.5rc1, the database upgrade page
  reports: "A nonrecoverable error occured. This probably means you have
  encountered a bug in the system"

  It appears this is happening because the Postgres user does not have
  admin privs, which are required to run the CREATE LANGUAGE command.

  [DBG] 96 (lib/dml.php:159) postgres7 error: [-1: ERROR:  must be
  superuser to create procedural language] in EXECUTE("CREATE LANGUAGE
  plpgsql;"), referer: https://portfolio-
  stage.library.ucsf.edu/admin/upgrade.php

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