Duplicate entries show up in Activities module

[chriss4242]

Hi,

I am currently starting with Sugar (Community Edition - Version 5.0.0e (Build 3276)).

I am having an issue where some calls show up as duplicate in the call list under Activities.

I have dug a little deeper and found that duplicates don't appear in the calls table and that the behavior appears to be related to the number of users and members selected for the call. I have produced a test case that appears to be 100% repeatable on both my system and the demo system on the sugar.com website. To reproduce:

1) Create a call.
2) Add one extra user and two contacts to the call (Total of two users and two contacts).
3) Save and click on the Activities TAB. The call should be listed twice.
4) If a user or contact is removed from the call, it will again only be listed once from the activities tab.

I found something similar in the wiki: http://www.sugarcrm.com/wiki/index.p...%26_Activities
However this appears to be not related because there is no team_memberships table in the database.

Operating system: Centos 5
PHP: 5.1.6
Database: Mysql 5.0.22
Web: Apache 2.2.3

[DragonflyMaster]

This issue is due to the relationship with contacts; in fact, no matter how many users you refer to, if you add n contacts, you'll get n rows for the same call.
A quick solution is to remove the contact from calls' listview.

[DragonflyMaster]

Another solution that allows keeping the contact field in calls' listview is to edit manual code:
open <sugar-root>/modules/Calls/vardefs.php
and comment out the following code

  'contact_name' => 
  array (
    'name' => 'contact_name',
    'rname' => 'last_name',
    'db_concat_fields'=> array(0=>'first_name', 1=>'last_name'),
    'id_name' => 'contact_id',
    'massupdate' => false,
    'vname' => 'LBL_CONTACT_NAME',
    'type' => 'relate',
    'link'=>'contacts',
    'table' => 'contacts',
    'isnull' => 'true',
    'module' => 'Contacts',
    'join_name' => 'contacts',
    'dbType' => 'varchar',
    'source'=>'non-db',
    'len' => 36,
  ), 
  

Then go to Admin->Repair-> Clear Template Data Cache and Rebuild Relationships.
It's not upgrade-safe though...

[chriss4242]

Excellent, thanks for the help - I will go back and assess our options. Ideally I would like to keep the contacts in place so as to automate the invitations, ...

I will test the mod and we may go ahead with it and back it out before upgrade, although most likely will live with it for now and hope an upgrade addresses it down the track.

[DragonflyMaster]

[QUOTE=chriss4242]Excellent, thanks for the help - I will go back and assess our options. Ideally I would like to keep the contacts in place so as to automate the invitations, ...QUOTE]
Be advised that the solution I proposed allows to keep the contact under listview, but as a side effect if you have two or more different contacts for the same call, then you won't see the second, the third and so on.
For this, you'll have to open the detailview page.