Error when upgrading mahara from 1.8.2 to 15.04
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Mahara |
Fix Released
|
High
|
Son Nguyen | ||
15.04 |
Fix Released
|
High
|
Unassigned | ||
15.10 |
Fix Released
|
High
|
Son Nguyen |
Bug Description
Reported from public
Error when upgrading from 1.8.2 to 15.04
[WAR] 53 (lib/errors.
LINE 4: WHERE path LIKE '%/49354/%' OR path LIKE '%/3846...
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/
log_warn("Failed to get a recordset: postgres8 error: [-1: E...") at /var/www/
SQLException-
get_column_sql(" SELECT DISTINCT id FROM {...") at /var/www/
artefact_
ArtefactType:
xmldb_core_
upgrade_
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/
artefact_
ArtefactType:
xmldb_core_
upgrade_
Changed in mahara: | |
status: | In Progress → Fix Committed |
Changed in mahara: | |
status: | Fix Committed → Fix Released |
summary: |
- Error when upgrad mahara from 1.8.2 to 15.04 + Error when upgrading mahara from 1.8.2 to 15.04 |
Changed in mahara: | |
status: | Fix Committed → Fix Released |
Patch for "master" branch: https:/ /reviews. mahara. org/4749