Project

General

Profile

Actions

Bug #22077

closed

Full search issues invalid db query if TCA has tables without configured columns

Added by Christian Kuhn about 14 years ago. Updated almost 14 years ago.

Status:
Closed
Priority:
Should have
Assignee:
Category:
-
Target version:
-
Start date:
2010-02-08
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
4.3
PHP Version:
5.2
Tags:
Complexity:
Is Regression:
Sprint Focus:

Description

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

(issue imported from #M13457)


Files

13457.diff (2.33 KB) 13457.diff Administrator Admin, 2010-02-08 01:30

Related issues 1 (0 open1 closed)

Has duplicate TYPO3 Core - Bug #22146: Full search causes error if TCA has tables without any columnsClosedBenni Mack2010-02-19

Actions
Actions #1

Updated by Benni Mack about 14 years ago

committed to trunk (rev. 7048)
committed to TYPO3_4-3 (rev. 7049)

Actions

Also available in: Atom PDF