Fail to upgrade to 17.10 when db prefix being used in postgres

Bug #1737631 reported by Robert Lyon on 2017-12-11
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Mahara
High
Unassigned
17.10
High
Unassigned
18.04
High
Unassigned

Bug Description

We need to use a table alias for things to work

Mahara Bot (dev-mahara) wrote :

Patch for "17.10_STABLE" branch: https://reviews.mahara.org/8340

Reviewed: https://reviews.mahara.org/8339
Committed: https://git.mahara.org/mahara/mahara/commit/88e8a6c8874f2d2dffb8a8bf3c79dcac774df6a7
Submitter: Robert Lyon (<email address hidden>)
Branch: master

commit 88e8a6c8874f2d2dffb8a8bf3c79dcac774df6a7
Author: Robert Lyon <email address hidden>
Date: Tue Dec 12 11:34:22 2017 +1300

Bug 1737631: Upgrade to 17.10 fails in postgres

Due to not using an alias for the view table

The code is correct for MySql though

behatnotneeded

Change-Id: I5622bde057c70cf7d140044ac213bf3f299abefc
Signed-off-by: Robert Lyon <email address hidden>

Robert Lyon (robertl-9) on 2017-12-12
Changed in mahara:
status: In Progress → Fix Committed
Mahara Bot (dev-mahara) wrote :

Reviewed: https://reviews.mahara.org/8340
Committed: https://git.mahara.org/mahara/mahara/commit/3814a1962117a888a14afc0a8c6e9ab4ddb219b6
Submitter: Robert Lyon (<email address hidden>)
Branch: 17.10_STABLE

commit 3814a1962117a888a14afc0a8c6e9ab4ddb219b6
Author: Robert Lyon <email address hidden>
Date: Tue Dec 12 11:34:22 2017 +1300

Bug 1737631: Upgrade to 17.10 fails in postgres

Due to not using an alias for the view table

The code is correct for MySql though

behatnotneeded

Change-Id: I5622bde057c70cf7d140044ac213bf3f299abefc
Signed-off-by: Robert Lyon <email address hidden>

To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers