Project

General

Profile

Actions

Bug #19073

closed

"List users online" not DBAL compliant - Module crashes

Added by Christian Trabold over 16 years ago. Updated over 14 years ago.

Status:
Closed
Priority:
Should have
Category:
-
Target version:
-
Start date:
2008-07-07
Due date:
% Done:

0%

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

Description

If DBAL-Extension is installed the "List users online"-Feature throws this error:

DBAL fatal error: No handler found in handler_getFromTableList() for: "(be_sessions, be_users u) LEFT OUTER JOIN be_users bu ON (ses_backuserid=bu.uid)" (SQL engine parse ERROR: No table name found as expected in parseFromTables()!: near "(be_sessions, be_users u) LEFT OUTER JOIN be_users")

After that, the module is not accessible anymore until the browser-session has been killed by closing the browser.

I removed "LEFT OUTER JOIN" from the SQL-Statement and all works as expected (see attached patch). Is "LEFT OUTER JOIN" really necessary?

I could not install DBAL in 4.2 to reproduce this with latest version, but the sourcecode is similar in 4.2 compared to 4.1.7.
(issue imported from #M8915)


Files

beuser_mod_index.php.patch (1.26 KB) beuser_mod_index.php.patch Administrator Admin, 2008-07-07 17:59
8915.diff (885 Bytes) 8915.diff Administrator Admin, 2009-10-27 18:31
8915_v2.diff (1.37 KB) 8915_v2.diff Administrator Admin, 2009-10-27 19:21

Related issues 1 (0 open1 closed)

Is duplicate of TYPO3 Core - Bug #17072: DBAL/PostgreSQL: SQL parse error in "Who is online" BE listClosedErnesto Baschny2007-03-03

Actions
Actions #1

Updated by Marc Bastian Heinrichs over 16 years ago

duplicate of #17072

Actions #2

Updated by Xavier Perseguers about 15 years ago

I confirm this still occurs in 4.3. Uploaded patch 8915.diff works if patch for issue #19999 has been committed.

Actions

Also available in: Atom PDF