mahara-contributors team mailing list archive

[Jota Martos <1845228@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

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

** 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: 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:
  New

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