Bug #100750
closed
Backend search does not work if user has too many searchable webmounts
100%
Description
Info: This affects the search in top-right corner of the backend, after clicking on the "Show all" button, if an editor user has too many searchable webmounts.
The id list returned by typo3_src/typo3/sysext/recordlist/Classes/RecordList/DatabaseRecordList.php->getSearchableWebmounts can contain ids multiple times.
We encountered a problem in a large TYPO3 system where this function returned about 78000 ids instead of about 2300 unique ids for an editor. This led to the error, that the sql query in DatabaseRecordList.php->getTable executed by $queryBuilderTotalItems had too many placeholders.
In my opinion, this bug can be easily fixed, by calling array_unique on the id list before saving it to the runtime cache and returning it from the function.
https://github.com/TYPO3-CMS/recordlist/blob/main/Classes/RecordList/DatabaseRecordList.php#L2860
Updated by Gerrit Code Review about 1 year ago
- Status changed from New to Under Review
Patch set 1 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/78873
Updated by Gerrit Code Review about 1 year ago
Patch set 1 for branch 11.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/+/78874
Updated by Andreas Fernandez about 1 year ago
- Status changed from Under Review to Resolved
- % Done changed from 0 to 100
Applied in changeset 0fd1cfacd20be07bb16ad6232d1a8625bcc1048c.
Updated by Andreas Kienast 10 months ago
- Related to Bug #101200: Still too many searchable webmounts added