Mahara

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

Bug #1893291 reported by Robert Lyon
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Mahara
Fix Released
High
Robert Lyon
19.04
Fix Released
High
Unassigned
Mahara 19.04.7
19.10
Fix Released
High
Unassigned
Mahara 19.10.5
20.04
Fix Released
High
Unassigned
Mahara 20.04.2
20.10
Fix Released
High
Robert Lyon
Mahara 20.10.0

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

Revision history for this message
Mahara Bot (dev-mahara) wrote : A patch has been submitted for review

Patch for "18.10_STABLE" branch: https://reviews.mahara.org/11193

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

Patch for "19.04_STABLE" branch: https://reviews.mahara.org/11194

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

Patch for "19.10_STABLE" branch: https://reviews.mahara.org/11195

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

Patch for "20.04_STABLE" branch: https://reviews.mahara.org/11196

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

Patch for "master" branch: https://reviews.mahara.org/11197

Robert Lyon (robertl-9)
Changed in mahara:
status: New → In Progress
Revision history for this message
Mahara Bot (dev-mahara) wrote : A change has been merged

Reviewed: https://reviews.mahara.org/11197
Committed: https://git.mahara.org/mahara/mahara/commit/de34c010d46bd8069ce97141263d78991a5572ab
Submitter: Cecilia Vela Gurovic (<email address hidden>)
Branch: master

commit de34c010d46bd8069ce97141263d78991a5572ab
Author: Robert Lyon <email address hidden>
Date: Fri Aug 28 14:11:11 2020 +1200

Bug 1893291: make sure that we check for correct constraint_name

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

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

Reviewed: https://reviews.mahara.org/11196
Committed: https://git.mahara.org/mahara/mahara/commit/050bae9bb0fb849d84b747ba9dd82539c9f55c6c
Submitter: Cecilia Vela Gurovic (<email address hidden>)
Branch: 20.04_STABLE

commit 050bae9bb0fb849d84b747ba9dd82539c9f55c6c
Author: Robert Lyon <email address hidden>
Date: Fri Aug 28 14:11:11 2020 +1200

Bug 1893291: make sure that we check for correct constraint_name

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

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

Reviewed: https://reviews.mahara.org/11195
Committed: https://git.mahara.org/mahara/mahara/commit/9b81472858ba788f62723f75fbb3bc39735b7eea
Submitter: Cecilia Vela Gurovic (<email address hidden>)
Branch: 19.10_STABLE

commit 9b81472858ba788f62723f75fbb3bc39735b7eea
Author: Robert Lyon <email address hidden>
Date: Fri Aug 28 14:11:11 2020 +1200

Bug 1893291: make sure that we check for correct constraint_name

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

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

Reviewed: https://reviews.mahara.org/11194
Committed: https://git.mahara.org/mahara/mahara/commit/328196d585a2c8b57eb20a299c59119a2a6829b1
Submitter: Cecilia Vela Gurovic (<email address hidden>)
Branch: 19.04_STABLE

commit 328196d585a2c8b57eb20a299c59119a2a6829b1
Author: Robert Lyon <email address hidden>
Date: Fri Aug 28 14:11:11 2020 +1200

Bug 1893291: make sure that we check for correct constraint_name

Change-Id: Ie0b5b721f62d783402570027b7f38c5eb5f225a3
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/11260

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

Patch for "master" branch: https://reviews.mahara.org/11261

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

Reviewed: https://reviews.mahara.org/11261
Committed: https://git.mahara.org/mahara/mahara/commit/7608d2572d45e9446bf659b0edb5b27f85fe6bb3
Submitter: Cecilia Vela Gurovic (<email address hidden>)
Branch: master

commit 7608d2572d45e9446bf659b0edb5b27f85fe6bb3
Author: Robert Lyon <email address hidden>
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 <email address hidden>

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

