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"
  }
}