Forums | Mahara Community
Support
/
Failed to upgrade on interaction.forum
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 |
19 April 2017, 9:03
I just refreshed the page and got this. Can anyone make sense of this?
------
Command was: CREATE INDEX inteforupost_pat_ix ON interaction_forum_post (path)
- 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
(
[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)
)
- 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
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
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.
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
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. ...
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
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).
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
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.
- «Previous page
- 1
- 2
- »Next page