Duplicate opportunities for one user

[apinte]

Sugar PRO 5.1b
Ubuntu 8.04, MySQL 5.0.45

Hi,
One of our users has a problem whereby he is seeing duplicate opportunities. Many of the records display 4 times each.and the problem only appears to affect one user.

If we grant administrator privilege to this user, the problem disappears but as soon as we revoke the privilege, the problem reappears.

We have looked at the database and these records do not seem to be duplicated. Other users that have access to the same opportunities do not see them duplicated.

Does anyone have any ideas to help us resolve this problem?

[kuske]

I had a similar problem after upgrade from 451 to 50.
Some of the relation tables had duplicate entries, e.g. accounts_opportunities.

I found them by a

select distinct count(id),account_id, opportunity_id
from accounts_opportunities
where deleted=0
group by account_id, opportunity_id
order by 1 desc

[sugarcane]

Hello apinte,

Try to repair Teams and see if this helps.
Otherwise, check to see if there are duplicate records for the user in Teams_membership table. If so, remove the duplicates

[apinte]

Hello,

Thank you for the replies.

Yes, there were duplicates in the team_membership table.
They were found by

select team_id, user_id from team_memberships where deleted = 0
and user_id = 'id of user' order by team_id, user_id;

The duplicates were then removed and the problem has been resolved.