Issue Bug Closed

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

Sybille Peters 06/15/22, 09:41 updated 07/09/24, 12:46

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.

Reviews 2

History 26

  1. Gerrit Code Review pushed patch set 1 for main to change 81046 status New Under Review 09/18/23, 14:09

  2. Gerrit Code Review pushed patch set 2 for main to change 81046 09/18/23, 15:10

  3. Gerrit Code Review pushed patch set 3 for main to change 81046 09/18/23, 17:14

  4. Gerrit Code Review pushed patch set 1 for 12.4 to change 81061 09/18/23, 21:12

  5. Oliver Bartsch commented and changed status Under Review Resolved done 0 % 100 % 09/18/23, 21:15

    Applied in changeset commit:e0a0643bfa68cb2f6fc7c2425e9858d6bd94a645.

  6. Benni Mack changed status Resolved Closed 07/09/24, 12:46