Forums | Mahara Community

Support /
Failed to upgrade on interaction.forum


Miriam Laidlaw's profile picture
Posts: 15

19 April 2017, 9:00

Mahara version 16.10.2 (2016090213)

Running it on MAMP Version 3.4 (3.4) running PHP Version 5.6.10

As per instructions in other parts of the forum, I added the bits on the end of the config file to show errors. So it shows all the stuff at the top when it is doing things, but no actual ERROR actually shows up there, it just stops.

-----------

This is what my installation page stalls at:

[INF] a7 (admin/upgrade.php:49) Starting Mahara installation...
[INF] e5 (lib/upgrade.php:1358) Enabled 2 HTML filters.
[INF] e5 (admin/upgrade.json.php:90) - core 16.10.2 (2016090213)
[INF] cb (admin/upgrade.json.php:48) - firstcoredata
[INF] 97 (admin/upgrade.json.php:48) - localpreinst
[INF] 32 (admin/upgrade.json.php:90) - artefact.blog 1.2.0 (2015082600)
[INF] 58 (admin/upgrade.json.php:90) - artefact.plans 0.0.1 (2010072302)
[INF] a2 (artefact/file/lib.php:242) Synced filetype list with filetypes.xml
[INF] a2 (admin/upgrade.json.php:90) - artefact.file 1.2.7 (2016082901)
[INF] 68 (admin/upgrade.json.php:90) - artefact.internal 1.3.0 (2014092500)
[INF] a6 (admin/upgrade.json.php:90) - artefact.annotation 1.0.0 (2014122100)
[INF] 74 (admin/upgrade.json.php:90) - artefact.comment 1.0.1 (2016051000)
[INF] c4 (admin/upgrade.json.php:90) - artefact.resume 1.0.2 (2013072900)
[INF] 66 (admin/upgrade.json.php:90) - auth.internal 1.0.0 (2008012400)
[INF] 82 (admin/upgrade.json.php:90) - auth.webservice 2.0.1 (2016101100)
[INF] 9a (admin/upgrade.json.php:90) - auth.none 1.0.0 (2008040200)
[INF] 99 (admin/upgrade.json.php:90) - auth.xmlrpc 1.0.0 (2008040200)
[INF] 4a (admin/upgrade.json.php:90) - auth.browserid 0.0.0 (2016092600)
[INF] 28 (admin/upgrade.json.php:90) - auth.imap 1.2.0 (2015111600)
[INF] 32 (admin/upgrade.json.php:90) - auth.ldap 1.1.0 (2013051600)
[INF] 23 (admin/upgrade.json.php:90) - auth.saml 1.2.0 (2016062900)
[INF] 09 (admin/upgrade.json.php:90) - notification.emaildigest 1.0.1 (2009012700)
[INF] 0e (admin/upgrade.json.php:90) - notification.email 1.0.0 (2008040200)
[INF] 6a (admin/upgrade.json.php:90) - notification.internal 1.0.3 (2012021000)
[INF] 75 (admin/upgrade.json.php:90) - search.internal 1.0.0 (2008040200)
[INF] 9f (admin/upgrade.json.php:90) - search.elasticsearch 1.0.4 (2015100800)
[INF] 6b (admin/upgrade.json.php:90) - module.multirecipientnotification 1.0.2 (2015070500)
[DBG] 2c (module/framework/lib.php:43) Add a foreign key on collection.framework to framework.id
[INF] 2c (admin/upgrade.json.php:90) - module.framework 1.0.3 (2016101400)
[INF] d7 (admin/upgrade.json.php:90) - module.mobileapi 1.0.0 (2016092104)
[INF] 30 (admin/upgrade.json.php:90) - blocktype.file/folder 1.0.2 (2013120901)
[INF] 32 (admin/upgrade.json.php:90) - blocktype.blog/blog 1.0.1 (2008040201)
[INF] db (admin/upgrade.json.php:90) - blocktype.resume/resumefield 1.0.1 (2008040201)
[INF] 3c (admin/upgrade.json.php:90) - blocktype.file/filedownload 1.0.1 (2010090801)
[INF] 03 (admin/upgrade.json.php:90) - blocktype.blog/blogpost 1.0.1 (2008040201)
[INF] 53 (admin/upgrade.json.php:90) - blocktype.comment/comment 1.0.1 (2013100101)
[INF] a6 (admin/upgrade.json.php:90) - blocktype.blog/recentposts 1.0.1 (2008040201)
[INF] 59 (admin/upgrade.json.php:90) - blocktype.resume/entireresume 1.0.1 (2008040201)
[INF] 60 (admin/upgrade.json.php:90) - blocktype.internal/profileinfo 1.0.1 (2008040201)
[INF] 5d (admin/upgrade.json.php:90) - blocktype.internal/textbox 2.0.1 (2011082201)
[INF] e2 (admin/upgrade.json.php:90) - blocktype.plans/plans 1.0.1 (2010051701)
[INF] 0d (admin/upgrade.json.php:90) - blocktype.file/html 1.0.1 (2010090801)
[INF] 1e (admin/upgrade.json.php:90) - blocktype.file/internalmedia 1.0.1 (2010090801)
[INF] dd (admin/upgrade.json.php:90) - blocktype.internal/socialprofile 1.0.1 (2014011601)
[INF] 3a (admin/upgrade.json.php:90) - blocktype.file/image 1.0.3 (2010090803)
[INF] b4 (admin/upgrade.json.php:90) - blocktype.annotation/annotation 1.0.0 (2014122100)
[INF] 68 (admin/upgrade.json.php:90) - blocktype.blog/taggedposts 1.1.1 (2015020200)
[INF] 7f (admin/upgrade.json.php:90) - blocktype.wall 1.2.0 (2016101700)
[INF] 39 (admin/upgrade.json.php:90) - blocktype.file/pdf 1.0.2 (2015020200)
[INF] eb (admin/upgrade.json.php:90) - blocktype.file/gallery 2.0.1 (2011060801)
[INF] a1 (admin/upgrade.json.php:90) - blocktype.googleapps 1.0.9 (2011051701)
[INF] e0 (admin/upgrade.json.php:90) - blocktype.groupinfo 1.0.0 (2010061805)
[INF] 6d (admin/upgrade.json.php:90) - blocktype.groupmembers 1.0.1 (2010061804)
[INF] 65 (admin/upgrade.json.php:90) - blocktype.groupviews 1.0.3 (2016032300)
[INF] c2 (admin/upgrade.json.php:90) - blocktype.inbox 1.0.1 (2010031801)
[INF] fe (admin/upgrade.json.php:90) - blocktype.myfriends 1.0.1 (2010031801)
[INF] 92 (admin/upgrade.json.php:90) - blocktype.mygroups 1.0.1 (2010031801)
[INF] 17 (admin/upgrade.json.php:90) - blocktype.externalfeed 1.0.6 (2016021200)
[INF] d0 (admin/upgrade.json.php:90) - blocktype.newviews 1.0.2 (2010042802)
[INF] 34 (admin/upgrade.json.php:90) - blocktype.myviews 1.0.2 (2010031802)
[INF] f5 (admin/upgrade.json.php:90) - blocktype.externalvideo 1.1.0 (2015112400)
[INF] 5b (admin/upgrade.json.php:90) - blocktype.navigation 1.0.1 (2010070701)
[INF] 29 (admin/upgrade.json.php:90) - blocktype.openbadgedisplayer 1.0.5 (2016030200)
[INF] 61 (admin/upgrade.json.php:90) - blocktype.watchlist 1.0.1 (2011090701)
[INF] 52 (admin/upgrade.json.php:90) - blocktype.creativecommons 1.0.1 (2010090801)
[INF] 2a (admin/upgrade.json.php:90) - blocktype.recentforumposts 1.0.1 (2010090802)
[INF] 75 (admin/upgrade.json.php:90) - blocktype.text 1.0.3 (2014082203)

 

