Core database upgrade fails from 1.4.2 to 1.5rc1
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Mahara |
Fix Released
|
High
|
Richard Mansfield |
Bug Description
Now that the CREATE LANGUAGE issue is resolved, another issue has come up migrating from 1.4.2 to 1.5rc1 on Red Hat Enterprise Linux 5.8, PostgreSQL 8.1.23, PHP 5.3.5.
I will attach a pair of snapshots of the upgrade screen.
The relevant lines from the error_log would appear to be these (with the last one truncated for obvious reasons):
[Wed Mar 21 15:35:37 2012] [error] [client 10.0.15.246] [DBG] a0 (lib/ddl.php:486) Function find_index_name called on an index usr_fir_ix with no columns. Attempting match on index names of all indexes on usr without columns., referer: https:/
[Wed Mar 21 15:35:38 2012] [error] [client 10.0.15.246] [DBG] a0 (lib/dml.php:159) postgres7 error: [-1: ERROR: syntax error at or near "," at character 230] in adodb_throw(, referer: https:/
[Wed Mar 21 15:35:38 2012] [error] [client 10.0.15.246] [DBG] a0 (lib/dml.php:159) INSERT INTO "artefact", referer: https:/
[Wed Mar 21 15:35:38 2012] [error] [client 10.0.15.246] [DBG] a0 (lib/dml.php:159) (artefacttype, ctime, mtime, atime, title, description, owner, "group", institution, author, authorname, note), referer: https:/
[Wed Mar 21 15:35:38 2012] [error] [client 10.0.15.246] [DBG] a0 (lib/dml.php:159) VALUES (?,?,?,
Changed in mahara: | |
assignee: | nobody → Richard Mansfield (richard-mansfield) |
Changed in mahara: | |
status: | In Progress → Fix Committed |
Changed in mahara: | |
status: | Fix Committed → Fix Released |
Ouch, Postgres 8.1 doesn't allow more than one row to be inserted using INSERT INTO. I'll have a look for an easy way to rewrite that query, but maybe we can just up the Mahara 1.5 requirement to be pg 8.2+.