[TYPO3-core] RFC #5120 / #8915: SQL parse error in "Who is online" BE list

[Xavier Perseguers]

Hi,

This is an SVN patch request.

Type: Bugfix in DBAL with a minor update in Core

Bugtracker references:
http://bugs.typo3.org/view.php?id=5120
http://bugs.typo3.org/view.php?id=8915

Requires:
RFC #10411

Branches: trunk

Problem:
When trying to show the "Who is online" list (from User Admin / (function menu)

Solution:
Use an INNER JOIN instead of an implicit CROSS JOIN to link tables be_sessions and be_users.

Additionally, take into account limitation of the Core parser and reverse the comparison operator and remove extra useless parentheses.

This implies that Core's SQL parser is able to parse more than 1 join and as such that patch from RFC #10411 gets committed.

Cheers

-- 
Xavier Perseguers
http://xavier.perseguers.ch/en

One contribution a day keeps the fork away

-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: 8915_v2.diff
URL: <http://lists.typo3.org/pipermail/typo3-team-core/attachments/20091027/32eebcbe/attachment.asc>