Duplicate rows in contacts_cstm

[beltlinecommunities]

I've been trying to figure out whats causing this issue we're seeing for a bit now (it first appeared around 5.2.0a from what I recall), with zero luck so far. We're running Sugar Professional 5.2.0E on Apache 2.2.8, PHP 5.2.6 and MySQL 5.0.

What we are seeing happen is whenever you save a contact who may have been associated to two accounts (even if they are no longer associated) there is an additional row added into the contacts_cstm table. And for every entry in there the contacts listview increases by a factor of that count as its built by a join on that table. The duplicated row is not always a perfect copy of the existing row, sometimes its just null values with the contact's guid, othertimes it has the full set of values. I had added a logic_hook.php file to add an autonumber last week to work on another task, when it was there it started creating two additional rows each time, once I removed it then it went back to only creating one additional entry per save

Any ideas of where I should be focusing to figure this out?

[roblaus]

I am seeing the same issue here. I am also using an auto number logic hook. Will check whether I can find the reason. Bothers me a lot..