Mahara installation issues with MySQL 8.0.17
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Mahara |
Fix Released
|
High
|
Rebecca Blundell |
Bug Description
Hi,
The latest version of Mahara (19.04.1) throws the following error when running the install.php script
```
[INF] fe (admin/
[INF] fe (lib/mahara.
[DBG] fe (lib/dml.php:157) mysqli error: [1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'member BIGINT(10) NOT NULL,
[DBG] fe (lib/dml.php:157) role VARCHAR(255) NOT NULL,
[DBG] fe (lib/dml.php:157) ctime DATETIME N' at line 3] in EXECUTE("CREATE TABLE group_member (
[DBG] fe (lib/dml.php:157) `group` BIGINT(10) NOT NULL,
[DBG] fe (lib/dml.php:157) member BIGINT(10) NOT NULL,
[DBG] fe (lib/dml.php:157) role VARCHAR(255) NOT NULL,
[DBG] fe (lib/dml.php:157) ctime DATETIME NOT NULL,
[DBG] fe (lib/dml.php:157) method VARCHAR(100) NOT NULL DEFAULT 'internal',
```
The command we run during the installation process is the following one:
```
php "/mahara_
```
We are using the latest version of MySQL (8.0.17) as database and "member" is a reserved word from that version on.
https:/
Regarding the OS, we detected this problem in Linux and Windows (OS X is probably affected as well).
Let me know if you need more information and if you have a workaround to install the application with this version of the database.
Thanks,
Jota
Changed in mahara: | |
status: | New → Confirmed |
Changed in mahara: | |
assignee: | nobody → Rebecca Blundell (rjb-dev) |
Changed in mahara: | |
milestone: | none → 20.04.0 |
Changed in mahara: | |
status: | Confirmed → In Progress |
Changed in mahara: | |
status: | In Progress → Fix Committed |
Changed in mahara: | |
status: | Fix Committed → Fix Released |
Tested on Ubuntu 16.04 with PHP7.1 and Mahara 19.04.2testing
This is an issue as of mysql 8.0.17, as pointed out above. It runs fine in previous versions of mysql.
From: /dev.mysql. com/doc/ relnotes/ mysql/8. 0/en/news- 8-0-17. html
https:/
ARRAY and MEMBER now are reserved words and cannot be used as identifiers without identifier quoting.
This is a big problem as it prevents Mahara from installing under mysql.