mahara-contributors team mailing list archive

[Mahara Bot <1893291@xxxxxxxxxxxxxxxxxx>]

Reviewed:  https://reviews.mahara.org/11261
Committed: https://git.mahara.org/mahara/mahara/commit/7608d2572d45e9446bf659b0edb5b27f85fe6bb3
Submitter: Cecilia Vela Gurovic (ceciliavg@xxxxxxxxxxxxxxx)
Branch:    master

commit 7608d2572d45e9446bf659b0edb5b27f85fe6bb3
Author: Robert Lyon <robertl@xxxxxxxxxxxxxxx>
Date:   Fri Sep 11 13:59:46 2020 +1200

Bug 1893291: Adjusting the client_connections_intitution table

Removing the unsigned type so will match other 'id' columns and allow
foreign key connection to work on mysql 8

Change-Id: Iac2d8e0b23ff6d7f0d464b1d0b9217d19ccc7a1c
Signed-off-by: Robert Lyon <robertl@xxxxxxxxxxxxxxx>

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

Title:
  Undefined property: stdClass::$constraint_name error for MySql 8

Status in Mahara:
  Fix Committed
Status in Mahara 19.04 series:
  In Progress
Status in Mahara 19.10 series:
  In Progress
Status in Mahara 20.04 series:
  In Progress
Status in Mahara 20.10 series:
  Fix Committed

Bug description:
  The returned SQL result for checking find_key_name() for
  constraint_name has the column name in uppercase but we try to use it
  as $c->constraint_name (in lowercase)

  We need to check if property $c->CONSTRAINT_NAME exists and use that
  otherwise use $c->constraint_name

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