Issue Bug Closed

#22081ORA-00920: invalid relational operator in module statistics

Xavier Perseguers 02/08/10, 16:59 updated 10/02/18, 12:25

Description

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…

(issue imported from #M13464)

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.