Reviewed: https://reviews.mahara.org/5074 Committed: https://git.nzoss.org.nz/mahara/mahara/commit/a227f3c76208d9178debcf36f4d4039d4b731f23 Submitter: Robert Lyon ([email protected]) Branch: 15.04_STABLE
commit a227f3c76208d9178debcf36f4d4039d4b731f23 Author: Son Nguyen <[email protected]> Date: Thu May 7 11:58:39 2015 +1200 Fix errors in artefact_get_descendants(). Bug 1452450 The 'path' column was not available before mahara 1.10 Change-Id: I147b62746f04d7a4145542007749cd1dd291baed (cherry picked from commit edea7dde6b21821d2d9425b07f796c3112ea8d84) -- 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 Committed Status in Mahara 15.10 series: Fix Committed 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 _______________________________________________ Mailing list: https://launchpad.net/~mahara-contributors Post to : [email protected] Unsubscribe : https://launchpad.net/~mahara-contributors More help : https://help.launchpad.net/ListHelp
