Patch for "master" branch: https://reviews.mahara.org/5681
-- 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/1514415 Title: [MySQL] Index column size too large. The maximum column size is 767 bytes. Status in Mahara: In Progress Bug description: Hallo, I have tried to install Mahara with MySQL. I have installed it in the following way: 1. I cloned the git repository at https://git.mahara.org/mahara/mahara.git 2. I built mahara with make css to create all neccessary files 3. I started the installationn with php admin/cli/install.php --adminpassword='<my-password>' --adminemail=<my-mail> After a while the following error appeared: "(lib/dml.php:150) mysqli error: [1709: Index column size too large. The maximum column size is 767 bytes.]" I did some research and found a potential solution for that: 1. Some entries in my.cnf, which I have already added: innodb_large_prefix=on innodb_file_format=barracuda innodb_file_per_table=true 2. To add "ROW_FORMAT=DYNAMIC;" when creating a table. But I have no idea how to do this. More information on this error can be found on: http://mechanics.flite.com/blog/2014/07/29/using-innodb-large-prefix-to-avoid-error-1071/ https://dev.mysql.com/doc/refman/5.5/en/innodb-restrictions.html https://dev.mysql.com/doc/refman/5.5/en/innodb-row-format-dynamic.html Here is the log-file [INF] 72 (admin/cli/install.php:74) Installing Mahara [INF] 72 (lib/mahara.php:228) Installing core [INF] 72 (lib/upgrade.php:1364) Enabled 2 HTML filters. [INF] 72 (lib/mahara.php:228) Installing firstcoredata [INF] 72 (lib/mahara.php:228) Installing localpreinst [INF] 72 (lib/mahara.php:228) Installing artefact.plans [INF] 72 (lib/mahara.php:228) Installing artefact.blog [INF] 72 (lib/mahara.php:228) Installing artefact.internal [INF] 72 (lib/mahara.php:228) Installing artefact.comment [INF] 72 (lib/mahara.php:228) Installing artefact.file [INF] 72 (artefact/file/lib.php:269) Updated filetype list: 142 added. [INF] 72 (lib/mahara.php:228) Installing artefact.annotation [INF] 72 (lib/mahara.php:228) Installing artefact.resume [INF] 72 (lib/mahara.php:228) Installing auth.saml [INF] 72 (lib/mahara.php:228) Installing auth.internal [INF] 72 (lib/mahara.php:228) Installing auth.ldap [INF] 72 (lib/mahara.php:228) Installing auth.browserid [INF] 72 (lib/mahara.php:228) Installing auth.none [INF] 72 (lib/mahara.php:228) Installing auth.imap [INF] 72 (lib/mahara.php:228) Installing auth.webservice [INF] 72 (lib/mahara.php:228) Installing auth.xmlrpc [INF] 72 (lib/mahara.php:228) Installing notification.email [INF] 72 (lib/mahara.php:228) Installing notification.emaildigest [INF] 72 (lib/mahara.php:228) Installing notification.internal [INF] 72 (lib/mahara.php:228) Installing search.elasticsearch [INF] 72 (lib/mahara.php:228) Installing search.internal [INF] 72 (lib/mahara.php:228) Installing blocktype.file/gallery [INF] 72 (lib/mahara.php:228) Installing blocktype.resume/entireresume [INF] 72 (lib/mahara.php:228) Installing blocktype.internal/profileinfo [INF] 72 (lib/mahara.php:228) Installing blocktype.file/image [INF] 72 (lib/mahara.php:228) Installing blocktype.internal/textbox [INF] 72 (lib/mahara.php:228) Installing blocktype.internal/socialprofile [INF] 72 (lib/mahara.php:228) Installing blocktype.file/pdf [INF] 72 (lib/mahara.php:228) Installing blocktype.file/html [INF] 72 (lib/mahara.php:228) Installing blocktype.blog/recentposts [INF] 72 (lib/mahara.php:228) Installing blocktype.file/filedownload [INF] 72 (lib/mahara.php:228) Installing blocktype.comment/comment [INF] 72 (lib/mahara.php:228) Installing blocktype.file/folder [INF] 72 (lib/mahara.php:228) Installing blocktype.blog/blog [INF] 72 (lib/mahara.php:228) Installing blocktype.resume/resumefield [INF] 72 (lib/mahara.php:228) Installing blocktype.blog/taggedposts [INF] 72 (lib/mahara.php:228) Installing blocktype.blog/blogpost [INF] 72 (lib/mahara.php:228) Installing blocktype.myfriends [INF] 72 (lib/mahara.php:228) Installing blocktype.externalvideo [INF] 72 (lib/mahara.php:228) Installing blocktype.inbox [INF] 72 (lib/mahara.php:228) Installing blocktype.recentforumposts [INF] 72 (lib/mahara.php:228) Installing blocktype.plans/plans [INF] 72 (lib/mahara.php:228) Installing blocktype.groupmembers [INF] 72 (lib/mahara.php:228) Installing blocktype.groupinfo [INF] 72 (lib/mahara.php:228) Installing blocktype.googleapps [INF] 72 (lib/mahara.php:228) Installing blocktype.file/internalmedia [INF] 72 (lib/mahara.php:228) Installing blocktype.text [INF] 72 (lib/mahara.php:228) Installing blocktype.externalfeed [INF] 72 (lib/mahara.php:228) Installing blocktype.wall [INF] 72 (lib/mahara.php:228) Installing blocktype.annotation/annotation [INF] 72 (lib/mahara.php:228) Installing blocktype.creativecommons [INF] 72 (lib/mahara.php:228) Installing blocktype.groupviews [INF] 72 (lib/mahara.php:228) Installing blocktype.myviews [INF] 72 (lib/mahara.php:228) Installing blocktype.navigation [INF] 72 (lib/mahara.php:228) Installing blocktype.mygroups [INF] 72 (lib/mahara.php:228) Installing blocktype.watchlist [INF] 72 (lib/mahara.php:228) Installing blocktype.newviews [INF] 72 (lib/mahara.php:228) Installing interaction.forum [DBG] 72 (lib/dml.php:150) mysqli error: [1709: Index column size too large. The maximum column size is 767 bytes.] in ON interaction_forum_post (path), ) [DBG] 72 (lib/dml.php:150) Command was: CREATE INDEX inteforupost_pat_ix ON interaction_forum_post (path) [WAR] 72 (lib/errors.php:747) Could not execute command: CREATE INDEX inteforupost_pat_ix ON interaction_forum_post (pa Call stack (most recent first): * log_message("Could not execute command: CREATE INDEX inteforupo...", 8, true, true) at /var/www/mahara.via4all.de/l * log_warn("Could not execute command: CREATE INDEX inteforupo...") at /var/www/mahara.via4all.de/lib/errors.php:747 * SQLException->__construct("Could not execute command: CREATE INDEX inteforupo...") at /var/www/mahara.via4all.de/li * execute_sql("CREATE INDEX inteforupost_pat_ix ON interaction_fo...") at /var/www/mahara.via4all.de/lib/dml.php:1390 * execute_sql_arr(array(size 21)) at /var/www/mahara.via4all.de/lib/ddl.php:752 * install_from_xmldb_file("/var/www/mahara.via4all.de/interaction/forum/db/in...") at /var/www/mahara.via4all.de/lib/ * upgrade_plugin(object(stdClass)) at /var/www/mahara.via4all.de/lib/mahara.php:263 * upgrade_mahara(array(size 70)) at /var/www/mahara.via4all.de/admin/cli/install.php:75 [DBG] 72 (lib/ddl.php:753) Array [DBG] 72 (lib/ddl.php:753) ( [DBG] 72 (lib/ddl.php:753) [0] => CREATE TABLE interaction_forum_instance_config ( [DBG] 72 (lib/ddl.php:753) forum BIGINT(10) NOT NULL, [DBG] 72 (lib/ddl.php:753) field TEXT NOT NULL, [DBG] 72 (lib/ddl.php:753) value TEXT NOT NULL, [DBG] 72 (lib/ddl.php:753) CONSTRAINT inteforuinstconf_for_fk FOREIGN KEY (forum) REFERENCES interaction_instance (id) [DBG] 72 (lib/ddl.php:753) )ENGINE=innodb [DBG] 72 (lib/ddl.php:753) [1] => CREATE INDEX inteforuinstconf_for_ix ON interaction_forum_instance_config (forum) [DBG] 72 (lib/ddl.php:753) [2] => CREATE TABLE interaction_forum_topic ( [DBG] 72 (lib/ddl.php:753) id BIGINT(10) NOT NULL auto_increment, [DBG] 72 (lib/ddl.php:753) forum BIGINT(10) NOT NULL, [DBG] 72 (lib/ddl.php:753) sticky TINYINT(1) NOT NULL DEFAULT 0, [DBG] 72 (lib/ddl.php:753) closed TINYINT(1) NOT NULL DEFAULT 0, [DBG] 72 (lib/ddl.php:753) deleted TINYINT(1) NOT NULL DEFAULT 0, [DBG] 72 (lib/ddl.php:753) CONSTRAINT PRIMARY KEY (id), [DBG] 72 (lib/ddl.php:753) CONSTRAINT inteforutopi_for_fk FOREIGN KEY (forum) REFERENCES interaction_instance (id) [DBG] 72 (lib/ddl.php:753) )ENGINE=innodb [DBG] 72 (lib/ddl.php:753) [3] => CREATE INDEX inteforutopi_for_ix ON interaction_forum_topic (forum) [DBG] 72 (lib/ddl.php:753) [4] => CREATE TABLE interaction_forum_post ( [DBG] 72 (lib/ddl.php:753) id BIGINT(10) NOT NULL auto_increment, [DBG] 72 (lib/ddl.php:753) topic BIGINT(10) NOT NULL, [DBG] 72 (lib/ddl.php:753) parent BIGINT(10) DEFAULT NULL, [DBG] 72 (lib/ddl.php:753) poster BIGINT(10) NOT NULL, [DBG] 72 (lib/ddl.php:753) subject VARCHAR(255) DEFAULT NULL, [DBG] 72 (lib/ddl.php:753) body TEXT NOT NULL, [DBG] 72 (lib/ddl.php:753) ctime DATETIME NOT NULL, [DBG] 72 (lib/ddl.php:753) deleted TINYINT(1) NOT NULL DEFAULT 0, [DBG] 72 (lib/ddl.php:753) sent TINYINT(1) NOT NULL DEFAULT 0, [DBG] 72 (lib/ddl.php:753) path VARCHAR(2048) DEFAULT NULL, [DBG] 72 (lib/ddl.php:753) CONSTRAINT PRIMARY KEY (id), [DBG] 72 (lib/ddl.php:753) CONSTRAINT inteforupost_top_fk FOREIGN KEY (topic) REFERENCES interaction_forum_topic (id), [DBG] 72 (lib/ddl.php:753) CONSTRAINT inteforupost_par_fk FOREIGN KEY (parent) REFERENCES interaction_forum_post (id), [DBG] 72 (lib/ddl.php:753) CONSTRAINT inteforupost_pos_fk FOREIGN KEY (poster) REFERENCES usr (id) [DBG] 72 (lib/ddl.php:753) )ENGINE=innodb [DBG] 72 (lib/ddl.php:753) [5] => CREATE INDEX inteforupost_pat_ix ON interaction_forum_post (path) [DBG] 72 (lib/ddl.php:753) [6] => CREATE INDEX inteforupost_top_ix ON interaction_forum_post (topic) [DBG] 72 (lib/ddl.php:753) [7] => CREATE INDEX inteforupost_par_ix ON interaction_forum_post (parent) [DBG] 72 (lib/ddl.php:753) [8] => CREATE INDEX inteforupost_pos_ix ON interaction_forum_post (poster) [DBG] 72 (lib/ddl.php:753) [9] => CREATE TABLE interaction_forum_subscription_forum ( [DBG] 72 (lib/ddl.php:753) user BIGINT(10) NOT NULL, [DBG] 72 (lib/ddl.php:753) forum BIGINT(10) NOT NULL, [DBG] 72 (lib/ddl.php:753) `key` VARCHAR(50) NOT NULL, [DBG] 72 (lib/ddl.php:753) CONSTRAINT PRIMARY KEY (user, forum), [DBG] 72 (lib/ddl.php:753) CONSTRAINT inteforusubsforu_use_fk FOREIGN KEY (user) REFERENCES usr (id), [DBG] 72 (lib/ddl.php:753) CONSTRAINT inteforusubsforu_for_fk FOREIGN KEY (forum) REFERENCES interaction_instance (id), [DBG] 72 (lib/ddl.php:753) CONSTRAINT inteforusubsforu_key_uk UNIQUE (`key`) [DBG] 72 (lib/ddl.php:753) )ENGINE=innodb [DBG] 72 (lib/ddl.php:753) [10] => CREATE INDEX inteforusubsforu_use_ix ON interaction_forum_subscription_forum (us [DBG] 72 (lib/ddl.php:753) [11] => CREATE INDEX inteforusubsforu_for_ix ON interaction_forum_subscription_forum (fo [DBG] 72 (lib/ddl.php:753) [12] => CREATE TABLE interaction_forum_subscription_topic ( [DBG] 72 (lib/ddl.php:753) user BIGINT(10) NOT NULL, [DBG] 72 (lib/ddl.php:753) topic BIGINT(10) NOT NULL, [DBG] 72 (lib/ddl.php:753) `key` VARCHAR(50) NOT NULL, [DBG] 72 (lib/ddl.php:753) CONSTRAINT PRIMARY KEY (user, topic), [DBG] 72 (lib/ddl.php:753) CONSTRAINT inteforusubstopi_use_fk FOREIGN KEY (user) REFERENCES usr (id), [DBG] 72 (lib/ddl.php:753) CONSTRAINT inteforusubstopi_top_fk FOREIGN KEY (topic) REFERENCES interaction_forum_topic (i [DBG] 72 (lib/ddl.php:753) CONSTRAINT inteforusubstopi_key_uk UNIQUE (`key`) [DBG] 72 (lib/ddl.php:753) )ENGINE=innodb [DBG] 72 (lib/ddl.php:753) [13] => CREATE INDEX inteforusubstopi_use_ix ON interaction_forum_subscription_topic (us [DBG] 72 (lib/ddl.php:753) [14] => CREATE INDEX inteforusubstopi_top_ix ON interaction_forum_subscription_topic (to [DBG] 72 (lib/ddl.php:753) [15] => CREATE TABLE interaction_forum_moderator ( [DBG] 72 (lib/ddl.php:753) user BIGINT(10) NOT NULL, [DBG] 72 (lib/ddl.php:753) forum BIGINT(10) NOT NULL, [DBG] 72 (lib/ddl.php:753) CONSTRAINT inteforumode_use_fk FOREIGN KEY (user) REFERENCES usr (id), [DBG] 72 (lib/ddl.php:753) CONSTRAINT inteforumode_for_fk FOREIGN KEY (forum) REFERENCES interaction_instance (id) [DBG] 72 (lib/ddl.php:753) )ENGINE=innodb [DBG] 72 (lib/ddl.php:753) [16] => CREATE INDEX inteforumode_use_ix ON interaction_forum_moderator (user) [DBG] 72 (lib/ddl.php:753) [17] => CREATE INDEX inteforumode_for_ix ON interaction_forum_moderator (forum) [DBG] 72 (lib/ddl.php:753) [18] => CREATE TABLE interaction_forum_edit ( [DBG] 72 (lib/ddl.php:753) user BIGINT(10) NOT NULL, [DBG] 72 (lib/ddl.php:753) post BIGINT(10) NOT NULL, [DBG] 72 (lib/ddl.php:753) ctime DATETIME NOT NULL, [DBG] 72 (lib/ddl.php:753) CONSTRAINT inteforuedit_use_fk FOREIGN KEY (user) REFERENCES usr (id), [DBG] 72 (lib/ddl.php:753) CONSTRAINT inteforuedit_pos_fk FOREIGN KEY (post) REFERENCES interaction_forum_post (id) [DBG] 72 (lib/ddl.php:753) )ENGINE=innodb [DBG] 72 (lib/ddl.php:753) [19] => CREATE INDEX inteforuedit_use_ix ON interaction_forum_edit (user) [DBG] 72 (lib/ddl.php:753) [20] => CREATE INDEX inteforuedit_pos_ix ON interaction_forum_edit (post) [DBG] 72 (lib/ddl.php:753) ) [DBG] 72 (lib/ddl.php:753) [WAR] 72 (lib/errors.php:747) Failed to install (check logs for xmldb errors) Call stack (most recent first): * log_message("Failed to install (check logs for xmldb errors)", 8, true, true) at /var/www/mahara.via4all.de/lib/err * log_warn("Failed to install (check logs for xmldb errors)") at /var/www/mahara.via4all.de/lib/errors.php:747 * SQLException->__construct("Failed to install (check logs for xmldb errors)") at /var/www/mahara.via4all.de/lib/ddl. * install_from_xmldb_file("/var/www/mahara.via4all.de/interaction/forum/db/in...") at /var/www/mahara.via4all.de/lib/ * upgrade_plugin(object(stdClass)) at /var/www/mahara.via4all.de/lib/mahara.php:263 * upgrade_mahara(array(size 70)) at /var/www/mahara.via4all.de/admin/cli/install.php:75 [WAR] 72 (lib/ddl.php:754) Failed to install (check logs for xmldb errors) Call stack (most recent first): * install_from_xmldb_file("/var/www/mahara.via4all.de/interaction/forum/db/in...") at /var/www/mahara.via4all.de/lib/ * upgrade_plugin(object(stdClass)) at /var/www/mahara.via4all.de/lib/mahara.php:263 * upgrade_mahara(array(size 70)) at /var/www/mahara.via4all.de/admin/cli/install.php:75 A nonrecoverable error occurred. This probably means you have encountered a bug in the systemroot To manage notifications about this bug go to: https://bugs.launchpad.net/mahara/+bug/1514415/+subscriptions _______________________________________________ Mailing list: https://launchpad.net/~mahara-contributors Post to : mahara-contributors@lists.launchpad.net Unsubscribe : https://launchpad.net/~mahara-contributors More help : https://help.launchpad.net/ListHelp
