Home » Authentication » LiveUser » Bug #2064

[2004-08-05 12:13 UTC] worker at mompopmedia dot com

Description:
------------
In order to support Oracle 8i (if that is desirable), INNER JOIN queries need to be rewritten as such (replace INNER JOIN wih comma, and ON with WHERE):

$query = '
SELECT
R.right_id,
U.right_level
FROM
'.$this->prefix.'rights R,
'.$this->prefix.'userrights U
WHERE
R.right_id=U.right_id
AND
U.perm_user_id='.$this->dbc->quote($this->permUserId, 'integer');

INNER JOINS are used in the Perm Medium and Simple containers for medium::readUserRights(), medium::readGroups(), simple::readRights()

[2004-11-23 16:22 UTC] smith at backendmedia dot com

This bug has been fixed in CVS.

In case this was a documentation problem, the fix will show up at the
end of next Sunday (CET) on pear.php.net.

In case this was a pear.php.net website problem, the change will show
up on the website in short time.

Thank you for the report, and for helping us make PEAR better.

Please have a look in the LiveUser and LiveUser_Admin CVS dir. We have refactored the entire storage layer of the permission containers. Please note however that the work is still in progress and that there have been changes in the config layout. The example4 and example2 in the client have been updated accordingly.