Performing installation...

COMPONENT OR PLUGIN FROM VERSION TO VERSION INFORMATION
core Not installed 16.10.2 Successfully installed version 16.10.2 (2016090213)
firstcoredata     Successfully installed core data
localpreinst     Successfully installed local customisations
artefact.blog Not installed 1.2.0 Successfully installed version 1.2.0 (2015082600)
artefact.plans Not installed 0.0.1 Successfully installed version 0.0.1 (2010072302)
artefact.file Not installed 1.2.7 Successfully installed version 1.2.7 (2016082901)
artefact.internal Not installed 1.3.0 Successfully installed version 1.3.0 (2014092500)
artefact.annotation Not installed 1.0.0 Successfully installed version 1.0.0 (2014122100)
artefact.comment Not installed 1.0.1 Successfully installed version 1.0.1 (2016051000)
artefact.resume Not installed 1.0.2 Successfully installed version 1.0.2 (2013072900)
auth.internal Not installed 1.0.0 Successfully installed version 1.0.0 (2008012400)
auth.webservice Not installed 2.0.1 Successfully installed version 2.0.1 (2016101100)
auth.none Not installed 1.0.0 Successfully installed version 1.0.0 (2008040200)
auth.xmlrpc Not installed 1.0.0 Successfully installed version 1.0.0 (2008040200)
auth.browserid Not installed 0.0.0 Successfully installed version 0.0.0 (2016092600)
auth.imap Not installed 1.2.0 Successfully installed version 1.2.0 (2015111600)
auth.ldap Not installed 1.1.0 Successfully installed version 1.1.0 (2013051600)
auth.saml Not installed 1.2.0 Successfully installed version 1.2.0 (2016062900)
notification.emaildigest Not installed 1.0.1 Successfully installed version 1.0.1 (2009012700)
notification.email Not installed 1.0.0 Successfully installed version 1.0.0 (2008040200)
notification.internal Not installed 1.0.3 Successfully installed version 1.0.3 (2012021000)
search.internal Not installed 1.0.0 Successfully installed version 1.0.0 (2008040200)
search.elasticsearch Not installed 1.0.4 Successfully installed version 1.0.4 (2015100800)
module.multirecipientnotification Not installed 1.0.2 Successfully installed version 1.0.2 (2015070500)
module.framework Not installed 1.0.3 Successfully installed version 1.0.3 (2016101400)
module.mobileapi Not installed 1.0.0 Successfully installed version 1.0.0 (2016092104)
blocktype.file/folder Not installed 1.0.2 Successfully installed version 1.0.2 (2013120901)
blocktype.blog/blog Not installed 1.0.1 Successfully installed version 1.0.1 (2008040201)
blocktype.resume/resumefield Not installed 1.0.1 Successfully installed version 1.0.1 (2008040201)
blocktype.file/filedownload Not installed 1.0.1 Successfully installed version 1.0.1 (2010090801)
blocktype.blog/blogpost Not installed 1.0.1 Successfully installed version 1.0.1 (2008040201)
blocktype.comment/comment Not installed 1.0.1 Successfully installed version 1.0.1 (2013100101)
blocktype.blog/recentposts Not installed 1.0.1 Successfully installed version 1.0.1 (2008040201)
blocktype.resume/entireresume Not installed 1.0.1 Successfully installed version 1.0.1 (2008040201)
blocktype.internal/profileinfo Not installed 1.0.1 Successfully installed version 1.0.1 (2008040201)
blocktype.internal/textbox Not installed 2.0.1 Successfully installed version 2.0.1 (2011082201)
blocktype.plans/plans Not installed 1.0.1 Successfully installed version 1.0.1 (2010051701)
blocktype.file/html Not installed 1.0.1 Successfully installed version 1.0.1 (2010090801)
blocktype.file/internalmedia Not installed 1.0.1 Successfully installed version 1.0.1 (2010090801)
blocktype.internal/socialprofile Not installed 1.0.1 Successfully installed version 1.0.1 (2014011601)
blocktype.file/image Not installed 1.0.3 Successfully installed version 1.0.3 (2010090803)
blocktype.annotation/annotation Not installed 1.0.0 Successfully installed version 1.0.0 (2014122100)
blocktype.blog/taggedposts Not installed 1.1.1 Successfully installed version 1.1.1 (2015020200)
blocktype.wall Not installed 1.2.0 Successfully installed version 1.2.0 (2016101700)
blocktype.file/pdf Not installed 1.0.2 Successfully installed version 1.0.2 (2015020200)
blocktype.file/gallery Not installed 2.0.1 Successfully installed version 2.0.1 (2011060801)
blocktype.googleapps Not installed 1.0.9 Successfully installed version 1.0.9 (2011051701)
blocktype.groupinfo Not installed 1.0.0 Successfully installed version 1.0.0 (2010061805)
blocktype.groupmembers Not installed 1.0.1 Successfully installed version 1.0.1 (2010061804)
blocktype.groupviews Not installed 1.0.3 Successfully installed version 1.0.3 (2016032300)
blocktype.inbox Not installed 1.0.1 Successfully installed version 1.0.1 (2010031801)
blocktype.myfriends Not installed 1.0.1 Successfully installed version 1.0.1 (2010031801)
blocktype.mygroups Not installed 1.0.1 Successfully installed version 1.0.1 (2010031801)
blocktype.externalfeed Not installed 1.0.6 Successfully installed version 1.0.6 (2016021200)
blocktype.newviews Not installed 1.0.2 Successfully installed version 1.0.2 (2010042802)
blocktype.myviews Not installed 1.0.2 Successfully installed version 1.0.2 (2010031802)
blocktype.externalvideo Not installed 1.1.0 Successfully installed version 1.1.0 (2015112400)
blocktype.navigation Not installed 1.0.1 Successfully installed version 1.0.1 (2010070701)
blocktype.openbadgedisplayer Not installed 1.0.5 Successfully installed version 1.0.5 (2016030200)
blocktype.watchlist Not installed 1.0.1 Successfully installed version 1.0.1 (2011090701)
blocktype.creativecommons Not installed 1.0.1 Successfully installed version 1.0.1 (2010090801)
blocktype.recentforumposts Not installed 1.0.1 Successfully installed version 1.0.1 (2010090802)
blocktype.text Not installed 1.0.3 Successfully installed version 1.0.3 (2014082203)
interaction.forum Not installed 1.2.2 Failed to upgrade.
grouptype.standard Not installed 1.0.0  
grouptype.course Not installed 1.0.0  
import.leap Not installed 0.1  
import.file Not installed 0.1  
export.html Not installed 0.1  
export.leap Not installed 0.1  
lastcoredata      
localpostinst      
Miriam Laidlaw's profile picture
Posts: 15

