#64012extra work for categories after migrating/splitting sys_file into sys_file + sys_file_metadata
Description
after migrating an 6.1.x instance with media-extension to 6.2
the category-relations for the files defined in the media-extension are gone.
can someone confirm if this is the right way to get them back?
(it seems to work, but I’m not sure whether this is the right way)
# extra work for sys_category_record_mm after
# migrating/splitting sys_file into sys_file + sys_file_metadata
INSERT INTO sys_category_record_mm (uid_local, uid_foreign, tablenames, sorting, sorting_foreign, fieldname)
SELECT sys_category_record_mm.uid_local,
sys_file_metadata.uid,
'sys_file_metadata',
sys_category_record_mm.sorting,
sys_category_record_mm.sorting_foreign,
'categories'
FROM sys_category_record_mm, sys_file_metadata
WHERE sys_category_record_mm.tablenames = 'sys_file'
AND sys_category_record_mm.fieldname = ''
AND sys_category_record_mm.uid_foreign = sys_file_metadata.file
# clean up / remove obsolete entries
DELETE FROM sys_category_record_mm
WHERE tablenames = 'sys_file'
AND fieldname = ''Reviews 0
No change resolves or names this issue in its commit message, and no comment links one.