Reviewed: https://reviews.mahara.org/11260
Committed: https://git.mahara.org/mahara/mahara/commit/75b1acf1ef2fbda0248e2c46ccefb5fa5a11366c
Submitter: Cecilia Vela Gurovic (<email address hidden>)
Branch: master

commit 75b1acf1ef2fbda0248e2c46ccefb5fa5a11366c
Author: Robert Lyon <email address hidden>
Date: Fri Sep 11 13:21:05 2020 +1200

Bug 1893291: Also checking we are dealing with correct column name

Change-Id: I3fdd46bd785ec9fdc785f6f6a1c44986c6fe451c
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 "20.04_STABLE" branch: https://reviews.mahara.org/11291

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

Reviewed: https://reviews.mahara.org/11291
Committed: https://git.mahara.org/mahara/mahara/commit/14c96202fec06629f222669d3e8874e47751d9f0
Submitter: Cecilia Vela Gurovic (<email address hidden>)
Branch: 20.04_STABLE

commit 14c96202fec06629f222669d3e8874e47751d9f0
Author: Robert Lyon <email address hidden>
Date: Fri Sep 11 13:21:05 2020 +1200

Bug 1893291: Also checking we are dealing with correct column name

Change-Id: I3fdd46bd785ec9fdc785f6f6a1c44986c6fe451c
Signed-off-by: Robert Lyon <email address hidden>
(cherry picked from commit 75b1acf1ef2fbda0248e2c46ccefb5fa5a11366c)

Revision history for this message
Mahara Bot (dev-mahara) wrote : A patch has been submitted for review

Patch for "19.10_STABLE" branch: https://reviews.mahara.org/11292

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

Reviewed: https://reviews.mahara.org/11292
Committed: https://git.mahara.org/mahara/mahara/commit/fb9b657266a3b052facafc22353aa27b942bc0e3
Submitter: Cecilia Vela Gurovic (<email address hidden>)
Branch: 19.10_STABLE

commit fb9b657266a3b052facafc22353aa27b942bc0e3
Author: Robert Lyon <email address hidden>
Date: Fri Sep 11 13:21:05 2020 +1200

Bug 1893291: Also checking we are dealing with correct column name

Change-Id: I3fdd46bd785ec9fdc785f6f6a1c44986c6fe451c
Signed-off-by: Robert Lyon <email address hidden>
(cherry picked from commit 75b1acf1ef2fbda0248e2c46ccefb5fa5a11366c)
(cherry picked from commit 14c96202fec06629f222669d3e8874e47751d9f0)

Revision history for this message
Mahara Bot (dev-mahara) wrote : A patch has been submitted for review

Patch for "19.04_STABLE" branch: https://reviews.mahara.org/11293

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

Reviewed: https://reviews.mahara.org/11293
Committed: https://git.mahara.org/mahara/mahara/commit/72ac8eb6d15cf16df34daa51659709d0df1753b3
Submitter: Cecilia Vela Gurovic (<email address hidden>)
Branch: 19.04_STABLE

commit 72ac8eb6d15cf16df34daa51659709d0df1753b3
Author: Robert Lyon <email address hidden>
Date: Fri Sep 11 13:21:05 2020 +1200

Bug 1893291: Also checking we are dealing with correct column name

Change-Id: I3fdd46bd785ec9fdc785f6f6a1c44986c6fe451c
Signed-off-by: Robert Lyon <email address hidden>
(cherry picked from commit 75b1acf1ef2fbda0248e2c46ccefb5fa5a11366c)
(cherry picked from commit 14c96202fec06629f222669d3e8874e47751d9f0)
(cherry picked from commit fb9b657266a3b052facafc22353aa27b942bc0e3)

Revision history for this message
Mahara Bot (dev-mahara) wrote : A patch has been submitted for review

Patch for "20.04_STABLE" branch: https://reviews.mahara.org/11294

Robert Lyon (robertl-9)
Changed in mahara:
milestone: 20.10.0 → none
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

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