Reviewed: https://reviews.mahara.org/1108 Committed: http://gitorious.org/mahara/mahara/commit/e1ceeff58ee16eeefba5fc880146c66fe1451f9f Submitter: Francois Marier ([email protected]) Branch: 1.5_STABLE
commit e1ceeff58ee16eeefba5fc880146c66fe1451f9f Author: Richard Mansfield <[email protected]> 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 <[email protected]> -- 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 _______________________________________________ Mailing list: https://launchpad.net/~mahara-contributors Post to : [email protected] Unsubscribe : https://launchpad.net/~mahara-contributors More help : https://help.launchpad.net/ListHelp
