#5266 - Database integrity check may need to be smarter about indexes

  • By
  • Added
  • 6 views
Identifier #5266
Issue type Minor issue (breaks specific functionality)
Title Database integrity check may need to be smarter about indexes
Status Completed
Handling member Chris Graham
Addon General / Uncategorised
Description I created a custom profile field with a paragraph of translatable/comcode text, and the database integrity check came up with the following:

ALTER TABLE cms11_f_member_custom_fields ADD FULLTEXT field_31 (field_31);

Likely the index was not added by Composr (I was able to manually add it myself) for performance reasons. The integrity check needs to be smarter about this because it will not check meta_indices when it returns these types of issues.
Steps to reproduce

Funded? No
The system will post a comment when this issue is modified (e.g., status changes). To be notified of this, click "Enable comment notifications".

Rating

Unrated