Project

General

Profile

Actions

Feature #15112

open

Tools->DB check improvements

Added by Kirill Klimov about 19 years ago. Updated over 1 year ago.

Status:
New
Priority:
Should have
Assignee:
-
Category:
Backend User Interface
Start date:
2005-10-19
Due date:
% Done:

0%

Estimated time:
PHP Version:
Tags:
Complexity:
Sprint Focus:

Description

Have 2 ideas for improving "Relations" part:

1. "Group fields" checks.
For now it looks like this:
---
There are 1 records pointing to this missing or deleted record; [tt_content]147
There are 18 records pointing to this missing or deleted record; [tt_content]148
There are 5 records pointing to this missing or deleted record; [tt_content]839
There are 1 records pointing to this missing or deleted record; [fe_groups]1
---
so it give information about missing records. Could be nice also to add information about record pointing to this missing record, because exactly this place should be fixed (if deletion was correct). For now, finding these records that point to deleted ones could be not obvious - so let's add that info.

2. "Files with no references at all (delete them!):" checks.
Suggest to change title at least, because for now this tool lists some files for deletion that should not be deleted !!!
I've found 2 situations when it is wrong:
2.1 It lists files that has reference from other file, but not from DB.
For example, in my html template I'm refer to image. This image would be listed in the list for deletion.
2.2 It lists files that has reference from templavoila flexible content element.

(issue imported from #M1675)


Related issues 3 (0 open3 closed)

Related to TYPO3 Core - Feature #48933: Admin Tools > DB-CheckClosed2013-06-07

Actions
Related to TYPO3 Core - Feature #54075: DB Check - Make csv delimiter configurableClosed2013-11-29

Actions
Related to TYPO3 Core - Bug #16608: DB Check > Relations should output more detailsClosed2006-09-30

Actions
Actions #1

Updated by Kirill Klimov over 18 years ago

This is still relevant in TYPO3 4.0
With something like
There are 1 records pointing to this missing or deleted record; [fe_groups]1
it is really hard to guess where problem should be fixed...

Actions #2

Updated by Alexander Opitz over 11 years ago

  • Status changed from New to Needs Feedback
  • Target version deleted (0)
  • TYPO3 Version changed from 3.8.0 to 3.8
  • PHP Version deleted (4)

Hi,

as this issue is very old. Does the problem still exists within newer versions of TYPO3 CMS (4.5 or 6.1)?

Actions #3

Updated by d.ros no-lastname-given over 11 years ago

Yes and no . . . There´s still no solution for deleting obsolete references ->

In 6.1.1

There are 30 records pointing to this missing or deleted record; [tt_content][16]
There are 2 records pointing to this missing or deleted record; [tt_content][20]
There are 1 records pointing to this missing or deleted record; [tt_content][40]
There are 20 records pointing to this missing or deleted record; [tt_content][53]
There are 1 records pointing to this missing or deleted record; [tt_content][56]

Cheers David

Actions #4

Updated by Alexander Opitz over 11 years ago

  • Status changed from Needs Feedback to New
Actions #5

Updated by Mathias Schreiber about 9 years ago

  • Target version set to Candidate for Major Version
Actions #6

Updated by Riccardo De Contardi over 8 years ago

  • Category set to Backend User Interface
Actions #7

Updated by Stefan Weil almost 8 years ago

See also https://forge.typo3.org/issues/16608.

This is still an issue with TYPO3 7.6.15.

Actions #8

Updated by Riccardo De Contardi over 1 year ago

The interface is still untouched on TYPO3 13.0.0-dev

DB Check > Database relations tells you about "X records pointing to this missing or deleted record" but not where these faulty relations are.

Actions

Also available in: Atom PDF