Relationships between custom module and accounts being duplicated when edited

[Nisbet]

I have an odd problem. I have a custom module that has a relationship with accounts. When ever a user selects the edit link from the subpanel on the accounts screen a new link to the object is created(i.e before editing it would say 1-10 of 301. after editing it will say 1-10 of 302, and there is a duplicate association at the end of the list). The newly created link still references the original object(same ID) , and checking the relation table I only have one entry for the association. The really odd thing is if you open the object up via the name link and edit it, everything works fine(i.e. no new relation created). When I remove the newly created relation it removes both the new and the old entries(count goes from 302 to 300). I have tried repairing the DB and rebuilding the relationships, but that doesn't seem to fix the problem. Anyone have any ideas?


SugarOS 5.0.0f running on Gentoo Linux with MySQL 5.0.54/PHP 5.2.5-r1

[Nisbet]

Anyone have any ideas on this? It is causing a lot of problems for my users

[kbrill]

Without actually seeing the code I am afraid that noone can really help, can you post it.

[Billwobo]

I have the same exact problem. You can check out my post:
http://www.sugarcrm.com/forums/showthread.php?t=36565

Same thing happens when you create a new record directly from the subpanel. You create one, and after creation, sugar counts two records. Although it doesn't create a duplicate record. That's why I think the problem resides in the "COUNT" formula of the subpanel. I have this problem with all of my custom module's subpanel.

When you create a record from the custom module's side create panel, the subpanel doesn't count this record twice, if that can help the investigation.

PS. I'm running Sugar CE 5.1RC on a windows XAMPP.
PHP Version 5.2.5
MySQL 5.0.51a
I built these custom modules on the 5.1RC version as well.