Project

General

Profile

Actions

Bug #97775

closed

Rename of directory name in file list results in updating of all related sys_file_metadata

Added by Sybille Peters over 2 years ago. Updated 5 months ago.

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
File Abstraction Layer (FAL)
Target version:
-
Start date:
2022-06-15
Due date:
% Done:

100%

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

Description

In TYPO3 v10. The renaming of a directory took very long and at some point there was an exception related to an UPDATE query on sys_file_metadata. The exception is a different problem, but I was wondering why all sys_file_metadata are updated. Should they not be related to the uid in sys_file and not be concerned about the path at all?

As noted, this causes the renaming of directories to take longer than necessary.

Reproduce

1. check timestamp of a sys_file_metadata record, e.g.

select uid,FROM_UNIXTIME(tstamp),title,file from sys_file_metadata where file=291201;

2. Rename a directory which contains this file

3. check the timestamp again.

Actions #1

Updated by Gerrit Code Review about 1 year ago

  • Status changed from New to Under Review

Patch set 1 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/81046

Actions #2

Updated by Gerrit Code Review about 1 year ago

Patch set 2 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/81046

Actions #3

Updated by Gerrit Code Review about 1 year ago

Patch set 3 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/81046

Actions #4

Updated by Gerrit Code Review about 1 year ago

Patch set 1 for branch 12.4 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/81061

Actions #5

Updated by Oliver Bartsch about 1 year ago

  • Status changed from Under Review to Resolved
  • % Done changed from 0 to 100
Actions #6

Updated by Benni Mack 5 months ago

  • Status changed from Resolved to Closed
Actions

Also available in: Atom PDF