set user default role fail

[pravin.agham]

Hi

http://www.sugarcrm.com/forums/showthread.php?t=38806

I did the above changes but I got following error in php error log:

Call to a member function add() on a non-object in

and on suger Log I got folowing error-

Error fetching relationship from cache acl_roles_users

I did all repair options

I am using 5.2o version.

also the user list sub panel not pop up in Role module!!!

Please help me.

Regards,
Pravin

[kuske]

As the solution of andopes works fine, I suppose there is a little typo error in your code.
Just post the code of your solution here and perhaps we can find the problem together.

[pravin.agham]

Here is my code- Same as the andopes gives.

logic hook-

 <?php
// Do not store anything in this file that is not part of the array or the hook version.  This file will    
// be automatically rebuilt in the future. 
$hook_version = 1; 
$hook_array = Array(); 
// position, file, function 
$hook_array['before_save'] = Array(); 
$hook_array['before_save'][] = Array(2, 'addInProfile', 'custom/modules/Users/UserLogicHook.php','UserLogicHook', 'addInProfile'); 
?>  

UserLogicHook.php

 <?php
if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point');
 
class UserLogicHook {
    function addInProfile(&$focus, $event, $arguments) {
        $role_name = "test100";
 
        $query = "SELECT id FROM users WHERE id = '{$focus->id}'";
        $result = $focus->db->query($query, true);
 
        if($focus->db->getRowCount($result) == 0) {
            $query = "SELECT id FROM acl_roles WHERE name = '$role_name'";
            $result = $focus->db->query($query, true);
 
            if($focus->db->getRowCount($result) == 1) {
                $row = $focus->db->fetchByAssoc($result);
                $focus->load_relationship('aclroles');
                $focus->aclroles->add($row['id']); //this line gives error
        $bean->new_with_id=true;
        
                require_once('modules/ACL/install_actions.php');
            } else {
                sugar_die("Role test100 does not exist! Contact the system administrator");
            }
        }
    }
}
?>  

This solution works fine on other version. I tries it on sugar 6. I think I am having problem In my code or some relation ship issue because in role management the users list is not displayed.it may have some relationship issue!!
Reply soon please

Regards,
Pravin

[kuske]

I copied your code to my custom/modules/Users directory and it works fine

I tested it in 6.0.0 and in 6.1.0, both version work.

Are alle filenames and directorynames with correct upper and lower cases?
custom/modules/Users/logic_hooks.php
custom/modules/Users/UserLogicHook.php

Did you try to set the log level to debug and did you look to the sugarcrm.log file to check it for any errors?

[pravin.agham]

yes. I also tested in all versions and going well. I am using 5.2o version.

And I also checked the php error logs and got following error.
Call to a member function add() on a non-object in ........{sugarpath}

and in suger Log I got following log-

Error fetching relationship from cache acl_roles_users


I guess it an problem of relationship..


Thanks
PRavin

[kuske]

It seems that your installation is defective.
This method add must exist even in 5.2.0

But you can solve your problem if you create the ACL record by yourself.
Just use the following hook code:

 <?php 
if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point'); 
class UserLogicHook { 
    function addInProfile(&$focus, $event, $arguments) { 
        $role_name = "test100"; 
        $query = "SELECT id FROM users WHERE id = '{$focus->id}'"; 
        $result = $focus->db->query($query, true); 
        if($focus->db->getRowCount($result) == 0) { 
           
            $query = "INSERT INTO acl_roles_users ".
                     "(id,role_id,user_id,date_modified,deleted) ".
                     "VALUES ".
                     "( uuid(),".
                     "  (SELECT id FROM acl_roles WHERE name = '".$role_name."'),".
                     "  '".$focus->id."',".
                     "  now(),".
                     "  0 ".
                     ")";
            $focus->db->query($query, true); 
        } 
    } 
} 
?>  

[pravin.agham]

Thanks!! It works.

and yes I guess my installation having problem.But how could I overcome my problem.Its already been lots of development did insight.

Why I not able to seen the User list under role management.(Role detail view).

I got relationship error log in sugarcrm

"Mon Dec 6 17:52:18 2010 [3343][1][FATAL] Missing relationship definition acl_roles_users. skipping users subpanel "


Can you guess??

Thanks for the solution!!

Regards,
Pravin