mahara-contributors team mailing list archive

[Mahara Bot <1634702@xxxxxxxxxxxxxxxxxx>]

Reviewed:  https://reviews.mahara.org/7181
Committed: https://git.mahara.org/mahara/mahara/commit/66e7c5e4f7688c101b321e93de9c7d4ac876056b
Submitter: Robert Lyon (robertl@xxxxxxxxxxxxxxx)
Branch:    16.10_STABLE

commit 66e7c5e4f7688c101b321e93de9c7d4ac876056b
Author: Robert Lyon <robertl@xxxxxxxxxxxxxxx>
Date:   Wed Oct 19 13:05:13 2016 +1300

Bug 1634702: Need to respect the sql keyword 'key' in MySQL

We need to make it "key" = ?

behatnotneeded

Change-Id: Ib9da4bb82e32cf1ba02079cd7d62236bf2fc3b94
Signed-off-by: Robert Lyon <robertl@xxxxxxxxxxxxxxx>
(cherry picked from commit f70bda97c54d0736cc45b78cd0000bedfd55574f)

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

Title:
  Unable to decline email validation in mysql

Status in Mahara:
  Fix Committed

Bug description:
  Reported by community member

  https://mahara.org/interaction/forum/topic.php?id=7742&offset=0&limit=10#post31146

  In the artefact_internal_profile_email we have a column called 'key'
  which turns out to be a reserved word in MySQL - and there is an sql
  query with WHERE key=? in it.

  We will need to wrap the 'key' in double quotes

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