← Back to team overview

mahara-contributors team mailing list archive

[Bug 1845228] Re: Mahara installation issues with MySQL 8.0.17

 

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:
https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-17.html

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.


** Changed in: mahara
   Importance: Undecided => High

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

Title:
  Mahara installation issues with MySQL 8.0.17

Status in Mahara:
  Confirmed

Bug description:
  Hi,

  The latest version of Mahara (19.04.1) throws the following error when
  running the install.php script

  ```
  [INF] fe (admin/cli/install.php:74) Installing Mahara
  [INF] fe (lib/mahara.php:237) Installing core
  [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_folder/admin/cli/install.php" --adminpassword=PASSWORD --adminemail=EMAIL
  ```

  We are using the latest version of MySQL (8.0.17) as database and
  "member" is a reserved word from that version on.

  https://dev.mysql.com/doc/refman/8.0/en/keywords.html

  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

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


References