Duplicate Links for Favorited Contacts

[Dan25]

Hello,

I am having an issue where when I favorite a contact using the star icon next to their name, the name of that person appears twice in the favorites list. See pic:

I have tried clearing my cache folder, Quick Repairing, messing with some php files of the Favorites module, and verifying no duplicate record exist in the database but the issue persists.

When I create a new user and favorite them, they only appear as one link. But if I unfavorite them and favorite again they appear as two. So it seems both old and new contacts are affected by this.

SuiteCRM Version used: 7.11.20
Browser name and version: Chrome version 93.0.4577.63 (Official Build)(64-bit)
Environment name and version: Microsoft SQL Server, PHP 7.3.26, been running SCRM for 8+ months
Operating System and version: Windows Server 2019 Standard build 17763

[jessica1]

It’s Default Issue in SuiteCRM 7.11.x Versions. Once you click on the Favourite from the particular record then it’ll add the two entries of Favourite in the database for that Record.

For Solved the Duplicate Favourites Record need to change in Query:

File Path: modules/Favorites/Favorites.php

Function Name: getCurrentUserSidebarFavorites()

[Dan25]

Thank you for the screenshot. I checked against the DB and it was creating 2 DB entries when selecting a contact as ‘favorite.’ I applied the code change and that fixed the DB and it only creates one entry now. However, now I don’t see the favorited users on the sidebar at all. Have you heard of that behavior before?
Screenshots:
Before:

After:

Thank you

[jessica1]

The solution which we have given is the Display only one entry on the sidebar for favorite Contact if DB contains the two Entries for the same Contact. The function shown in the screenshot is responsible for displaying the Favorite Contact on the sidebar. We didn’t face the problem which you’re saying after applying changes which we suggested.