SubGroup Exemple
Nicolas Pestana <[email protected]> Sat, 19 Nov 2005 12:09:05 +0100
| Newsgroups | gmane.comp.php.pear.liveuser |
|---|---|
| Message-ID | <[email protected]> |
Hi, Can someone send me link or code in order to try to use subgroup in LiveUser ? Thanks. -- ___ Nicolas PESTANA |_ | Zeni Corporation - Integrated Net Maker - http://zeni.fr / / Tél: +33(0)3.44.62.88.88 - Fax : 03.44.57.35.55 |___| GSM: +33(0)6.33.01.12.46 [email protected] wrote: > Send LiveUser mailing list submissions to > [email protected] > > To subscribe or unsubscribe via the World Wide Web, visit > http://mailman.21st-hq.de/mailman/listinfo/liveuser > or, via email, send a message with subject or body 'help' to > [email protected] > > You can reach the person managing the list at > [email protected] > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of LiveUser digest..." > > > Today's Topics: > > 1. Problem with the getRights function (Christoph Pinkl) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Sat, 19 Nov 2005 10:03:08 +0100 > From: "Christoph Pinkl" <[email protected]> > Subject: [LiveUser] Problem with the getRights function > To: "LiveUser-DevList" <[email protected]> > Message-ID: <003601c5ece8$102560a0$9900a8c0@laptop> > Content-Type: text/plain; charset="iso-8859-1" > > I've the a Problem with the Complex Perm Container. > I've tried to request the Rights and other information like the area_define_name for one User. > But as result there was false; > In the Error Stack stood a wrong SELECT Command is the reason. > > > $params = array( > 'fields' => array( > 'right_id', > 'right_define_name', > 'area_id', > 'area_define_name' > ), > 'filters' => array( > 'perm_user_id' => $_REQUEST["user_id"] > ) > ); > > $user_rights = $LUA->perm->getRights($params); > > var_dump($LUA->getErrors()); > > The output looks like: > [0]=> > &array(7) { > ["code"]=> > int(-4) > ["params"]=> > array(1) { > ["reason"]=> > string(889) "MDB2 Error: -[Last query: SELECT liveuser_rights.right_id AS right_id, liveuser_rights.right_define_name AS right_define_name, liveuser_rights.area_id AS area_id, liveuser_areas.area_define_name AS area_define_name > FROM liveuser_rights, liveuser_userrights, liveuser_areas > WHERE liveuser_userrights.perm_user_id = 1 > AND liveuser_rights.area_id = liveuser_areas.area_id > AND liveuser_areas.application_id = liveuser_applications.application_id > AND liveuser_applications.application_id = liveuser_translations.section_id > AND liveuser_translations.section_type = 1 > AND liveuser_areas.area_id = liveuser_translations.section_id > AND liveuser_translations.section_id = liveuser_applications.application_id > AND liveuser_rights.right_id = liveuser_userrights.right_id] > [Native code: 1109] > [Native message: Unknown table 'liveuser_applications' in where clause] > " > } > ["package"]=> > string(14) "LiveUser_Admin" > ["level"]=> > string(9) "exception" > ["time"]=> > float(1132235908.43) > ["context"]=> > array(4) { > ["file"]=> > string(73) "C:\Programme\apachefriends\xampp\php\pear\LiveUser\Admin\Storage\MDB2.php" > ["line"]=> > int(323) > ["function"]=> > string(8) "queryAll" > ["class"]=> > string(32) "LiveUser_Admin_Perm_Storage_MDB2" > } > ["message"]=> > string(924) "Couldn't create the query, reason: MDB2 Error: -[Last query: SELECT liveuser_rights.right_id AS right_id, liveuser_rights.right_define_name AS right_define_name, liveuser_rights.area_id AS area_id, liveuser_areas.area_define_name AS area_define_name > FROM liveuser_rights, liveuser_userrights, liveuser_areas > WHERE liveuser_userrights.perm_user_id = 1 > AND liveuser_rights.area_id = liveuser_areas.area_id > AND liveuser_areas.application_id = liveuser_applications.application_id > AND liveuser_applications.application_id = liveuser_translations.section_id > AND liveuser_translations.section_type = 1 > AND liveuser_areas.area_id = liveuser_translations.section_id > AND liveuser_translations.section_id = liveuser_applications.application_id > AND liveuser_rights.right_id = liveuser_userrights.right_id] > [Native code: 1109] > [Native message: Unknown table 'liveuser_applications' in where clause] > " > } > [1]=> > &array(7) { > ["code"]=> > int(-4) > ["params"]=> > array(1) { > ["reason"]=> > string(41) "infinite recursion detected: translations" > } > ["package"]=> > string(14) "LiveUser_Admin" > ["level"]=> > string(9) "exception" > ["time"]=> > float(1132235908.43) > ["context"]=> > array(4) { > ["file"]=> > string(72) "C:\Programme\apachefriends\xampp\php\pear\LiveUser\Admin\Storage\SQL.php" > ["line"]=> > int(692) > ["function"]=> > string(16) "createJoinFilter" > ["class"]=> > string(32) "LiveUser_Admin_Perm_Storage_MDB2" > } > ["message"]=> > string(76) "Couldn't create the query, reason: infinite recursion detected: translations" > } > [2]=> > &array(7) { > ["code"]=> > int(-4) > ["params"]=> > array(1) { > ["reason"]=> > string(34) "infinite recursion detected: areas" > } > ["package"]=> > string(14) "LiveUser_Admin" > ["level"]=> > string(9) "exception" > ["time"]=> > float(1132235908.43) > ["context"]=> > array(4) { > ["file"]=> > string(72) "C:\Programme\apachefriends\xampp\php\pear\LiveUser\Admin\Storage\SQL.php" > ["line"]=> > int(692) > ["function"]=> > string(16) "createJoinFilter" > ["class"]=> > string(32) "LiveUser_Admin_Perm_Storage_MDB2" > } > ["message"]=> > string(69) "Couldn't create the query, reason: infinite recursion detected: areas" > } > [3]=> > &array(7) { > ["code"]=> > int(-4) > ["params"]=> > array(1) { > ["reason"]=> > string(34) "infinite recursion detected: areas" > } > ["package"]=> > string(14) "LiveUser_Admin" > ["level"]=> > string(9) "exception" > ["time"]=> > float(1132235908.43) > ["context"]=> > array(4) { > ["file"]=> > string(72) "C:\Programme\apachefriends\xampp\php\pear\LiveUser\Admin\Storage\SQL.php" > ["line"]=> > int(692) > ["function"]=> > string(16) "createJoinFilter" > ["class"]=> > string(32) "LiveUser_Admin_Perm_Storage_MDB2" > } > ["message"]=> > string(69) "Couldn't create the query, reason: infinite recursion detected: areas" > } > [4]=> > &array(7) { > ["code"]=> > int(-4) > ["params"]=> > array(1) { > ["reason"]=> > string(35) "infinite recursion detected: rights" > } > ["package"]=> > string(14) "LiveUser_Admin" > ["level"]=> > string(9) "exception" > ["time"]=> > float(1132235908.43) > ["context"]=> > array(4) { > ["file"]=> > string(72) "C:\Programme\apachefriends\xampp\php\pear\LiveUser\Admin\Storage\SQL.php" > ["line"]=> > int(692) > ["function"]=> > string(16) "createJoinFilter" > ["class"]=> > string(32) "LiveUser_Admin_Perm_Storage_MDB2" > } > ["message"]=> > string(70) "Couldn't create the query, reason: infinite recursion detected: rights" > } > [5]=> > &array(7) { > ["code"]=> > int(-4) > ["params"]=> > array(1) { > ["reason"]=> > string(41) "infinite recursion detected: applications" > } > ["package"]=> > string(14) "LiveUser_Admin" > ["level"]=> > string(9) "exception" > ["time"]=> > float(1132235908.43) > ["context"]=> > array(4) { > ["file"]=> > string(72) "C:\Programme\apachefriends\xampp\php\pear\LiveUser\Admin\Storage\SQL.php" > ["line"]=> > int(692) > ["function"]=> > string(16) "createJoinFilter" > ["class"]=> > string(32) "LiveUser_Admin_Perm_Storage_MDB2" > } > ["message"]=> > string(76) "Couldn't create the query, reason: infinite recursion detected: applications" > } > [6]=> > &array(7) { > ["code"]=> > int(-4) > ["params"]=> > array(1) { > ["reason"]=> > string(34) "infinite recursion detected: areas" > } > ["package"]=> > string(14) "LiveUser_Admin" > ["level"]=> > string(9) "exception" > ["time"]=> > float(1132235908.42) > ["context"]=> > array(4) { > ["file"]=> > string(72) "C:\Programme\apachefriends\xampp\php\pear\LiveUser\Admin\Storage\SQL.php" > ["line"]=> > int(692) > ["function"]=> > string(16) "createJoinFilter" > ["class"]=> > string(32) "LiveUser_Admin_Perm_Storage_MDB2" > } > ["message"]=> > string(69) "Couldn't create the query, reason: infinite recursion detected: areas" > } > [7]=> > &array(7) { > ["code"]=> > int(-4) > ["params"]=> > array(1) { > ["reason"]=> > string(35) "infinite recursion detected: rights" > } > ["package"]=> > string(14) "LiveUser_Admin" > ["level"]=> > string(9) "exception" > ["time"]=> > float(1132235908.42) > ["context"]=> > array(4) { > ["file"]=> > string(72) "C:\Programme\apachefriends\xampp\php\pear\LiveUser\Admin\Storage\SQL.php" > ["line"]=> > int(692) > ["function"]=> > string(16) "createJoinFilter" > ["class"]=> > string(32) "LiveUser_Admin_Perm_Storage_MDB2" > } > ["message"]=> > string(70) "Couldn't create the query, reason: infinite recursion detected: rights" > } > [8]=> > &array(7) { > ["code"]=> > int(-4) > ["params"]=> > array(1) { > ["reason"]=> > string(34) "infinite recursion detected: areas" > } > ["package"]=> > string(14) "LiveUser_Admin" > ["level"]=> > string(9) "exception" > ["time"]=> > float(1132235908.42) > ["context"]=> > array(4) { > ["file"]=> > string(72) "C:\Programme\apachefriends\xampp\php\pear\LiveUser\Admin\Storage\SQL.php" > ["line"]=> > int(692) > ["function"]=> > string(16) "createJoinFilter" > ["class"]=> > string(32) "LiveUser_Admin_Perm_Storage_MDB2" > } > ["message"]=> > string(69) "Couldn't create the query, reason: infinite recursion detected: areas" > } > [9]=> > &array(7) { > ["code"]=> > int(-4) > ["params"]=> > array(1) { > ["reason"]=> > string(35) "infinite recursion detected: rights" > } > ["package"]=> > string(14) "LiveUser_Admin" > ["level"]=> > string(9) "exception" > ["time"]=> > float(1132235908.42) > ["context"]=> > array(4) { > ["file"]=> > string(72) "C:\Programme\apachefriends\xampp\php\pear\LiveUser\Admin\Storage\SQL.php" > ["line"]=> > int(692) > ["function"]=> > string(16) "createJoinFilter" > ["class"]=> > string(32) "LiveUser_Admin_Perm_Storage_MDB2" > } > ["message"]=> > string(70) "Couldn't create the query, reason: infinite recursion detected: rights" > } > } > ------------------------------ > > _______________________________________________ > LiveUser mailing list > [email protected] > http://mailman.21st-hq.de/mailman/listinfo/liveuser > > > End of LiveUser Digest, Vol 34, Issue 12 > ****************************************