diff options
author | Steve Clay <steve@mrclay.org> | 2013-05-17 17:15:53 -0700 |
---|---|---|
committer | Steve Clay <steve@mrclay.org> | 2013-05-17 17:15:53 -0700 |
commit | 83444eaaa606dbb89e8d8e6aa014490e9963f9d7 (patch) | |
tree | 164320ee78bb36d409eb0b66d5464c4e97122746 /engine/lib | |
parent | bf47c4ef15a470f799faa1ddb6989bf75ebdcf31 (diff) | |
parent | 4c45640a3327aea985b383dcbecc5a439674f97c (diff) | |
download | elgg-83444eaaa606dbb89e8d8e6aa014490e9963f9d7.tar.gz elgg-83444eaaa606dbb89e8d8e6aa014490e9963f9d7.tar.bz2 |
Merge pull request #5499 from cash/group_fulltext_index
Fixes #5479 adds group full text index if missing
Diffstat (limited to 'engine/lib')
-rw-r--r-- | engine/lib/upgrades/2013051700-1.8.15-add_missing_group_index-52a63a3a3ffaced2.php | 28 |
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'); + } +} |