Project

General

Profile

Actions

Bug #64012

closed

extra work for categories after migrating/splitting sys_file into sys_file + sys_file_metadata

Added by Paolo Panto almost 10 years ago. Updated about 6 years ago.

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
Categorization API
Target version:
-
Start date:
2014-12-21
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
6.2
PHP Version:
Tags:
Complexity:
Is Regression:
No
Sprint Focus:

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 = ''
Actions #1

Updated by Mathias Schreiber almost 10 years ago

  • Status changed from New to Resolved

Hi Paolo,

indeed the name of the reference has changed.
You reverse-engineered it the right way.

Cheers
mathias

Actions #2

Updated by Benni Mack about 6 years ago

  • Status changed from Resolved to Closed
Actions

Also available in: Atom PDF