19 April 2017, 9:03

I just refreshed the page and got this. Can anyone make sense of this?

------

[DBG] 6f (lib/dml.php:157) mysqli error: [1709: Index column size too large. The maximum column size is 767 bytes.] in EXECUTE("CREATE INDEX inteforupost_pat_ix ON interaction_forum_post (path)")
Command was: CREATE INDEX inteforupost_pat_ix ON interaction_forum_post (path)
[WAR] 6f (lib/errors.php:859) Could not execute command: CREATE INDEX inteforupost_pat_ix ON interaction_forum_post (path)
Call stack (most recent first):
  • log_message(string(size 92), integer, true, true) at /Applications/MAMP/htdocs/mahara/lib/errors.php:95
  • log_warn(string(size 92)) at /Applications/MAMP/htdocs/mahara/lib/errors.php:859
  • SQLException->__construct(string(size 92)) at /Applications/MAMP/htdocs/mahara/lib/dml.php:158
  • execute_sql(string(size 65)) at /Applications/MAMP/htdocs/mahara/lib/dml.php:1427
  • execute_sql_arr(array(size 21)) at /Applications/MAMP/htdocs/mahara/lib/ddl.php:752
  • install_from_xmldb_file(string(size 65)) at /Applications/MAMP/htdocs/mahara/lib/upgrade.php:417
  • upgrade_plugin(object(stdClass)) at /Applications/MAMP/htdocs/mahara/admin/upgrade.json.php:87
