Mahara

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

Bug #1737631 reported by Robert Lyon
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Mahara
Fix Released
High
Unassigned
Mahara 18.04.0
17.10
Fix Released
High
Unassigned
Mahara 17.10.1
18.04
Fix Released
High
Unassigned
Mahara 18.04.0

Bug Description

We need to use a table alias for things to work

Revision history for this message
Mahara Bot (dev-mahara) wrote : A patch has been submitted for review

Patch for "master" branch: https://reviews.mahara.org/8339

Revision history for this message
Mahara Bot (dev-mahara) wrote :

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

Revision history for this message
Mahara Bot (dev-mahara) wrote : A change has been merged

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)
Changed in mahara:
status: In Progress → Fix Committed
Revision history for this message
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>

Revision history for this message
Mahara Bot (dev-mahara) wrote : A patch has been submitted for review

Patch for "master" branch: https://reviews.mahara.org/8346

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

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.