Package home | Report new bug | New search | Development Roadmap Status: Open | Feedback | All | Closed Since Version 0.4.0
Bug #8424 incorrect handling of single column joins
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)    
Subscription  


 [2006-08-13 12:48 UTC] richard dot udo at gmail dot com (Richard)
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

Comments

 [2006-08-13 13:19 UTC] User who submitted this comment has not confirmed identity
If you submitted this note, check your email.If you do not have a message, click here to re-send
MANUAL CONFIRMATION IS NOT POSSIBLE.  Write a message to pear-dev@lists.php.net
to request the confirmation link.  All bugs/comments/patches associated with this

email address will be deleted within 48 hours if the account request is not confirmed!
 [2006-08-18 09:59 UTC] User who submitted this comment has not confirmed identity
If you submitted this note, check your email.If you do not have a message, click here to re-send
MANUAL CONFIRMATION IS NOT POSSIBLE.  Write a message to pear-dev@lists.php.net
to request the confirmation link.  All bugs/comments/patches associated with this

email address will be deleted within 48 hours if the account request is not confirmed!