IPS4 importer: custom user fields imported without a title

[Chris D]

Affected version

1.5.latest

A customer has reported via a ticket that a recent import from IPS 4.6 has resulted in some custom fields being imported with an empty title.

This affects the custom fields listing where the cells/columns are collapsed and out of position because there is no text/description.



In case it matters, the `field_id`s imported take the format of 1633462370_4. I'm unsure whether that is a user chosen ID, automatically generated or something we've chosen as a fallback but worth checking in case it has affected phrase creation somewhere. Alternatively, we may just be failing to get the correct language string out of the source database.

 

[K a M a L]

some user groups too

 

[K a M a L]

forums as well

 

[K a M a L]

SELECT ugroup.*, lang.word_custom AS g_title
                FROM core_groups AS ugroup
                LEFT JOIN core_sys_lang_words AS lang ON
                    (lang.lang_id = 1 AND lang.word_key = CONCAT('core_group_', ugroup.g_id))
                LEFT JOIN core_moderators AS moderator ON
                    (ugroup.g_id = moderator.id AND moderator.type = 'g')
                ORDER BY ugroup.g_id

word_custom needs to be replaced with word_default and used only when it is not empty .. in multiple locations
something like

SELECT ugroup.*,  IF(LENGTH(lang.word_custom)>0, lang.word_custom, lang.word_default) AS g_title

FROM core_groups AS ugroup

LEFT JOIN core_sys_lang_words AS lang ON

   (lang.lang_id = 1 AND lang.word_key = CONCAT('core_group_', ugroup.g_id))

LEFT JOIN core_moderators AS moderator ON

   (ugroup.g_id = moderator.id AND moderator.type = 'g')

ORDER BY ugroup.g_id