aboutsummaryrefslogtreecommitdiffstats
path: root/Zotlabs
diff options
context:
space:
mode:
authorMario Vavti <mario@mariovavti.com>2018-03-02 11:38:21 +0100
committerMario Vavti <mario@mariovavti.com>2018-03-02 11:38:21 +0100
commit5c46e66694ecab4e986cada35527ae4bf599b630 (patch)
tree7a373ab0c7b27085dd3a2155df640786c3ccb5aa /Zotlabs
parentbca05dc89f2e44c937f6a1bf4e8a6136060c5db8 (diff)
downloadvolse-hubzilla-5c46e66694ecab4e986cada35527ae4bf599b630.tar.gz
volse-hubzilla-5c46e66694ecab4e986cada35527ae4bf599b630.tar.bz2
volse-hubzilla-5c46e66694ecab4e986cada35527ae4bf599b630.zip
update DB update 1205 to mitigate
ERROR 1069 (42000): Too many keys specified; max 64 keys allowed
Diffstat (limited to 'Zotlabs')
-rw-r--r--Zotlabs/Update/_1205.php11
1 files changed, 11 insertions, 0 deletions
diff --git a/Zotlabs/Update/_1205.php b/Zotlabs/Update/_1205.php
index 5384f183e..968833726 100644
--- a/Zotlabs/Update/_1205.php
+++ b/Zotlabs/Update/_1205.php
@@ -7,6 +7,17 @@ class _1205 {
function run() {
if(ACTIVE_DBTYPE == DBTYPE_MYSQL) {
+
+ q("ALTER TABLE item DROP INDEX title");
+ q("ALTER TABLE item DROP INDEX body");
+ q("ALTER TABLE item DROP INDEX allow_cid");
+ q("ALTER TABLE item DROP INDEX allow_gid");
+ q("ALTER TABLE item DROP INDEX deny_cid");
+ q("ALTER TABLE item DROP INDEX deny_gid");
+ q("ALTER TABLE item DROP INDEX item_flags");
+ q("ALTER TABLE item DROP INDEX item_restrict");
+ q("ALTER TABLE item DROP INDEX aid");
+
$r = q("ALTER TABLE item
DROP INDEX item_private,
ADD INDEX uid_item_private (uid, item_private),