Project

General

Profile

Actions

Bug #87610

closed

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

Added by Ricky Mathew about 5 years ago. Updated almost 5 years ago.

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

100%

Estimated time:
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?


Files

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

Related issues 3 (0 open3 closed)

Related to TYPO3 Core - Bug #87048: File search searches in forbidden folders => InsufficientFolderAccessPermissionsExceptionClosed2018-11-30

Actions
Related to TYPO3 Core - Bug #89168: File search only accepts single search word AGAINClosedMarkus Klein2019-09-13

Actions
Related to TYPO3 Core - Bug #88175: Exception thrown when searching for files: You are not allowed to access the given folderClosed2019-04-18

Actions
Actions #1

Updated by Guido Schmechel about 5 years 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.

Actions #2

Updated by Gerrit Code Review about 5 years 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

Actions #3

Updated by Helmut Hummel about 5 years 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.

Actions #4

Updated by Gerrit Code Review about 5 years 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

Actions #5

Updated by Gerrit Code Review about 5 years 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

Actions #6

Updated by Gerrit Code Review about 5 years 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

Actions #7

Updated by Gerrit Code Review almost 5 years 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

Actions #8

Updated by Gerrit Code Review almost 5 years 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

Actions #9

Updated by Gerrit Code Review almost 5 years 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

Actions #10

Updated by Gerrit Code Review almost 5 years 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

Actions #11

Updated by Gerrit Code Review almost 5 years 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

Actions #12

Updated by Gerrit Code Review almost 5 years 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

Actions #13

Updated by Gerrit Code Review almost 5 years 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

Actions #14

Updated by Gerrit Code Review almost 5 years 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

Actions #15

Updated by Benni Mack almost 5 years ago

  • Target version changed from next-patchlevel to Candidate for patchlevel
Actions #16

Updated by Gerrit Code Review almost 5 years ago

Patch set 23 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

Actions #17

Updated by Gerrit Code Review almost 5 years ago

Patch set 24 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

Actions #18

Updated by Gerrit Code Review almost 5 years ago

Patch set 25 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

Actions #19

Updated by Gerrit Code Review almost 5 years ago

Patch set 26 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

Actions #20

Updated by Gerrit Code Review almost 5 years ago

Patch set 27 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

Actions #21

Updated by Benni Mack almost 5 years ago

  • Target version changed from Candidate for patchlevel to next-patchlevel
Actions #22

Updated by Gerrit Code Review almost 5 years ago

Patch set 28 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

Actions #23

Updated by Gerrit Code Review almost 5 years ago

Patch set 29 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

Actions #24

Updated by Gerrit Code Review almost 5 years ago

Patch set 29 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

Actions #25

Updated by Gerrit Code Review almost 5 years ago

Patch set 29 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

Actions #26

Updated by Gerrit Code Review almost 5 years ago

Patch set 30 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

Actions #27

Updated by Gerrit Code Review almost 5 years ago

Patch set 31 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

Actions #28

Updated by Gerrit Code Review almost 5 years ago

Patch set 32 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

Actions #29

Updated by Gerrit Code Review almost 5 years ago

Patch set 33 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

Actions #30

Updated by Gerrit Code Review almost 5 years ago

Patch set 34 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

Actions #31

Updated by Gerrit Code Review almost 5 years ago

Patch set 35 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

Actions #32

Updated by Gerrit Code Review almost 5 years ago

Patch set 35 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

Actions #33

Updated by Gerrit Code Review almost 5 years ago

Patch set 36 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

Actions #34

Updated by Gerrit Code Review almost 5 years ago

Patch set 37 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

Actions #35

Updated by Gerrit Code Review almost 5 years ago

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

Actions #36

Updated by Helmut Hummel almost 5 years ago

  • Status changed from Under Review to Resolved
  • % Done changed from 0 to 100
Actions #37

Updated by Benni Mack almost 5 years ago

  • Status changed from Resolved to Closed
Actions #38

Updated by Markus Klein almost 5 years ago

  • Related to Bug #87048: File search searches in forbidden folders => InsufficientFolderAccessPermissionsException added
Actions #39

Updated by Markus Klein over 4 years ago

  • Related to Bug #89168: File search only accepts single search word AGAIN added
Actions #41

Updated by Oliver Hader over 4 years ago

  • Related to Bug #88175: Exception thrown when searching for files: You are not allowed to access the given folder added
Actions

Also available in: Atom PDF