Make a quick vote šŸ—³ ļøHow do you refer to SuiteCRM extensions: add-ons or plug-ins? Click here to have your say šŸ‘ˆ

Duplicate Links for Favorited Contacts

SuiteCRM Forum - English Language SuiteCRM General Discussion
#1

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:

image

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

#2

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()

986Ɨ408 47.6 KB

#3

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:

image
image1034Ɨ141 5.71 KB

image

After:

image
image1029Ɨ110 4.8 KB

image
image233Ɨ599 5.8 KB

Thank you

#4

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.

#5

That proposed change causes this error in the logs:

[FATAL]  Query Failed: SELECT parent_id, parent_type FROM favorites WHERE assigned_user_id = '1' AND deleted = 0 GROUP BY parent_id ORDER BY date_entered DESC
: MySQL error 1055: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'suitecrm.favorites.parent_type' 
which is not functionally dependent on columns in GROUP BY clause; 
this is incompatible with sql_mode=only_full_group_by

That depends on a MySQL option, maybe thatā€™s why the behaviour is different for the two of you.

Maybe itā€™s better to tweak the query instead of starting to change MySQL optionsā€¦ what exactly is the idea behind that ā€œGROUP BYā€? Iā€™m just trying to understand.

EDIT: This fixed query seems to work:

        if ($id) {
            $idQuote = $db->quote($id);
            $query = "SELECT parent_id, parent_type FROM favorites WHERE assigned_user_id = '" .
                    $currentUserIdQuote . "' AND parent_id = '" . $idQuote .
                    "' AND deleted = 0 GROUP BY parent_id, parent_type ORDER BY MAX(date_entered) DESC";
        } else {
            $query = "SELECT parent_id, parent_type FROM favorites WHERE assigned_user_id = '" .
                    $currentUserIdQuote . "' AND deleted = 0 GROUP BY parent_id, parent_type ORDER BY MAX(date_entered) DESC";
        }

But I am afraid this is just a dirty hack to workaround the issue. The real issue is that the Favorites are created twice, I see there are two (repeated) event handlers attached to the star buttonā€¦ and I see other repeated buttons on my screen. Iā€™d love to find out the root cause of thisā€¦

#6

For reference, it seems somebody already opened an issue for this: