Problem with the getRights function
"Christoph Pinkl" <[email protected]> Sat, 19 Nov 2005 10:03:08 +0100
| Newsgroups | gmane.comp.php.pear.liveuser |
|---|---|
| Message-ID | <003601c5ece8$102560a0$9900a8c0@laptop> |
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"
}
}