Bug #87610

Filelist Search - Add constraint to avoid searching of records marked as missing.

Added by Ricky Mathew 3 months ago. Updated 4 days ago.

Status:
Under Review
Priority:
Must have
Assignee:
-
Category:
File Abstraction Layer (FAL)
Target version:
Start date:
2019-02-01
Due date:
% Done:

0%

TYPO3 Version:
9
PHP Version:
7.2
Tags:
Complexity:
easy
Is Regression:
Sprint Focus:

Description

The filelist search now fetches all records except deleted and hidden on a matching string.It should avoid searching for records marked as missing, since those fetched missing records leads to Folder not found or File not found Exceptions like in the following screenshot.

As a work around i just added the 'missing = 0' constraint at the end of findBySearchWordInMetaData() in TYPO3\CMS\Core\Resource\Index\FileIndexRepository class

$queryBuilder->andWhere(
                $queryBuilder->expr()->eq($sysFileTableName.'.missing', $queryBuilder->createNamedParameter(0, \PDO::PARAM_INT))
        );
        $result = $queryBuilder->execute();
        $fileRecords = [];

If this workaround feels sensible can someone please push it to the gerrit review?

file_not_found.png View (173 KB) Ricky Mathew, 2019-02-01 07:42

History

#1 Updated by Guido Schmechel about 2 months ago

  • Assignee set to Helmut Hummel

https://review.typo3.org/c/Packages/TYPO3.CMS/+/58985 Helmut works on a complete new approach. Maybe he can say something about the current state?

Basically, I'm with you and find that the problem should be solved even for 8.7.

#2 Updated by Gerrit Code Review about 2 months ago

  • Status changed from New to Under Review

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

#3 Updated by Helmut Hummel about 2 months ago

  • Status changed from Under Review to New
  • Assignee deleted (Helmut Hummel)

I created a patch already

https://review.typo3.org/#/c/Packages/TYPO3.CMS/+/58985/

This tackles a whole lot more than just missing files, and already works on a production system in one of my projects like that.

#4 Updated by Gerrit Code Review about 2 months ago

  • Status changed from New to Under Review

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

#5 Updated by Gerrit Code Review about 2 months ago

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

#6 Updated by Gerrit Code Review about 2 months ago

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

#7 Updated by Gerrit Code Review 5 days ago

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

#8 Updated by Gerrit Code Review 5 days ago

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

#9 Updated by Gerrit Code Review 5 days ago

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

#10 Updated by Gerrit Code Review 5 days ago

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

#11 Updated by Gerrit Code Review 4 days ago

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

#12 Updated by Gerrit Code Review 4 days ago

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

#13 Updated by Gerrit Code Review 4 days ago

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

#14 Updated by Gerrit Code Review 4 days ago

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

Also available in: Atom PDF