HELP! Custom Relationships

[matt.stannard]

Hi,

I've posted quite a lot today already but I've almost hit a dead end.

We've got two environments, a development one where we use the Module Builder and then Publish them to our live Sugar install.

Recentely, one of the team has made some amendments which seems to have "broken" some of the way Sugar works.

We have developed a number of modules relating to the Projects module in a similar way to tasks.

When a team member made the relationship they did it wrong making one to one, thus there is a Module 1 & Module 2 select (like selecting an Account). In the studio there is no relationship but repairing and rebuilding just doesn't remove it. How can I get rid of these relationships?

Also, where under the project our modules are Sugar displays LBL_PROJECT_....._TITLE rather than the title. I've checked the PHP for this and in the $['LBL_PROJECT_....TITLE] bit it has the correct name, how and where do I check that this is set?

If I can't solve this is there a good support address at Sugar to ask these queries to?

Many thanks

M

[robertbmirth]

If you have direct database access you should be able to navigate to the relationships table, find your relationship (by name is a good way) and then run a delete sql command or update with deleted = 1.

[salesagility]

It's not quite that simple ... read this good article http://redinkdesign.net/open-source/...-relationship/

[matt.stannard]

Hi Guys,

Thank you for this - really good articles.

I had to uninstall the module, for some reason even doing what the article said it kept rebuilding the relationmships. They weren't even in the relationships table either!!!!