[Mahara-contributors] [Bug 1706263] Re: Mahara17.04.2 fails to install when deployed against MariaDB v10.2.4 or higher

2017-10-30 Thread Robert Lyon 
** Changed in: mahara/17.04
   Status: Fix Committed => Fix Released

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

Title:
  Mahara17.04.2 fails to install when deployed against MariaDB v10.2.4
  or higher

Status in Mahara:
  Fix Released
Status in Mahara 17.04 series:
  Fix Released
Status in Mahara 17.10 series:
  Fix Released

Bug description:
  During the installation process the installation is halted due to an
  error. As a result further deploy+ent of the Mahara server is not
  possible.

  Used configuration Ubuntu 16.4LTS, Moodle 3.3.1, Mahara 17.04.2,
  MariaDB 10.2.6

  Consulting the apache error log files gives back following information

  [Mon Jul 24 10:06:57.616387 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [INF] 2a (admin/upgrade.php:49) Starting Mahara 
installation..., referer: http://mahara.syntra-cloud.be/admin/index.php
  [Mon Jul 24 10:07:11.571057 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) mysqli error: [1064: You have an 
error in your SQL syntax; check the manual that corresponds to your MariaDB 
server version for the right syntax to use near 'rows BIGINT(10) NOT NULL 
DEFAULT 1,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571082 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) iscustom TINYINT(1) NOT NULL 
DEFAULT 0,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571094 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) ' at line 3] in EXECUTE("CREATE 
TABLE view_layout (, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571096 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) id BIGINT(10) NOT NULL 
auto_increment,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571097 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) rows BIGINT(10) NOT NULL 
DEFAULT 1,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571099 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) iscustom TINYINT(1) NOT NULL 
DEFAULT 0,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571101 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) layoutmenuorder BIGINT(10) 
NOT NULL DEFAULT 0,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571102 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) CONSTRAINT  PRIMARY KEY (id), 
referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571104 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) )ENGINE=innodb")Command was: 
CREATE TABLE view_layout (, referer: 
http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571106 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) id BIGINT(10) NOT NULL 
auto_increment,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571108 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) rows BIGINT(10) NOT NULL 
DEFAULT 1,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571109 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) iscustom TINYINT(1) NOT NULL 
DEFAULT 0,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.57 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) layoutmenuorder BIGINT(10) 
NOT NULL DEFAULT 0,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571112 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) CONSTRAINT  PRIMARY KEY (id), 
referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  Looking into file htdocs/lib/db/install.xml (line726) – table view_layout

  A Quick analysis of the problem indicated the following
  The column rows in the table view_layout is causing a problem (as of MariaDB 
10.2.4 rows is now a reserved keyword 
(https://mariadb.com/kb/en/mariadb/reserved-words/)

  
  
  
  
  
  
  
  
  
  
  

  To hotfix the issue I´ve updated the column rows to numrows in the
  following files after which the installation continues as expected and
  Mahara functioned properly.

  htdocs/lib/db/install.xml

[Mahara-contributors] [Bug 1706263] Re: Mahara17.04.2 fails to install when deployed against MariaDB v10.2.4 or higher

2017-10-29 Thread Robert Lyon 
** Changed in: mahara/17.10
   Status: Fix Committed => Fix Released

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

Title:
  Mahara17.04.2 fails to install when deployed against MariaDB v10.2.4
  or higher

Status in Mahara:
  Fix Released
Status in Mahara 17.04 series:
  Fix Committed
Status in Mahara 17.10 series:
  Fix Released

Bug description:
  During the installation process the installation is halted due to an
  error. As a result further deploy+ent of the Mahara server is not
  possible.

  Used configuration Ubuntu 16.4LTS, Moodle 3.3.1, Mahara 17.04.2,
  MariaDB 10.2.6

  Consulting the apache error log files gives back following information

  [Mon Jul 24 10:06:57.616387 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [INF] 2a (admin/upgrade.php:49) Starting Mahara 
installation..., referer: http://mahara.syntra-cloud.be/admin/index.php
  [Mon Jul 24 10:07:11.571057 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) mysqli error: [1064: You have an 
error in your SQL syntax; check the manual that corresponds to your MariaDB 
server version for the right syntax to use near 'rows BIGINT(10) NOT NULL 
DEFAULT 1,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571082 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) iscustom TINYINT(1) NOT NULL 
DEFAULT 0,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571094 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) ' at line 3] in EXECUTE("CREATE 
TABLE view_layout (, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571096 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) id BIGINT(10) NOT NULL 
auto_increment,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571097 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) rows BIGINT(10) NOT NULL 
DEFAULT 1,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571099 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) iscustom TINYINT(1) NOT NULL 
DEFAULT 0,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571101 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) layoutmenuorder BIGINT(10) 
NOT NULL DEFAULT 0,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571102 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) CONSTRAINT  PRIMARY KEY (id), 
referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571104 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) )ENGINE=innodb")Command was: 
CREATE TABLE view_layout (, referer: 
http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571106 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) id BIGINT(10) NOT NULL 
auto_increment,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571108 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) rows BIGINT(10) NOT NULL 
DEFAULT 1,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571109 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) iscustom TINYINT(1) NOT NULL 
DEFAULT 0,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.57 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) layoutmenuorder BIGINT(10) 
NOT NULL DEFAULT 0,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571112 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) CONSTRAINT  PRIMARY KEY (id), 
referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  Looking into file htdocs/lib/db/install.xml (line726) – table view_layout

  A Quick analysis of the problem indicated the following
  The column rows in the table view_layout is causing a problem (as of MariaDB 
10.2.4 rows is now a reserved keyword 
(https://mariadb.com/kb/en/mariadb/reserved-words/)

  
  
  
  
  
  
  
  
  
  
  

  To hotfix the issue I´ve updated the column rows to numrows in the
  following files after which the installation continues as expected and
  Mahara functioned properly.

  htdocs/lib/db/install.xml

[Mahara-contributors] [Bug 1706263] Re: Mahara17.04.2 fails to install when deployed against MariaDB v10.2.4 or higher

2017-09-17 Thread Robert Lyon 
** Changed in: mahara/17.04
   Status: In Progress => Fix Committed

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

Title:
  Mahara17.04.2 fails to install when deployed against MariaDB v10.2.4
  or higher

Status in Mahara:
  Fix Committed
Status in Mahara 17.04 series:
  Fix Committed
Status in Mahara 17.10 series:
  Fix Committed

Bug description:
  During the installation process the installation is halted due to an
  error. As a result further deploy+ent of the Mahara server is not
  possible.

  Used configuration Ubuntu 16.4LTS, Moodle 3.3.1, Mahara 17.04.2,
  MariaDB 10.2.6

  Consulting the apache error log files gives back following information

  [Mon Jul 24 10:06:57.616387 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [INF] 2a (admin/upgrade.php:49) Starting Mahara 
installation..., referer: http://mahara.syntra-cloud.be/admin/index.php
  [Mon Jul 24 10:07:11.571057 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) mysqli error: [1064: You have an 
error in your SQL syntax; check the manual that corresponds to your MariaDB 
server version for the right syntax to use near 'rows BIGINT(10) NOT NULL 
DEFAULT 1,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571082 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) iscustom TINYINT(1) NOT NULL 
DEFAULT 0,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571094 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) ' at line 3] in EXECUTE("CREATE 
TABLE view_layout (, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571096 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) id BIGINT(10) NOT NULL 
auto_increment,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571097 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) rows BIGINT(10) NOT NULL 
DEFAULT 1,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571099 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) iscustom TINYINT(1) NOT NULL 
DEFAULT 0,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571101 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) layoutmenuorder BIGINT(10) 
NOT NULL DEFAULT 0,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571102 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) CONSTRAINT  PRIMARY KEY (id), 
referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571104 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) )ENGINE=innodb")Command was: 
CREATE TABLE view_layout (, referer: 
http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571106 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) id BIGINT(10) NOT NULL 
auto_increment,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571108 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) rows BIGINT(10) NOT NULL 
DEFAULT 1,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571109 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) iscustom TINYINT(1) NOT NULL 
DEFAULT 0,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.57 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) layoutmenuorder BIGINT(10) 
NOT NULL DEFAULT 0,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571112 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) CONSTRAINT  PRIMARY KEY (id), 
referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  Looking into file htdocs/lib/db/install.xml (line726) – table view_layout

  A Quick analysis of the problem indicated the following
  The column rows in the table view_layout is causing a problem (as of MariaDB 
10.2.4 rows is now a reserved keyword 
(https://mariadb.com/kb/en/mariadb/reserved-words/)

  
  
  
  
  
  
  
  
  
  
  

  To hotfix the issue I´ve updated the column rows to numrows in the
  following files after which the installation continues as expected and
  Mahara functioned properly.

  htdocs/lib/db/install.xml

[Mahara-contributors] [Bug 1706263] Re: Mahara17.04.2 fails to install when deployed against MariaDB v10.2.4 or higher

2017-09-17 Thread Robert Lyon 
** Changed in: mahara/17.10
   Status: In Progress => Fix Committed

** Changed in: mahara/17.04
   Status: Confirmed => In Progress

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

Title:
  Mahara17.04.2 fails to install when deployed against MariaDB v10.2.4
  or higher

Status in Mahara:
  Fix Committed
Status in Mahara 17.04 series:
  In Progress
Status in Mahara 17.10 series:
  Fix Committed

Bug description:
  During the installation process the installation is halted due to an
  error. As a result further deploy+ent of the Mahara server is not
  possible.

  Used configuration Ubuntu 16.4LTS, Moodle 3.3.1, Mahara 17.04.2,
  MariaDB 10.2.6

  Consulting the apache error log files gives back following information

  [Mon Jul 24 10:06:57.616387 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [INF] 2a (admin/upgrade.php:49) Starting Mahara 
installation..., referer: http://mahara.syntra-cloud.be/admin/index.php
  [Mon Jul 24 10:07:11.571057 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) mysqli error: [1064: You have an 
error in your SQL syntax; check the manual that corresponds to your MariaDB 
server version for the right syntax to use near 'rows BIGINT(10) NOT NULL 
DEFAULT 1,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571082 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) iscustom TINYINT(1) NOT NULL 
DEFAULT 0,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571094 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) ' at line 3] in EXECUTE("CREATE 
TABLE view_layout (, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571096 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) id BIGINT(10) NOT NULL 
auto_increment,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571097 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) rows BIGINT(10) NOT NULL 
DEFAULT 1,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571099 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) iscustom TINYINT(1) NOT NULL 
DEFAULT 0,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571101 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) layoutmenuorder BIGINT(10) 
NOT NULL DEFAULT 0,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571102 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) CONSTRAINT  PRIMARY KEY (id), 
referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571104 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) )ENGINE=innodb")Command was: 
CREATE TABLE view_layout (, referer: 
http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571106 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) id BIGINT(10) NOT NULL 
auto_increment,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571108 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) rows BIGINT(10) NOT NULL 
DEFAULT 1,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571109 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) iscustom TINYINT(1) NOT NULL 
DEFAULT 0,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.57 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) layoutmenuorder BIGINT(10) 
NOT NULL DEFAULT 0,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571112 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) CONSTRAINT  PRIMARY KEY (id), 
referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  Looking into file htdocs/lib/db/install.xml (line726) – table view_layout

  A Quick analysis of the problem indicated the following
  The column rows in the table view_layout is causing a problem (as of MariaDB 
10.2.4 rows is now a reserved keyword 
(https://mariadb.com/kb/en/mariadb/reserved-words/)

  
  
  
  
  
  
  
  
  
  
  

  To hotfix the issue I´ve updated the column rows to numrows in the
  following files after which the installation continues as

[Mahara-contributors] [Bug 1706263] Re: Mahara17.04.2 fails to install when deployed against MariaDB v10.2.4 or higher

2017-09-07 Thread Robert Lyon 
** Changed in: mahara/17.04
Milestone: 17.04.3 => 17.04.4

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

Title:
  Mahara17.04.2 fails to install when deployed against MariaDB v10.2.4
  or higher

Status in Mahara:
  In Progress
Status in Mahara 17.04 series:
  Confirmed
Status in Mahara 17.10 series:
  In Progress

Bug description:
  During the installation process the installation is halted due to an
  error. As a result further deploy+ent of the Mahara server is not
  possible.

  Used configuration Ubuntu 16.4LTS, Moodle 3.3.1, Mahara 17.04.2,
  MariaDB 10.2.6

  Consulting the apache error log files gives back following information

  [Mon Jul 24 10:06:57.616387 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [INF] 2a (admin/upgrade.php:49) Starting Mahara 
installation..., referer: http://mahara.syntra-cloud.be/admin/index.php
  [Mon Jul 24 10:07:11.571057 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) mysqli error: [1064: You have an 
error in your SQL syntax; check the manual that corresponds to your MariaDB 
server version for the right syntax to use near 'rows BIGINT(10) NOT NULL 
DEFAULT 1,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571082 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) iscustom TINYINT(1) NOT NULL 
DEFAULT 0,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571094 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) ' at line 3] in EXECUTE("CREATE 
TABLE view_layout (, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571096 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) id BIGINT(10) NOT NULL 
auto_increment,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571097 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) rows BIGINT(10) NOT NULL 
DEFAULT 1,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571099 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) iscustom TINYINT(1) NOT NULL 
DEFAULT 0,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571101 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) layoutmenuorder BIGINT(10) 
NOT NULL DEFAULT 0,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571102 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) CONSTRAINT  PRIMARY KEY (id), 
referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571104 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) )ENGINE=innodb")Command was: 
CREATE TABLE view_layout (, referer: 
http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571106 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) id BIGINT(10) NOT NULL 
auto_increment,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571108 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) rows BIGINT(10) NOT NULL 
DEFAULT 1,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571109 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) iscustom TINYINT(1) NOT NULL 
DEFAULT 0,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.57 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) layoutmenuorder BIGINT(10) 
NOT NULL DEFAULT 0,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571112 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) CONSTRAINT  PRIMARY KEY (id), 
referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  Looking into file htdocs/lib/db/install.xml (line726) – table view_layout

  A Quick analysis of the problem indicated the following
  The column rows in the table view_layout is causing a problem (as of MariaDB 
10.2.4 rows is now a reserved keyword 
(https://mariadb.com/kb/en/mariadb/reserved-words/)

  
  
  
  
  
  
  
  
  
  
  

  To hotfix the issue I´ve updated the column rows to numrows in the
  following files after which the installation continues as expected and
  Mahara functioned properly.

  htdocs/lib/db/install.xml (line726) rename

[Mahara-contributors] [Bug 1706263] Re: Mahara17.04.2 fails to install when deployed against MariaDB v10.2.4 or higher

2017-08-21 Thread Cecilia Vela Gurovic 
Hi Raoul,

We made this patch for this issue https://reviews.mahara.org/#/c/7912
expanding on what you have provided, can you please give it a go?

Thank you,
Cecilia

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

** Changed in: mahara
Milestone: None => 17.10.0

** Also affects: mahara/17.04
   Importance: Undecided
   Status: New

** Also affects: mahara/17.10
   Importance: High
 Assignee: Cecilia Vela Gurovic (ceciliavg)
   Status: In Progress

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

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

** Changed in: mahara/17.04
 Assignee: (unassigned) => Cecilia Vela Gurovic (ceciliavg)

** Changed in: mahara/17.04
Milestone: None => 17.04.3

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

Title:
  Mahara17.04.2 fails to install when deployed against MariaDB v10.2.4
  or higher

Status in Mahara:
  In Progress
Status in Mahara 17.04 series:
  Confirmed
Status in Mahara 17.10 series:
  In Progress

Bug description:
  During the installation process the installation is halted due to an
  error. As a result further deploy+ent of the Mahara server is not
  possible.

  Used configuration Ubuntu 16.4LTS, Moodle 3.3.1, Mahara 17.04.2,
  MariaDB 10.2.6

  Consulting the apache error log files gives back following information

  [Mon Jul 24 10:06:57.616387 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [INF] 2a (admin/upgrade.php:49) Starting Mahara 
installation..., referer: http://mahara.syntra-cloud.be/admin/index.php
  [Mon Jul 24 10:07:11.571057 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) mysqli error: [1064: You have an 
error in your SQL syntax; check the manual that corresponds to your MariaDB 
server version for the right syntax to use near 'rows BIGINT(10) NOT NULL 
DEFAULT 1,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571082 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) iscustom TINYINT(1) NOT NULL 
DEFAULT 0,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571094 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) ' at line 3] in EXECUTE("CREATE 
TABLE view_layout (, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571096 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) id BIGINT(10) NOT NULL 
auto_increment,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571097 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) rows BIGINT(10) NOT NULL 
DEFAULT 1,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571099 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) iscustom TINYINT(1) NOT NULL 
DEFAULT 0,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571101 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) layoutmenuorder BIGINT(10) 
NOT NULL DEFAULT 0,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571102 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) CONSTRAINT  PRIMARY KEY (id), 
referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571104 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) )ENGINE=innodb")Command was: 
CREATE TABLE view_layout (, referer: 
http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571106 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) id BIGINT(10) NOT NULL 
auto_increment,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571108 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) rows BIGINT(10) NOT NULL 
DEFAULT 1,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571109 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) iscustom TINYINT(1) NOT NULL 
DEFAULT 0,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.57 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) layoutmenuorder BIGINT(10) 
NOT NULL DEFAULT 0,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571112 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) CONSTRAINT  PRIMARY KEY (id), 
referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  Looking into

