[TYPO3-core] RFC: who-is-online for BE

[Martin Kutschker]

Karsten Dambekalns schrieb:
> Hi.
> 
> Aside from the suggested change to the SU user display, I found one  
> issue with this patch. It occurs only with MySQL 5.0.13 and above and  
> has to do with the way tables are handled,

Found that one only yesterday. Thanx for testing.

  More information can be
> found at
>  http://bugs.mysql.com/bug.php?id=13551
> 
> Simply put, this line:
> 
>> $from_table = 'be_sessions, be_users u LEFT OUTER JOIN be_users bu  ON 
>> (ses_backuserid=bu.uid)';
> 
> needs to be rewritten to (note the parenthesis):
>  $from_table = '(be_sessions, be_users u) LEFT OUTER JOIN be_users  bu 
> ON (ses_backuserid=bu.uid)';

Ah. I simply changed the order of be_sessions and be_users (it doesn't 
really matter):

be_users u, be_sessions  LEFT OUTER JOIN be_users bu ON (ses_backuserid=bu.uid)

Masi