mahara-contributors team mailing list archive

[Rebecca Blundell <1845228@xxxxxxxxxxxxxxxxxx>]

** Changed in: mahara
       Status: New => Confirmed

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