mahara-contributors team mailing list archive

[Cecilia Vela Gurovic <1797812@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

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;

** Affects: mahara
     Importance: High
     Assignee: Cecilia Vela Gurovic (ceciliavg)
         Status: In Progress

** Affects: mahara/18.10
     Importance: High
     Assignee: Cecilia Vela Gurovic (ceciliavg)
         Status: In Progress

** Affects: mahara/19.04
     Importance: Undecided
         Status: New

** Changed in: mahara
   Importance: Undecided => High

** Changed in: mahara
     Assignee: (unassigned) => Cecilia Vela Gurovic (ceciliavg)

** Changed in: mahara
       Status: New => In Progress

** Also affects: mahara/18.10
   Importance: High
     Assignee: Cecilia Vela Gurovic (ceciliavg)
       Status: In Progress

** Also affects: mahara/19.04
   Importance: Undecided
       Status: New

** Changed in: mahara/18.10
    Milestone: None => 18.10.0

** Changed in: mahara/19.04
    Milestone: None => 19.04.0

-- 
You received this bug notification because you are a member of Mahara
Contributors, which is subscribed to Mahara.
Matching subscriptions: Subscription for all Mahara Contributors -- please ask on #mahara-dev or mahara.org forum before editing or unsubscribing it!
https://bugs.launchpad.net/bugs/1797812

Title:
  Privacy statements in logged out page should show latest version

Status in Mahara:
  In Progress
Status in Mahara 18.10 series:
  In Progress
Status in Mahara 19.04 series:
  New

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;

To manage notifications about this bug go to:
https://bugs.launchpad.net/mahara/+bug/1797812/+subscriptions