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

[Karsten Dambekalns]

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, 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)';

Otherwise this error occurs:
  ERROR 1054 (42S22): Unknown column 'ses_backuserid' in 'on clause'


Other than that: +1

Regards,
Karsten
-- 
Karsten Dambekalns
Gimme Five!
http://typo3.org/gimmefive


-------------- next part --------------
A non-text attachment was scrubbed...
Name: PGP.sig
Type: application/pgp-signature
Size: 304 bytes
Desc: This is a digitally signed message part
Url : http://lists.netfielders.de/pipermail/typo3-team-core/attachments/20061030/787b8002/attachment.pgp