How to remove a custom relationship

[pbthenick]

Hello,

I have been testing the latest version of sugarcrm with my company's data for a few weeks. Recently I added a relationship with which I can't find a way to remove.

Does anybody know how to remove it either through the UI or manually? Thank you in advance for any help one can offer.

Regards,
pbthenick

Sugar 5.1
Win 2003 32bit
5.2.6 php
Sql Server Express 2005
Apache 2.0

[andopes]

Hi pbthenick

You need to:
1. remove the field in the vardefs which points to that relationship;
2. remove the relationship itself from the metadata folder, if exists or from the vardefs;
3. Rebuild Extension and Rebuild Relationship

Cheers

[pbthenick]

André,

Thank you very much. Your instructions solved my problem.


Regards,
pbthenick

[clayreiche]

Can you explain in detail how to do this? Every time I manually modify lines from (seemingly) ANY file, a rebuild puts the files back!!! I'm very frustrated at the moment. I'm using Version 5.1.0b (Build 4905). I've created a custom module, and then created a one-to-many relationship to it with "Contacts" as the primary module. Doesn't appear to be any way to remove the relationship in the gui... I thought I followed your directions above but once I did the rebuild(s), the files went back to original versions...

I had modified some listviewdefs also and the files disappeared on a rebuild.... just seems like the rebuilds are killing me. I've wasted a lot of time modifying views to then have them blown away after a rebuild...

Thanks for your help in understanding how this all works.

Clay

[eNick]

Just one quick point on this...

Never, never, ever "play" with module builder or studio on your live system! Especially, without taking a backup - of both the database and the code.

If you don't know how to take (and restore) a full backup or create a cloned playpit you probably shouldn't be making these kinds of changes.

You have the potential to seriously damage your system and possibly lose access to your customer data. At best, you'll end up having to pay a company like ours to sort your mess out before your boss discovers what you've done.

It's going to be a horrible sickening feeling in your stomach when you realise you've just broke your system.

[clayreiche]

Thanks for the lesson eNick. Not a production system, I'm evaluating and comparing to Salesforce.com. Instead of taking the time to scold, it would have been nice for you to help me with my problem...

Clay

[LucioFiamingo]

Hi, I'm new in sugarcrm and I'd like to know how to remove a relationship. I.e. :


1. remove the field in the vardefs which points to that relationship;
2. remove the relationship itself from the metadata folder, if exists or from the vardefs;
3. Rebuild Extension and Rebuild Relationship

Could you explain how to do this steps??

Thanks

[andopes]

Hi, I'm new in sugarcrm and I'd like to know how to remove a relationship. I.e. :


1. remove the field in the vardefs which points to that relationship;
2. remove the relationship itself from the metadata folder, if exists or from the vardefs;
3. Rebuild Extension and Rebuild Relationship

Could you explain how to do this steps??

Thanks

When you create a new relationship through Admin -> Studio -> <Module Name> -> Relationships, Sugar create several files at custom folders:

Left Side Hand Relationship (module from which you created the relationship):
custom/Extension/modules/<ModuleName>/Ext/Vardefs/<relationship_name>.php
custom/Extension/modules/<ModuleName>/Ext/Layoutdefs/<relationship_name>.php
custom/Extension/modules/<ModuleName>/Ext/Language/<relationship_name>.php

Right Side Hand Relationship:
custom/Extension/modules/<ModuleName>/Ext/Vardefs/<relationship_name>.php
custom/Extension/modules/<ModuleName>/Ext/Language/<relationship_name>.php

Relationship itself:
custom/metadata/<relationship_name>Meta.php

Table Dictionary:
custom/Extension/application/Ext/TableDictionary/<relationship_name>.php

After removing all these files you should need to go to Admin -> Repair -> Quick Repair and Rebuild

Cheers

[analyst123]

also you have to edit /sugar/custom/application/Ext/TableDictionary/tabledictionary.ext.php file and delete

include('custom/metadata/<relationship_name>.php');

[davidmmulder]

This doesn't work (at least in 5.1.0b). It just crashed both modules in the relationship (giving a MySQL error of some sort). I restored from backup and it's just fine, but I would like to know how to actually remove a relationship. Why are relationships permanent if you add them in the Studio? There aught to be an option to remove them.