aboutsummaryrefslogtreecommitdiff
path: root/engine/lib/upgrades
diff options
context:
space:
mode:
authorcash <cash.costello@gmail.com>2013-05-17 15:44:22 -0400
committercash <cash.costello@gmail.com>2013-05-17 15:44:22 -0400
commit4c45640a3327aea985b383dcbecc5a439674f97c (patch)
tree164320ee78bb36d409eb0b66d5464c4e97122746 /engine/lib/upgrades
parentbf47c4ef15a470f799faa1ddb6989bf75ebdcf31 (diff)
downloadelgg-4c45640a3327aea985b383dcbecc5a439674f97c.tar.gz
elgg-4c45640a3327aea985b383dcbecc5a439674f97c.tar.bz2
Fixes #5479 adds group full text index if missing
Diffstat (limited to 'engine/lib/upgrades')
-rw-r--r--engine/lib/upgrades/2013051700-1.8.15-add_missing_group_index-52a63a3a3ffaced2.php28
1 files changed, 28 insertions, 0 deletions
diff --git a/engine/lib/upgrades/2013051700-1.8.15-add_missing_group_index-52a63a3a3ffaced2.php b/engine/lib/upgrades/2013051700-1.8.15-add_missing_group_index-52a63a3a3ffaced2.php
new file mode 100644
index 000000000..ee99bdbc8
--- /dev/null
+++ b/engine/lib/upgrades/2013051700-1.8.15-add_missing_group_index-52a63a3a3ffaced2.php
@@ -0,0 +1,28 @@
+<?php
+/**
+ * Elgg 1.8.15 upgrade 2013051700
+ * add_missing_group_index
+ *
+ * Some Elgg sites are missing the groups_entity full text index on name and
+ * description. This checks if it exists and adds it if it does not.
+ */
+
+$db_prefix = elgg_get_config('dbprefix');
+
+$full_text_index_exists = false;
+$results = get_data("SHOW INDEX FROM {$db_prefix}groups_entity");
+if ($results) {
+ foreach ($results as $result) {
+ if ($result->Index_type === 'FULLTEXT') {
+ $full_text_index_exists = true;
+ }
+ }
+}
+
+if ($full_text_index_exists == false) {
+ $query = "ALTER TABLE {$db_prefix}groups_entity
+ ADD FULLTEXT name_2 (name, description)";
+ if (!update_data($query)) {
+ elgg_log("Failed to add full text index to groups_entity table", 'ERROR');
+ }
+}