[TYPO3-core] FYI #13464: ORA-00920: invalid relational operator in module statistics [indexed_search]

[Xavier Perseguers]

Hi,

FYI this patch was committed as nobrainer.

- Trunk (rev. 6887)
- 4-3 (rev. 6888)

Type: Bugfix

Branches: trunk, 4-3

Bugtracker reference:
http://bugs.typo3.org/view.php?id=13464

Problem:
When using backend module statistics (modfunc2), an error is silently logged in DBAL debug log, if debug is activated. The module itself seems to work as expected though.

Invalid query that is logged is:

SELECT "uid", "title" FROM "pages" WHERE "pid" = 1 AND "doktype" IN (1,2,5,7) AND "deleted" = 0 AND 1

This "AND 1" fails as it should be written "AND 1=1" to be not only compatible with MySQL.

Problem is related to the perms_clause passed to t3lib_tsfeBeUserAuth (line 353, method extGetTreeList) which performs query:

$GLOBALS['TYPO3_DB']->exec_SELECTquery('uid,title', 'pages', 'pid=... AND ' . $perms_clause

This faulty $perms_clause argument comes from modfunc2...



As this was really obvious, I committed right away.

Cheers

-- 
Xavier Perseguers
http://xavier.perseguers.ch/en
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: 13464.diff
URL: <http://lists.typo3.org/pipermail/typo3-team-core/attachments/20100208/6dcfb309/attachment.txt>