Project

General

Profile

Actions
Copy link

Bug #22081

closed

ORA-00920: invalid relational operator in module statistics

Added by Xavier Perseguers almost 15 years ago. Updated about 6 years ago.

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

0%

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

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)

Files

13464.diff (802 Bytes) 13464.diff Administrator Admin, 2010-02-08 17:05
Actions
Copy link
 #1

Updated by Xavier Perseguers almost 15 years ago

Committed to:

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

Actions
Copy link
 #2

Updated by Benni Mack about 6 years ago

  • Status changed from Resolved to Closed
Actions
Copy link

Also available in: Atom PDF