[TYPO3-core] FYI72: Fix bug #133457: Failing query in db Check -> full search if a table has no usable colums

Christian Kuhn lolli at schwarzbu.ch
Mon Feb 8 01:36:38 CET 2010


The following patch will be committed do SVN trunk and 4.3 if nobody 
objects:

Type: bugfix

BT: http://bugs.typo3.org/view.php?id=13457

Branches: trunk, 4.3

Problem:
If a table has no usable columns, fullsearch creates invalid SQL:
SELECT COUNT(*) FROM tx_rsaauth_keys WHERE (tx_rsaauth_keys. LIKE 
'%testme%')

Solution:
Query a table only if at least one columns has been defined in TCA.

How to reproduce:
- Install rsa auth extension
- Use the fulltext seach in db Check module
- Watch a failing query

Notes:
This patch fixes some minor XHTML issues in touched lines, too.

Regards
Christian
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 13457.diff
Type: text/x-patch
Size: 2383 bytes
Desc: not available
URL: <http://lists.typo3.org/pipermail/typo3-team-core/attachments/20100208/cbee7ffa/attachment.bin>


More information about the TYPO3-team-core mailing list