#5348 - seo_meta ftjoin_dmeta_description index: can't be done on longtext field

By PDStig
Added 20th Feb 2023, 11:38 PM
24 views

Identifier	#5348
Issue type	Minor issue (breaks specific functionality)
Title	seo_meta ftjoin_dmeta_description index: can't be done on longtext field
Status	Closed (no changes needed)
Handling member	Deleted
Addon	General / Uncategorised
Description	mysql complains when trying to add meta_description index on seo_meta via database repair tool (it does not specify a key length). I temporarily removed this index from install.php. The general recommendation is that indexes should not be added on BLOB/TEXT fields.
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

Comments

By Guest posted 21st Feb 2023, 10:41 AM

The index is only for when multi-lang-content is on. The fix is for the repair tool to be aware of that (EDIT: I think, although I saw you made a different fix since).

Creation is skipped via this code:
if (($is_full_text) && (multi_lang_content()) && (strpos($db_type, '_TRANS') !== false)) {
return null; // We don't create a full-text index on *_TRANS fields if we are directing through the translate table
}

By Guest posted 21st Feb 2023, 1:07 PM

Actually the solution was different. This occurred during the enable content translation script because the script was altering the database columns before globally enabling multi lang content. As a result, the columns were just getting re-created as longtext when they should have been integer. So I had the script enable multi lang content before altering the database, and that resolved the issue.