[DBG] 6f (lib/ddl.php:753) Array
(
    [0] => CREATE TABLE interaction_forum_instance_config (
    forum BIGINT(10) NOT NULL,
    field TEXT NOT NULL,
    value TEXT NOT NULL,
CONSTRAINT inteforuinstconf_for_fk FOREIGN KEY (forum) REFERENCES interaction_instance (id)
)ENGINE=innodb
    [1] => CREATE INDEX inteforuinstconf_for_ix ON interaction_forum_instance_config (forum)
    [2] => CREATE TABLE interaction_forum_topic (
    id BIGINT(10) NOT NULL auto_increment,
    forum BIGINT(10) NOT NULL,
    sticky TINYINT(1) NOT NULL DEFAULT 0,
    closed TINYINT(1) NOT NULL DEFAULT 0,
    deleted TINYINT(1) NOT NULL DEFAULT 0,
CONSTRAINT  PRIMARY KEY (id),
CONSTRAINT inteforutopi_for_fk FOREIGN KEY (forum) REFERENCES interaction_instance (id)
)ENGINE=innodb
    [3] => CREATE INDEX inteforutopi_for_ix ON interaction_forum_topic (forum)
    [4] => CREATE TABLE interaction_forum_post (
    id BIGINT(10) NOT NULL auto_increment,
    topic BIGINT(10) NOT NULL,
    parent BIGINT(10) DEFAULT NULL,
    poster BIGINT(10) NOT NULL,
    subject VARCHAR(255) DEFAULT NULL,
    body TEXT NOT NULL,
    ctime DATETIME NOT NULL,
    deleted TINYINT(1) NOT NULL DEFAULT 0,
    sent TINYINT(1) NOT NULL DEFAULT 0,
    path VARCHAR(2048) DEFAULT NULL,
CONSTRAINT  PRIMARY KEY (id),
CONSTRAINT inteforupost_top_fk FOREIGN KEY (topic) REFERENCES interaction_forum_topic (id),
CONSTRAINT inteforupost_par_fk FOREIGN KEY (parent) REFERENCES interaction_forum_post (id),
CONSTRAINT inteforupost_pos_fk FOREIGN KEY (poster) REFERENCES usr (id)
)ENGINE=innodb
    [5] => CREATE INDEX inteforupost_pat_ix ON interaction_forum_post (path)
    [6] => CREATE INDEX inteforupost_top_ix ON interaction_forum_post (topic)
    [7] => CREATE INDEX inteforupost_par_ix ON interaction_forum_post (parent)
    [8] => CREATE INDEX inteforupost_pos_ix ON interaction_forum_post (poster)
    [9] => CREATE TABLE interaction_forum_subscription_forum (
    user BIGINT(10) NOT NULL,
    forum BIGINT(10) NOT NULL,
    `key` VARCHAR(50) NOT NULL,
CONSTRAINT  PRIMARY KEY (user, forum),
CONSTRAINT inteforusubsforu_use_fk FOREIGN KEY (user) REFERENCES usr (id),
CONSTRAINT inteforusubsforu_for_fk FOREIGN KEY (forum) REFERENCES interaction_instance (id),
CONSTRAINT inteforusubsforu_key_uk UNIQUE (`key`)
)ENGINE=innodb
    [10] => CREATE INDEX inteforusubsforu_use_ix ON interaction_forum_subscription_forum (user)
    [11] => CREATE INDEX inteforusubsforu_for_ix ON interaction_forum_subscription_forum (forum)
    [12] => CREATE TABLE interaction_forum_subscription_topic (
    user BIGINT(10) NOT NULL,
    topic BIGINT(10) NOT NULL,
    `key` VARCHAR(50) NOT NULL,
CONSTRAINT  PRIMARY KEY (user, topic),
CONSTRAINT inteforusubstopi_use_fk FOREIGN KEY (user) REFERENCES usr (id),
CONSTRAINT inteforusubstopi_top_fk FOREIGN KEY (topic) REFERENCES interaction_forum_topic (id),
CONSTRAINT inteforusubstopi_key_uk UNIQUE (`key`)
)ENGINE=innodb
    [13] => CREATE INDEX inteforusubstopi_use_ix ON interaction_forum_subscription_topic (user)
    [14] => CREATE INDEX inteforusubstopi_top_ix ON interaction_forum_subscription_topic (topic)
    [15] => CREATE TABLE interaction_forum_moderator (
    user BIGINT(10) NOT NULL,
    forum BIGINT(10) NOT NULL,
CONSTRAINT inteforumode_use_fk FOREIGN KEY (user) REFERENCES usr (id),
CONSTRAINT inteforumode_for_fk FOREIGN KEY (forum) REFERENCES interaction_instance (id)
)ENGINE=innodb
    [16] => CREATE INDEX inteforumode_use_ix ON interaction_forum_moderator (user)
    [17] => CREATE INDEX inteforumode_for_ix ON interaction_forum_moderator (forum)
    [18] => CREATE TABLE interaction_forum_edit (
    user BIGINT(10) NOT NULL,
    post BIGINT(10) NOT NULL,
    ctime DATETIME NOT NULL,
CONSTRAINT inteforuedit_use_fk FOREIGN KEY (user) REFERENCES usr (id),
CONSTRAINT inteforuedit_pos_fk FOREIGN KEY (post) REFERENCES interaction_forum_post (id)
)ENGINE=innodb
    [19] => CREATE INDEX inteforuedit_use_ix ON interaction_forum_edit (user)
    [20] => CREATE INDEX inteforuedit_pos_ix ON interaction_forum_edit (post)
)
[WAR] 6f (lib/errors.php:859) Failed to install (check logs for xmldb errors)
Call stack (most recent first):
  • log_message(string(size 47), integer, true, true) at /Applications/MAMP/htdocs/mahara/lib/errors.php:95
  • log_warn(string(size 47)) at /Applications/MAMP/htdocs/mahara/lib/errors.php:859
  • SQLException->__construct(string(size 47)) at /Applications/MAMP/htdocs/mahara/lib/ddl.php:754
  • install_from_xmldb_file(string(size 65)) at /Applications/MAMP/htdocs/mahara/lib/upgrade.php:417
  • upgrade_plugin(object(stdClass)) at /Applications/MAMP/htdocs/mahara/admin/upgrade.json.php:87

