Bug #22146

Full search causes error if TCA has tables without any columns

Added by Fabrizio Branca almost 10 years ago. Updated over 9 years ago.

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

0%

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

Description

Problem:
If a table is defined in TCA without any columns (which is the case in rsaauth) the full search creates a wrong query which causes an error.
Wrong query:
SELECT COUNT FROM tx_rsaauth_keys WHERE (tx_rsaauth_keys. LIKE '%searchword%')

Solution:
Skip tables that have empty column arrays

(issue imported from #M13591)

13591.patch View (486 Bytes) Administrator Admin, 2010-02-19 18:22


Related issues

Duplicates TYPO3 Core - Bug #22077: Full search issues invalid db query if TCA has tables without configured columns Closed 2010-02-08

History

#1 Updated by Benni Mack almost 10 years ago

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

Also available in: Atom PDF