Duplicate Records Display for Auto Create User

[rwoo]

We are running SugarPro patch 5.2.0h using MSSQL on Windows platform...

We've just turned on Auto Create User option with the following additions:

$user->load_relationship('team');
$user->teams->add(1);
$user->load_relationship('aclroles');
$user->aclrules->add(READONLY);

Everything seems to work fine except that when the auto created user logs in, he or she gets everything duplicate in the listview. In another words, he or she gets the duplicate data records for all modules.

Do you have any idea what needs to be fixed or how to debug this issue?

Thanks,
RLW

[rwoo]

FYI -

I commented out the following two lines and cleaned up the team_memberships table, and it worked OK...

$user->load_relationship('team');
$user->teams->add(1);

Even though it looked normal from the console, it created double entries for Global team into the team_memberships table with FALSE explicit_assign record for the user. It looks like the double entries in the team_memberships table for the same Global team caused the duplicate data records to display for all other modules in different views...