I created a custom module and added a a relationship to activities. When I checked on that relationship it was not showing up in sugar. I added some other relationships to documents and leads and they were showing up fine. I then tried to create the relationship again to activities in the studio builder and now no relationships are showing up. I checked the log and I am getting the below error. I believe it is because the relationship is added twice in Sugarm but I can't remove either one of them with in Studio or Module Builder. Studio shows the relationship I created in Module builder but not the relationship I created in Studio. I tried deleting the relationship in module builder but when I try to deploy it nothing changes in studio and the error is still there. Is there another way to fix this. I am a newbie to sugarcrm and learning as I go so any help would be great.



Mon Oct 24 08:50:17 2011 [31593][1][FATAL] Error running count query for c1_Creditorsinfo List: Query Failed: ( SELECT count(*) c FROM meetings INNER JOIN c1_creditorsinfo c1_creditorsinfo_activities_meetings_rel ON meetings.parent_id=c1_creditorsinfo_activities_mee tings_rel.id AND c1_creditorsinfo_activities_meetings_rel.deleted=0
AND .parent_type = 'c1_Creditorsinfo'
where ( meetings.parent_id='9eb19615-a513-c85a-6114-4ea56d19cce6' AND (meetings.status !='Held' AND meetings.status !='Not Held')) AND meetings.deleted=0 ) UNION ALL ( SELECT count(*) c FROM calls INNER JOIN c1_creditorsinfo c1_creditorsinfo_activities_calls_rel ON calls.parent_id=c1_creditorsinfo_activities_calls_ rel.id AND c1_creditorsinfo_activities_calls_rel.deleted=0
AND .parent_type = 'c1_Creditorsinfo'
where ( calls.parent_id='9eb19615-a513-c85a-6114-4ea56d19cce6' AND (calls.status != 'Held' AND calls.status != 'Not Held')) AND calls.deleted=0 ): MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 'c1_Creditorsinfo'
where ( meetings.parent_id='9eb19615-a513-c85a-6114-4ea56d' at line 2