AnsweredAssumed Answered

"Teams" field dropdown not rendering after upgrading SugarPRO 7.1.5 to SugarPRO 7.2.0

Question asked by shivam.loadedtech on May 21, 2014

I am working on SugarCRM Professional, Version 7.1.5 (Build 1173) instance.

Have upgraded this instance to SugarCRM Professional, Version 7.2.0 (Build 1226).

After upgrading, "Teams" field is not rendering at all (displays nothing when clicked on 'Edit', where as it should render dropdown with blank/any saved value) for "Accounts" and "Opportunity" module's RecordView/EditView.

This issue is occuring for existing records only. For new records "Teams" field is rendering properly.

-- As this issue occured only for existing(old) records only, I have checked the value of team_id and team_set_id in database.

mysql> SELECT id, name, team_id, team_set_id FROM  'accounts' WHERE  'id' = '10de0270-7beb-0dce-4f75-50c9b31cc948';

id         10de0270-7beb-0dce-4f75-50c9b31cc948
name        ABC Pvt. Ltd.
team_id        627b4202-3711-da0b-6df1-5201bd424f24
team_set_id    627b4202-3711-da0b-6df1-5201bd424f24

mysql> SELECT * FROM  'teams' WHERE id =  '627b4202-3711-da0b-6df1-5201bd424f24';
Empty set (0.00 sec)

mysql> SELECT * FROM  'team_sets' WHERE id =  '627b4202-3711-da0b-6df1-5201bd424f24';
Empty set (0.00 sec)

As per the database query result, the team_id and team_set_id that's assigned to the 'Account' record, does not exist in "teams" and "team_sets" tables.

The same set of queries were ran for 7.1.5 as well  and even though the team_id and team_set_id does not exist in database tables, TEAM dropdown renders/displays fine in 7.1.5 but doesn't show any thing (not even pencil icon on Edit) in 7.2

NOTE: When I manually update the "team_id" and "team_set_id" for any Account record to "1" (ie Team "Global").  By doing "Team" field dropdown renders properly for this record. So not sure what has changed in Sugar 7.2 wrt "Teams" related files that is causing it to behave differently and not render dropdown or saved value at all despite of values in DB.

Also I quickly performed a diff for "wwwroot/include/SugarFields/Fields/Teamset/SugarFieldTeamset.php" between 7.1.5 v and 7.2 v and I see a lot of code has changed. Could this be the reason that "Teams" drop down isnt rendering correctly ?

Please review this issue and let us know if its a core bug of the sugarPRO 7.2.0 and if yes, then any code patch(solution) for the same.