mahara-contributors team mailing list archive

[Aaron Wells <1452450@xxxxxxxxxxxxxxxxxx>]

** Changed in: mahara/15.10
       Status: Fix Committed => Fix Released

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

Title:
  Error when upgrading mahara from 1.8.2 to 15.04

Status in Mahara:
  Fix Committed
Status in Mahara 15.04 series:
  Fix Released
Status in Mahara 15.10 series:
  Fix Released

Bug description:
  Reported from public

  Error when upgrading from 1.8.2 to 15.04

  [WAR] 53 (lib/errors.php:747) Failed to get a recordset: postgres8 error: [-1: ERROR:  column "path" does not exist
  LINE 4:            WHERE path LIKE '%/49354/%' OR path LIKE '%/3846...
                            ^] in adodb_throw(
              SELECT DISTINCT id
              FROM "artefact"
              WHERE path LIKE '%/49354/%' OR path LIKE '%/3846/%' OR path LIKE '%/68/%' OR path LIKE '%/67/%' OR path LIKE '%/16/%' OR path LIKE '%/15/%' OR path LIKE '%/77/%'
              ORDER BY id, )
  Command was: 
              SELECT DISTINCT id
              FROM "artefact"
              WHERE path LIKE '%/49354/%' OR path LIKE '%/3846/%' OR path LIKE '%/68/%' OR path LIKE '%/67/%' OR path LIKE '%/16/%' OR path LIKE '%/15/%' OR path LIKE '%/77/%'
              ORDER BY id
  Call stack (most recent first):
  log_message("Failed to get a recordset: postgres8 error: [-1: E...", 8, true, true) at /var/www/mahara/lib/errors.php:97
  log_warn("Failed to get a recordset: postgres8 error: [-1: E...") at /var/www/mahara/lib/errors.php:747
  SQLException->__construct("Failed to get a recordset: postgres8 error: [-1: E...") at /var/www/mahara/lib/dml.php:847
  get_column_sql(" SELECT DISTINCT id FROM {...") at /var/www/mahara/artefact/lib.php:1789
  artefact_get_descendants(array(size 7)) at /var/www/mahara/artefact/lib.php:1295
  ArtefactType::update_locked("3") at /var/www/mahara/lib/db/upgrade.php:3118
  xmldb_core_upgrade("2013101410") at /var/www/mahara/lib/upgrade.php:359
  upgrade_core(object(stdClass)) at /var/www/mahara/admin/upgrade.json.php:86
  Performing upgrades...

  Component or plugin	From version	To version	Information
  core	1.8.2	15.04.0	 Failed to get a recordset: postgres8 error: [-1: ERROR: column "path" does not exist LINE 4: WHERE path LIKE '%/49354/%' OR path LIKE '%/3846... ^] in adodb_throw( SELECT DISTINCT id FROM "artefact" WHERE path LIKE '%/49354/%' OR path LIKE '%/3846/%' OR path LIKE '%/68/%' OR path LIKE '%/67/%' OR path LIKE '%/16/%' OR path LIKE '%/15/%' OR path LIKE '%/77/%' ORDER BY id, ) Command was: SELECT DISTINCT id FROM "artefact" WHERE path LIKE '%/49354/%' OR path LIKE '%/3846/%' OR path LIKE '%/68/%' OR path LIKE '%/67/%' OR path LIKE '%/16/%' OR path LIKE '%/15/%' OR path LIKE '%/77/%' ORDER BY id
  Call stack (most recent first):
  get_column_sql(" SELECT DISTINCT id FROM {...") at /var/www/mahara/artefact/lib.php:1789
  artefact_get_descendants(array(size 7)) at /var/www/mahara/artefact/lib.php:1295
  ArtefactType::update_locked("3") at /var/www/mahara/lib/db/upgrade.php:3118
  xmldb_core_upgrade("2013101410") at /var/www/mahara/lib/upgrade.php:359
  upgrade_core(object(stdClass)) at /var/www/mahara/admin/upgrade.json.php:86

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