[Mahara-contributors] [Bug 1706263] Re: Mahara17.04.2 fails to install when deployed against MariaDB v10.2.4 or higher

2017-08-21 Thread Cecilia Vela Gurovic 
** Changed in: mahara
   Status: New => In Progress

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

Title:
  Mahara17.04.2 fails to install when deployed against MariaDB v10.2.4
  or higher

Status in Mahara:
  In Progress

Bug description:
  During the installation process the installation is halted due to an
  error. As a result further deploy+ent of the Mahara server is not
  possible.

  Used configuration Ubuntu 16.4LTS, Moodle 3.3.1, Mahara 17.04.2,
  MariaDB 10.2.6

  Consulting the apache error log files gives back following information

  [Mon Jul 24 10:06:57.616387 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [INF] 2a (admin/upgrade.php:49) Starting Mahara 
installation..., referer: http://mahara.syntra-cloud.be/admin/index.php
  [Mon Jul 24 10:07:11.571057 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) mysqli error: [1064: You have an 
error in your SQL syntax; check the manual that corresponds to your MariaDB 
server version for the right syntax to use near 'rows BIGINT(10) NOT NULL 
DEFAULT 1,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571082 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) iscustom TINYINT(1) NOT NULL 
DEFAULT 0,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571094 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) ' at line 3] in EXECUTE("CREATE 
TABLE view_layout (, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571096 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) id BIGINT(10) NOT NULL 
auto_increment,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571097 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) rows BIGINT(10) NOT NULL 
DEFAULT 1,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571099 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) iscustom TINYINT(1) NOT NULL 
DEFAULT 0,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571101 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) layoutmenuorder BIGINT(10) 
NOT NULL DEFAULT 0,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571102 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) CONSTRAINT  PRIMARY KEY (id), 
referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571104 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) )ENGINE=innodb")Command was: 
CREATE TABLE view_layout (, referer: 
http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571106 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) id BIGINT(10) NOT NULL 
auto_increment,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571108 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) rows BIGINT(10) NOT NULL 
DEFAULT 1,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571109 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) iscustom TINYINT(1) NOT NULL 
DEFAULT 0,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.57 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) layoutmenuorder BIGINT(10) 
NOT NULL DEFAULT 0,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571112 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) CONSTRAINT  PRIMARY KEY (id), 
referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  Looking into file htdocs/lib/db/install.xml (line726) – table view_layout

  A Quick analysis of the problem indicated the following
  The column rows in the table view_layout is causing a problem (as of MariaDB 
10.2.4 rows is now a reserved keyword 
(https://mariadb.com/kb/en/mariadb/reserved-words/)

  
  
  
  
  
  
  
  
  
  
  

  To hotfix the issue I´ve updated the column rows to numrows in the
  following files after which the installation continues as expected and
  Mahara functioned properly.

  htdocs/lib/db/install.xml (line726) rename ´rows´ column to ´numrows´
  htdocs/lib/db/upgrade.php (line2407) rename ´rows´ column to

[Mahara-contributors] [Bug 1706263] Re: Mahara17.04.2 fails to install when deployed against MariaDB v10.2.4 or higher

2017-08-02 Thread Cecilia Vela Gurovic 
I updated the patch to include latest new keywords for versions

PostgresSQL 10
MySQL 8.0.3
MariaDB 10.2.7

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

Title:
  Mahara17.04.2 fails to install when deployed against MariaDB v10.2.4
  or higher

Status in Mahara:
  New

Bug description:
  During the installation process the installation is halted due to an
  error. As a result further deploy+ent of the Mahara server is not
  possible.

  Used configuration Ubuntu 16.4LTS, Moodle 3.3.1, Mahara 17.04.2,
  MariaDB 10.2.6

  Consulting the apache error log files gives back following information

  [Mon Jul 24 10:06:57.616387 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [INF] 2a (admin/upgrade.php:49) Starting Mahara 
installation..., referer: http://mahara.syntra-cloud.be/admin/index.php
  [Mon Jul 24 10:07:11.571057 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) mysqli error: [1064: You have an 
error in your SQL syntax; check the manual that corresponds to your MariaDB 
server version for the right syntax to use near 'rows BIGINT(10) NOT NULL 
DEFAULT 1,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571082 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) iscustom TINYINT(1) NOT NULL 
DEFAULT 0,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571094 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) ' at line 3] in EXECUTE("CREATE 
TABLE view_layout (, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571096 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) id BIGINT(10) NOT NULL 
auto_increment,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571097 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) rows BIGINT(10) NOT NULL 
DEFAULT 1,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571099 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) iscustom TINYINT(1) NOT NULL 
DEFAULT 0,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571101 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) layoutmenuorder BIGINT(10) 
NOT NULL DEFAULT 0,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571102 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) CONSTRAINT  PRIMARY KEY (id), 
referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571104 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) )ENGINE=innodb")Command was: 
CREATE TABLE view_layout (, referer: 
http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571106 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) id BIGINT(10) NOT NULL 
auto_increment,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571108 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) rows BIGINT(10) NOT NULL 
DEFAULT 1,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571109 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) iscustom TINYINT(1) NOT NULL 
DEFAULT 0,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.57 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) layoutmenuorder BIGINT(10) 
NOT NULL DEFAULT 0,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571112 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) CONSTRAINT  PRIMARY KEY (id), 
referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  Looking into file htdocs/lib/db/install.xml (line726) – table view_layout

  A Quick analysis of the problem indicated the following
  The column rows in the table view_layout is causing a problem (as of MariaDB 
10.2.4 rows is now a reserved keyword 
(https://mariadb.com/kb/en/mariadb/reserved-words/)

  
  
  
  
  
  
  
  
  
  
  

  To hotfix the issue I´ve updated the column rows to numrows in the
  following files after which the installation continues as expected and
  Mahara functioned properly.

  htdocs/lib/db/install.xml (line726) rename ´rows´ column to ´numrows´

[Mahara-contributors] [Bug 1706263] Re: Mahara17.04.2 fails to install when deployed against MariaDB v10.2.4 or higher

2017-08-01 Thread Cecilia Vela Gurovic 
>From https://mariadb.com: 
reserved words ROWS Added in MariaDB 10.2.4 (Release date: 17 Feb 2017)

The patch is ok but it needs to consider upgrades. if an instance of
mahara is using MariaDB and they upgrade it to 10.2.4 or higher then
there will be issues. We need to change the name of the column for all
versions of Mahara for new installs and for already existing DBs.

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

Title:
  Mahara17.04.2 fails to install when deployed against MariaDB v10.2.4
  or higher

Status in Mahara:
  New

Bug description:
  During the installation process the installation is halted due to an
  error. As a result further deploy+ent of the Mahara server is not
  possible.

  Used configuration Ubuntu 16.4LTS, Moodle 3.3.1, Mahara 17.04.2,
  MariaDB 10.2.6

  Consulting the apache error log files gives back following information

  [Mon Jul 24 10:06:57.616387 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [INF] 2a (admin/upgrade.php:49) Starting Mahara 
installation..., referer: http://mahara.syntra-cloud.be/admin/index.php
  [Mon Jul 24 10:07:11.571057 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) mysqli error: [1064: You have an 
error in your SQL syntax; check the manual that corresponds to your MariaDB 
server version for the right syntax to use near 'rows BIGINT(10) NOT NULL 
DEFAULT 1,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571082 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) iscustom TINYINT(1) NOT NULL 
DEFAULT 0,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571094 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) ' at line 3] in EXECUTE("CREATE 
TABLE view_layout (, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571096 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) id BIGINT(10) NOT NULL 
auto_increment,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571097 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) rows BIGINT(10) NOT NULL 
DEFAULT 1,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571099 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) iscustom TINYINT(1) NOT NULL 
DEFAULT 0,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571101 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) layoutmenuorder BIGINT(10) 
NOT NULL DEFAULT 0,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571102 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) CONSTRAINT  PRIMARY KEY (id), 
referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571104 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) )ENGINE=innodb")Command was: 
CREATE TABLE view_layout (, referer: 
http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571106 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) id BIGINT(10) NOT NULL 
auto_increment,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571108 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) rows BIGINT(10) NOT NULL 
DEFAULT 1,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571109 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) iscustom TINYINT(1) NOT NULL 
DEFAULT 0,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.57 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) layoutmenuorder BIGINT(10) 
NOT NULL DEFAULT 0,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571112 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) CONSTRAINT  PRIMARY KEY (id), 
referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  Looking into file htdocs/lib/db/install.xml (line726) – table view_layout

  A Quick analysis of the problem indicated the following
  The column rows in the table view_layout is causing a problem (as of MariaDB 
10.2.4 rows is now a reserved keyword 
(https://mariadb.com/kb/en/mariadb/reserved-words/)

[Mahara-contributors] [Bug 1706263] Re: Mahara17.04.2 fails to install when deployed against MariaDB v10.2.4 or higher

2017-08-01 Thread Kristina Hoeppner 
Cecilia, can you please take a look at the reported error and the patch?

** Changed in: mahara
 Assignee: (unassigned) => Cecilia Vela Gurovic (ceciliavg)

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

Title:
  Mahara17.04.2 fails to install when deployed against MariaDB v10.2.4
  or higher

Status in Mahara:
  New

Bug description:
  During the installation process the installation is halted due to an
  error. As a result further deploy+ent of the Mahara server is not
  possible.

  Used configuration Ubuntu 16.4LTS, Moodle 3.3.1, Mahara 17.04.2,
  MariaDB 10.2.6

  Consulting the apache error log files gives back following information

  [Mon Jul 24 10:06:57.616387 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [INF] 2a (admin/upgrade.php:49) Starting Mahara 
installation..., referer: http://mahara.syntra-cloud.be/admin/index.php
  [Mon Jul 24 10:07:11.571057 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) mysqli error: [1064: You have an 
error in your SQL syntax; check the manual that corresponds to your MariaDB 
server version for the right syntax to use near 'rows BIGINT(10) NOT NULL 
DEFAULT 1,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571082 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) iscustom TINYINT(1) NOT NULL 
DEFAULT 0,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571094 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) ' at line 3] in EXECUTE("CREATE 
TABLE view_layout (, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571096 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) id BIGINT(10) NOT NULL 
auto_increment,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571097 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) rows BIGINT(10) NOT NULL 
DEFAULT 1,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571099 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) iscustom TINYINT(1) NOT NULL 
DEFAULT 0,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571101 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) layoutmenuorder BIGINT(10) 
NOT NULL DEFAULT 0,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571102 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) CONSTRAINT  PRIMARY KEY (id), 
referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571104 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) )ENGINE=innodb")Command was: 
CREATE TABLE view_layout (, referer: 
http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571106 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) id BIGINT(10) NOT NULL 
auto_increment,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571108 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) rows BIGINT(10) NOT NULL 
DEFAULT 1,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571109 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) iscustom TINYINT(1) NOT NULL 
DEFAULT 0,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.57 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) layoutmenuorder BIGINT(10) 
NOT NULL DEFAULT 0,, referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  [Mon Jul 24 10:07:11.571112 2017] [:error] [pid 38507] [client 
81.165.22.67:55069] [DBG] 98 (lib/dml.php:157) CONSTRAINT  PRIMARY KEY (id), 
referer: http://mahara.syntra-cloud.be/admin/upgrade.php
  Looking into file htdocs/lib/db/install.xml (line726) – table view_layout

  A Quick analysis of the problem indicated the following
  The column rows in the table view_layout is causing a problem (as of MariaDB 
10.2.4 rows is now a reserved keyword 
(https://mariadb.com/kb/en/mariadb/reserved-words/)

  
  
  
  
  
  
  
  
  
  
  

  To hotfix the issue I´ve updated the column rows to numrows in the
  following files after which the installation continues as expected and
  Mahara functioned properly.

  htdocs/lib/db/install.xml (line726) rename