Upgrades

Nothing to upgrade. You are fully up to date.

05 June 2017, 11:34

Hi Miriam, hi all, 

Do you have any update on this one. I'm experiencing the same issue - as the screenshot below illustrate. 

I attempted  mahara-17.04,  mahara-17.04.1 and  mahara-17.04.02

failed_to_upgrade.JPG

 

Thanks a lot for your help!!

Vjeko

05 June 2017, 12:28

To add to my previous post: 

I was able to install Mahara mahara-17.04.1 ~ 4 weeks ago. In the meantime the only difference was because Moodle 3.3 requirements -- my provider made this changes:

  • innodb_file_format Barracuda
  • innodb_large_prefix' to 'ON

Networking with other Moodle sites (I'm using it for testing and demoing) did not work as planned, so I uninstalled that version. Now I can not reinstall it. 

Please advise,

Thaanks!

v. 

Robert Lyon's profile picture
Posts: 774

05 June 2017, 14:15

Hi

There seems to be an issue certain mysql instances and the creating of the 'path' index for the interaction_forum_post table.

Normally on install a table called 'interaction_forum_post' is created with

  path varchar(2048) DEFAULT NULL,

and

  KEY inteforupost_pat_ix (path(1024)),

Note the index is only 1024 and not 2048 as normally the index can only be 1024 chars. It sounds like it is trying to make this and failing as it's still too long.

This is created from the information in

 htdocs/interaction/forum/db/install.xml

Try commenting out the

 <INDEX NAME="pathix" UNIQUE="false" FIELDS="path"/>

And seeing if Mahara will then install, and if it does you can then add the index to the table manually.

Let me know if this works and if the index you can add is 1024 chars long or is a smaller number

A smaller number should still be fine - it will just mean the index is not as efficient

Cheers

Robert

H. Lekin's profile picture
Posts: 6

10 July 2017, 9:12

Hi Robert,

I ran into the same error with a new installation on Arch Linux.

[drib@manus] ~ $ pacman -Q mahara
mahara 17.04.2-1
[drib@manus] ~ $ php --version
PHP 7.1.6 (cli) (built: Jun 7 2017 21:11:40) ( NTS )
Copyright (c) 1997-2017 The PHP Group
Zend Engine v3.1.0, Copyright (c) 1998-2017 Zend Technologies
with Zend OPcache v7.1.6, Copyright (c) 1999-2017, by Zend Technologies
[drib@manus] ~ $ mysql --version
mysql Ver 15.1 Distrib 10.1.24-MariaDB, for Linux (x86_64) using readline 5.1
# /etc/mysql/my.cnf includes:
# innodb_large_prefix = 1
# innodb_file_format = Barracuda
# innodb_file_per_table = ON

Following your advice, I removed '<INDEX NAME="pathix" UNIQUE="false" FIELDS="path"/>' from install.xml and added the index manually:

MariaDB [mahara]> CREATE INDEX pathix ON interaction_forum_post (path (1024));
ERROR 1709 (HY000): Index column size too large. The maximum column size is 767 bytes.
MariaDB [mahara]> SELECT ROW_FORMAT FROM information_schema.INNODB_SYS_TABLES WHERE NAME = 'mahara/interaction_forum_post';
+------------+
| ROW_FORMAT |
+------------+
| Compact |
+------------+
1 row in set (0.00 sec)
MariaDB [mahara]> ALTER TABLE interaction_forum_post ROW_FORMAT=DYNAMIC;
Query OK, 0 rows affected (0.25 sec)
Records: 0 Duplicates: 0 Warnings: 0
MariaDB [mahara]> SELECT ROW_FORMAT FROM information_schema.INNODB_SYS_TABLES WHERE NAME = 'mahara/interaction_forum_post';
+------------+
| ROW_FORMAT |
+------------+
| Dynamic |
+------------+
1 row in set (0.00 sec)
MariaDB [mahara]> CREATE INDEX pathix ON interaction_forum_post (path (1024));
Query OK, 0 rows affected (0.13 sec)
Records: 0 Duplicates: 0 Warnings: 0
MariaDB [mahara]> SHOW INDEX FROM interaction_forum_post;
+------------------------+------------+---------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+------------------------+------------+---------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| interaction_forum_post | 0 | PRIMARY | 1 | id | A | 0 | NULL | NULL | | BTREE | | |
| interaction_forum_post | 1 | inteforupost_top_ix | 1 | topic | A | 0 | NULL | NULL | | BTREE | | |
| interaction_forum_post | 1 | inteforupost_par_ix | 1 | parent | A | 0 | NULL | NULL | YES | BTREE | | |
| interaction_forum_post | 1 | inteforupost_pos_ix | 1 | poster | A | 0 | NULL | NULL | | BTREE | | |
| interaction_forum_post | 1 | pathix | 1 | path | A | 0 | 1024 | NULL | YES | BTREE | | |
+------------------------+------------+---------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
5 rows in set (0.00 sec)

Hope this helps.

Unfortunately, Mahara's session regeneration / creation hardly works with PHP 7.1. ...

Kristina Hoeppner's profile picture
Posts: 4866

10 July 2017, 11:22

Hello,

A brief FYI: Mahara does not yet support PHP 7.1. The highest version officially supported is PHP 7.0.

Cheers

Kristina

 

H. Lekin's profile picture
Posts: 6

10 July 2017, 19:00

According to  README.md,  "Mahara requires PHP version 5.4 or later" ...

Can this be fixed somehow?

[10-Jul-2017 08:15:59 Europe/Berlin] [WAR] cc (auth/session.php:457) session_regenerate_id(): open(/var/lib/maharadata/sessions/u/r/m/sess_urm2kn7anrmcpdfu5cg5oh091q, O_RDWR) failed: No such file or directory (2)
[10-Jul-2017 08:15:59 Europe/Berlin] Call stack (most recent first):
[10-Jul-2017 08:15:59 Europe/Berlin]   * log_message(string(size 143), integer, true, true, string(size 42), integer) at /usr/share/webapps/mahara/lib/errors.php:521
[10-Jul-2017 08:15:59 Europe/Berlin]   * error(integer, string(size 143), string(size 42), integer, array(size 0)) at Unknown:0
[10-Jul-2017 08:15:59 Europe/Berlin]   * session_regenerate_id(true) at /usr/share/webapps/mahara/auth/session.php:457
[10-Jul-2017 08:15:59 Europe/Berlin]   * Session->regenerate_id() at /usr/share/webapps/mahara/auth/user.php:1682
[10-Jul-2017 08:15:59 Europe/Berlin]   * LiveUser->authenticate(object(stdClass), string(size 1)) at /usr/share/webapps/mahara/auth/user.php:1519
[10-Jul-2017 08:15:59 Europe/Berlin]   * LiveUser->login(string(size 5), string(size 8)) at /usr/share/webapps/mahara/auth/lib.php:1496
[10-Jul-2017 08:15:59 Europe/Berlin]   * login_submit(object(Pieform), array(size 6)) at /usr/share/webapps/mahara/lib/pieforms/pieform.php:543
[10-Jul-2017 08:15:59 Europe/Berlin]   * Pieform->__construct(array(size 9)) at /usr/share/webapps/mahara/lib/mahara.php:4828
[10-Jul-2017 08:15:59 Europe/Berlin]   * pieform_instance(array(size 9)) at /usr/share/webapps/mahara/auth/lib.php:504
[10-Jul-2017 08:15:59 Europe/Berlin]   * auth_setup() at /usr/share/webapps/mahara/init.php:389
[10-Jul-2017 08:15:59 Europe/Berlin]   * require("/usr/share/webapps/mahara/init.php") at /usr/share/webapps/mahara/index.php:16
[10-Jul-2017 08:15:59 Europe/Berlin]
[10-Jul-2017 08:15:59 Europe/Berlin] [WAR] cc (lib/errors.php:536) [Error]: Failed to create(read) session ID: files (path: 3;/var/lib/maharadata/sessions)
[10-Jul-2017 08:15:59 Europe/Berlin] Call stack (most recent first):
[10-Jul-2017 08:15:59 Europe/Berlin]   * exception(object(Error)) at Unknown:0

'/var/lib/maharadata/sessions/u/r/m/' is out of sessions' directory matix (0 - f).

Robert Lyon's profile picture
Posts: 774

11 July 2017, 6:52

Hi,

According to the PHP manual, http://php.net/manual/en/function.session-id.php

"Depending on the session handler, not all characters are allowed within the session id. For example, the file session handler only allows characters in the range a-z A-Z 0-9 , (comma) and - (minus)!"

So it sounds like we should allow more characters for the session paths.

Looking at http://php.net/manual/en/session.configuration.php#ini.session.sid-length it seems that a few new options were introduced in PHP 7.1

It looks like you will need to change the line in your htdocs/auth/session.php from

        ini_set('session.hash_bits_per_character', 4);

to

        ini_set('session.sid_bits_per_character', 4);

for now

And I'll file a bug to allow more session subdirectories to Mahara's dataroot session directory

Cheers

Robert

Kristina Hoeppner's profile picture
Posts: 4866

11 July 2017, 8:05

The bug report is at https://bugs.launchpad.net/bugs/1670637 if you want to follow its progress and give the patch a go on your PHP 7.1 system.

18 results