Problem with upgrading to 15.04 - postgres and upgrade/limit

Bug #1483084 reported by Robert Lyon
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Mahara
Fix Released
High
Robert Lyon
1.10
Fix Released
High
Unassigned
15.04
Fix Released
High
Unassigned
15.10
Fix Released
Undecided
Unassigned

Bug Description

Postgres can only do an upgrade / limit via subquery and Mysql can only do it without subquery

so we need to have seperate sql commands for both

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/5073

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

Reviewed: https://reviews.mahara.org/5073
Committed: https://git.nzoss.org.nz/mahara/mahara/commit/22842bdfbaad207388c1a00130c53d6d0c356bbe
Submitter: Son Nguyen (<email address hidden>)
Branch: master

commit 22842bdfbaad207388c1a00130c53d6d0c356bbe
Author: Robert Lyon <email address hidden>
Date: Mon Aug 10 13:19:04 2015 +1200

Bug 1483084: Upgrade problem with assigning artefact path

Postgres works slightly differently to mysql with the
update .. limit command

behatnotneeded: as this is an upgrde problem

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

Changed in mahara:
status: In Progress → Fix Committed
Changed in mahara:
milestone: none → 15.10.0
Revision history for this message
Mahara Bot (dev-mahara) wrote : A patch has been submitted for review

Patch for "15.04_STABLE" branch: https://reviews.mahara.org/5099

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

Patch for "1.10_STABLE" branch: https://reviews.mahara.org/5101

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

Reviewed: https://reviews.mahara.org/5101
Committed: https://git.nzoss.org.nz/mahara/mahara/commit/242b84a23fc5c83178c43ed20147739d19728957
Submitter: Robert Lyon (<email address hidden>)
Branch: 1.10_STABLE

commit 242b84a23fc5c83178c43ed20147739d19728957
Author: Robert Lyon <email address hidden>
Date: Mon Aug 10 13:19:04 2015 +1200

Bug 1483084: Upgrade problem with assigning artefact path

Postgres works slightly differently to mysql with the
update .. limit command

behatnotneeded: as this is an upgrde problem

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

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

Reviewed: https://reviews.mahara.org/5099
Committed: https://git.nzoss.org.nz/mahara/mahara/commit/1426aea6fcb2d1a39a2fbaf832e9bbef1c3ed89b
Submitter: Robert Lyon (<email address hidden>)
Branch: 15.04_STABLE

commit 1426aea6fcb2d1a39a2fbaf832e9bbef1c3ed89b
Author: Robert Lyon <email address hidden>
Date: Mon Aug 10 13:19:04 2015 +1200

Bug 1483084: Upgrade problem with assigning artefact path

Postgres works slightly differently to mysql with the
update .. limit command

behatnotneeded: as this is an upgrde problem

Change-Id: I6ae18e545d9e3ba56ca3a258b02038b3759ea178
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/5140

Robert Lyon (robertl-9)
Changed in mahara:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

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