[TYPO3-core] RFC #15001: Bugfix: It is not possible to search for '%' or '_' inside the Backend

caspar at gosign.de caspar at gosign.de
Mon Jul 5 00:46:55 CEST 2010


This is an SVN patch request.

Type: Performance

Bugtracker references:
http://bugs.typo3.org/view.php?id=15001

Branches:
TYPO3_4-2, TYPO3_4-3, TYPO3_4-4, Trunk

Problem:
Neither with the search-button in the Backend-Toolbar, nor within the
Admin-Tool 'DB check' with the 'full search' function, it is possible to
search for the chars '%' and '_'.
Both functions does not escape the named chars for using inside the
like-query, so they are interpreted as wildcards by sql.
Additionally the Toolbar-search does not use the function
t3lib_db->searchQuery, which should be used for dbal support.

Solution:
adding t3lib_db->escapeStrForLike into t3lib_db->searchQuery
using t3lib_db->searchQuery inside the Toolbar-search (class.db_list.inc)

Caspar
-------------- next part --------------
A non-text attachment was scrubbed...
Name: bug_15001.patch
Type: application/octet-stream
Size: 1268 bytes
Desc: not available
URL: <http://lists.typo3.org/pipermail/typo3-team-core/attachments/20100705/b0be49b9/attachment-0001.obj>


More information about the TYPO3-team-core mailing list