#100750Backend search does not work if user has too many searchable webmounts
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
Reviews 5
- 11.5 79563[BUGFIX] Make list of webmount page ids really unique
- 12.4 79534[BUGFIX] Make list of webmount page ids really unique
- main 79560[BUGFIX] Make list of webmount page ids really unique
- 11.5 78874[BUGFIX] Harmonize page ids in Record List search
- main 78873[BUGFIX] Harmonize page ids in Record List search