[BUGFIX] Use BackendUtility::deleteClause in LinkAnalyzer 75/48575/2
authorGeorg Ringer <georg.ringer@gmail.com>
Tue, 14 Jun 2016 13:52:13 +0000 (15:52 +0200)
committerFrank Naegler <frank.naegler@typo3.org>
Mon, 20 Jun 2016 08:04:08 +0000 (10:04 +0200)
To avoid wrong sql statements the method BackendUtility::deleteClause
must be used.

Resolves: #76628
Releases: master, 7.6
Change-Id: Ida8165b501c4898d2b79586710b2921f47d6963f
Reviewed-on: https://review.typo3.org/48575
Reviewed-by: Wouter Wolters <typo3@wouterwolters.nl>
Reviewed-by: Nicole Cordes <typo3@cordes.co>
Tested-by: Nicole Cordes <typo3@cordes.co>
Reviewed-by: Joerg Boesche <typo3@joergboesche.de>
Tested-by: Joerg Boesche <typo3@joergboesche.de>
Reviewed-by: Frank Naegler <frank.naegler@typo3.org>
Tested-by: Frank Naegler <frank.naegler@typo3.org>
typo3/sysext/linkvalidator/Classes/LinkAnalyzer.php

index 7fc3e6f..a732af4 100644 (file)
@@ -145,10 +145,11 @@ class LinkAnalyzer
             // Traverse all configured tables
             foreach ($this->searchFields as $table => $fields) {
                 if ($table === 'pages') {
-                    $where = 'deleted = 0 AND uid IN (' . $this->pidList . ')';
+                    $where = 'uid IN (' . $this->pidList . ')';
                 } else {
-                    $where = 'deleted = 0 AND pid IN (' . $this->pidList . ')';
+                    $where = 'pid IN (' . $this->pidList . ')';
                 }
+                $where .= BackendUtility::deleteClause($table);
                 if (!$considerHidden) {
                     $where .= BackendUtility::BEenableFields($table);
                 }