{"id":13730815,"date":"2020-12-01T14:24:27","date_gmt":"2020-12-01T14:24:27","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/major-table-creations-fail-due-to-large-index-key-size\/"},"modified":"2020-12-01T14:24:27","modified_gmt":"2020-12-01T14:24:27","slug":"major-table-creations-fail-due-to-large-index-key-size","status":"publish","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/major-table-creations-fail-due-to-large-index-key-size\/","title":{"rendered":"Major: Table creations fail due to large index key size"},"content":{"rendered":"<p>Thanks for your work on 13.0.3, but I&#8217;m seeing a problem in <code>error_log<\/code> creating the tables <code>wp_statistics_visitor<\/code>, <code>wp_statistics_pages<\/code> and <code>wp_statistics_historical<\/code>. <\/p>\n<p>We are on CentOS, PHP 7.3, Mariadb 10.3.<\/p>\n<p>The tables are not created.<\/p>\n<p>Here is the last error:<\/p>\n<pre><code>WordPress database error Specified key was too long; max key length is 1000 bytes for query \nCREATE TABLE wp_statistics_historical (\n\tID bigint(20) NOT NULL AUTO_INCREMENT,\n\tcategory varchar(25) NOT NULL,\n\tpage_id bigint(20) NOT NULL,\n\turi varchar(255) NOT NULL,\n\tvalue bigint(20) NOT NULL,\n\tPRIMARY KEY  (ID),\n\tKEY category (category),\n\tUNIQUE KEY page_id (page_id),\n\tUNIQUE KEY uri (uri)\n) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci made by activate_plugin, do_action(&#039;activate_wp-statistics\/wp-statistics.php&#039;), WP_Hook-&gt;do_action, WP_Hook-&gt;apply_filters, WP_Statistics::install, WP_STATISTICS\\Install-&gt;install, WP_STATISTICS\\Install::create_table, WP_STATISTICS\\Install::table_sql, dbDelta<\/code><\/pre>\n","protected":false},"template":"","class_list":["post-13730815","topic","type-topic","status-publish","hentry","topic-tag-db","topic-tag-dbdelta"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/13730815","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/13730815\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=13730815"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}