[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