Bug #8424

incorrect handling of single column joins

Details

Submitted	2006-08-13 12:48 UTC
From	richard dot udo at gmail dot com
Assigned	lsmith
Status	Closed
Package	LiveUser_Admin
PHP Version	5.1.4
OS	Winxp
Roadmaps	(Not assigned)

Comments

[2006-08-13 12:48 UTC] richard dot udo at gmail dot com

Description:
------------
LiveUser_Admin / LiveUser
------------------------------

Couldnt work out a way to join multiple tables when retrieving users. Initially the user id colum of one table was authuserid liveuser_users and auth_user_ud in liveuser_perm_users tables. So i tried to a join on liveuser_users.authuserid and liveuser_perm_users.auth_user_id without much luck.

From the code i investigated .... Admin/Storage/SQL.php ....

around line 796

>>>>>>>>>>
$filters[] = $this->prefix.$this->alias[$root_table].'.'.$this->tables[$root_table]['joins'][$table].' = '.
$this->prefix.$this->alias[$table].'.'.$this->tables[$root_table]['joins'][$table];
<<<<<<<<<<<<<<<<<<<<<

it doesnt look like this is possibe