mahara-contributors team mailing list archive
-
mahara-contributors team
-
Mailing list archive
-
Message #63475
[Bug 1946616] [NEW] MySQL8 syntax error - reserved word 'lock'
Public bug reported:
Release testing 21.10:
master
MySQL 8
Firefox
Maroon theme
PHP 7.4
To test:
1. Create an institution template collection (set to 'Current auto-copied template') with portfolio completion.
2. Add 1 review block, type a review statement and set 'Lock portfolio' to 'Yes'.
3. Create a new account and run the cron so that the portfolio is created.
4. Share the portfolio with a person who can do a review.
5. Log in as the reviewer and approve the review statement.
Expected: box should be able to be checked and portfolio locked
Actual: Does not allow you to check the box. On page reload, sql syntax
error appears.
On investigation, the problem was found to be the name of the column in
the collection table 'lock' - this is a reserved word in MySQL8. When I
changed the column name to 'locked' this fixed the problem.
** Affects: mahara
Importance: Undecided
Status: New
--
You received this bug notification because you are a member of Mahara
Contributors, which is subscribed to Mahara.
Matching subscriptions: mahara-contributors
https://bugs.launchpad.net/bugs/1946616
Title:
MySQL8 syntax error - reserved word 'lock'
Status in Mahara:
New
Bug description:
Release testing 21.10:
master
MySQL 8
Firefox
Maroon theme
PHP 7.4
To test:
1. Create an institution template collection (set to 'Current auto-copied template') with portfolio completion.
2. Add 1 review block, type a review statement and set 'Lock portfolio' to 'Yes'.
3. Create a new account and run the cron so that the portfolio is created.
4. Share the portfolio with a person who can do a review.
5. Log in as the reviewer and approve the review statement.
Expected: box should be able to be checked and portfolio locked
Actual: Does not allow you to check the box. On page reload, sql
syntax error appears.
On investigation, the problem was found to be the name of the column
in the collection table 'lock' - this is a reserved word in MySQL8.
When I changed the column name to 'locked' this fixed the problem.
To manage notifications about this bug go to:
https://bugs.launchpad.net/mahara/+bug/1946616/+subscriptions
Follow ups
-
[Bug 1946616] Re: MySQL8 syntax error - reserved word 'lock'
From: Robert Lyon, 2021-10-28
-
[Bug 1946616] Re: MySQL8 syntax error - reserved word 'lock'
From: Robert Lyon, 2021-10-20
-
[Bug 1946616] A patch has been submitted for review
From: Mahara Bot, 2021-10-20
-
[Bug 1946616] Re: MySQL8 syntax error - reserved word 'lock'
From: Doris Tam, 2021-10-15
-
[Bug 1946616] Re: MySQL8 syntax error - reserved word 'lock'
From: Robert Lyon, 2021-10-15
-
[Bug 1946616] A patch has been submitted for review
From: Mahara Bot, 2021-10-14
-
[Bug 1946616] A patch has been submitted for review
From: Mahara Bot, 2021-10-13
-
[Bug 1946616] Re: MySQL8 syntax error - reserved word 'lock'
From: Dianne Tennent, 2021-10-12
-
[Bug 1946616] Re: MySQL8 syntax error - reserved word 'lock'
From: Kristina Hoeppner, 2021-10-12
-
[Bug 1946616] Re: MySQL8 syntax error - reserved word 'lock'
From: Dianne Tennent, 2021-10-11