[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
Fri Feb 26 15:34:27 CET 2010


Hey,

Christian Kuhn wrote:
> 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

This issue was handled by #13591, so this one is dropped now.


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

This should be handled throuphout the whole module in a separate issue.

Regards
Christian


More information about the TYPO3-team-core mailing list