AnsweredAssumed Answered

Duplicates in relational tables

Question asked by gperez gperez on May 15, 2014
Latest reply on May 21, 2014 by Jason Eggers
Hi. We are running SugarCRM CE 6.2.
We discovered that when searching records in the List View, sometimes the records appears duplicated. By example: having Reservations and Properties tables related (from Studio), if we search for Reservations for a given Property, there's a chance that the records will be duplicated.

I searched for duplicates in database. And I found that there's only one Reservation in the reservations table. However, there's several records in the reservations_properties table. This happens for a lot of records, and also happens in many other relational table (by example: reservations_notes).

There's something more. If you edit the Reservation, after save the duplicates disappears. !

Any clue?