Privacy statements in logged out page should show latest version

Bug #1797812 reported by Cecilia Vela Gurovic on 2018-10-14
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Mahara
High
Cecilia Vela Gurovic
18.04
High
Unassigned
18.10
High
Cecilia Vela Gurovic

Bug Description

in logged out page for privacy statement (/legal.php) the latest privacy should be displayed.

Instead we order by version title, that could any string, and show the first result. It can be seen in this query

    SELECT s.content
    FROM site_content_version s
    WHERE s.institution = 'mahara'
    AND s.type = 'privacy'
    ORDER BY s.version DESC
    LIMIT 1;

Changed in mahara:
importance: Undecided → High
assignee: nobody → Cecilia Vela Gurovic (ceciliavg)
status: New → In Progress

Reviewed: https://reviews.mahara.org/9218
Committed: https://git.mahara.org/mahara/mahara/commit/3ccc3e54f6971d51e0107de931f39d538009ac7c
Submitter: Robert Lyon (<email address hidden>)
Branch: master

commit 3ccc3e54f6971d51e0107de931f39d538009ac7c
Author: Cecilia Vela Gurovic <email address hidden>
Date: Mon Oct 15 12:05:59 2018 +1300

Bug 1797812: show latest privacy statement in logged out privacy page

behatnotneeded

Change-Id: I163cb13a77e03fdbdf21c27bace787e104383a2f

Reviewed: https://reviews.mahara.org/9234
Committed: https://git.mahara.org/mahara/mahara/commit/69a964a581c8d259071380e809b15e0ab688a946
Submitter: Robert Lyon (<email address hidden>)
Branch: 18.10_STABLE

commit 69a964a581c8d259071380e809b15e0ab688a946
Author: Cecilia Vela Gurovic <email address hidden>
Date: Mon Oct 15 12:05:59 2018 +1300

Bug 1797812: show latest privacy statement in logged out privacy page

behatnotneeded

Change-Id: I163cb13a77e03fdbdf21c27bace787e104383a2f
(cherry picked from commit 3ccc3e54f6971d51e0107de931f39d538009ac7c)

Robert Lyon (robertl-9) on 2018-10-17
no longer affects: mahara/19.04

Reviewed: https://reviews.mahara.org/9248
Committed: https://git.mahara.org/mahara/mahara/commit/74c9e493733d015f342570a208fa54ebba3f988c
Submitter: Cecilia Vela Gurovic (<email address hidden>)
Branch: 18.04_STABLE

commit 74c9e493733d015f342570a208fa54ebba3f988c
Author: Cecilia Vela Gurovic <email address hidden>
Date: Mon Oct 15 12:05:59 2018 +1300

Bug 1797812: show latest privacy statement in logged out privacy page

behatnotneeded

Change-Id: I163cb13a77e03fdbdf21c27bace787e104383a2f
(cherry picked from commit 3ccc3e54f6971d51e0107de931f39d538009ac7c)
(cherry picked from commit 69a964a581c8d259071380e809b15e0ab688a946)

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

Other bug subscribers