Issue Feature Closed

#15112Tools->DB check improvements

Kirill Klimov 10/19/05, 12:43 updated 04/09/25, 20:59

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)

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.

History 9

  1. Kirill Klimov commented 04/18/06, 14:05

    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…

  2. Alexander Opitz commented and changed status New Needs Feedback target version TYPO3 Version 3.8.0 3.8 PHP Version 4 07/09/13, 10:07

    Hi,

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

  3. d.ros no-lastname-given commented 07/22/13, 17:50

    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

  4. Alexander Opitz changed status Needs Feedback New 07/23/13, 14:13

  5. Mathias Schreiber changed target version 11/24/15, 22:48

  6. Riccardo De Contardi changed category 03/19/16, 19:26

  7. Stefan Weil commented 01/12/17, 21:41

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

    This is still an issue with TYPO3 7.6.15.

  8. Riccardo De Contardi commented 08/15/23, 20:31

    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.

  9. Georg Ringer commented and changed status New Closed 04/09/25, 20:59

    With #97151 the module “Database Relations” has been removed. therefore closing the issue.

    I suggest looking at https://github.com/lolli42/dbdoctor which is a far better way to analyze + fix problematic records in the DB.