Problem: After delete custom module one-to-one relationship to Contact module, the custom module viewlist is empty
Quiestion: How to delete relationship via Studio without the problem? What can be a reason.
Is it common problem for 7.10.x ?
Thanks for responces, recomendations and help in advance.
Background:
Rights to files and directories: 755 Owner: apache.apache
System: RedHat, Linux 3.10.0-693.17.1.el7.x86_64 GNU/Linux
SuiteCRM v7.10.15 LTS Sugar Version 6.5.25 (Build 344)
Logs: No errors. I see debug messages in the suitecrm.log.
I have relation between Contacts module and my own custom module.
It works well but I need change type of relation to one-to-many.
Thus I need to delete one-to-one ralationship created in Studio.
After both ways I run repair and rebuild and it is done. Also clear cache and rebuild relationships. No errors.
I try two ways to solve the problem:
- Studio
After I delete via Studio the relation I have the BLANK ViewList layout for the custom module with ajax error (or without) message.
The same result if I stay tables (check the flag to do not delete it).
Here is no difference am I delete the relationship in the Contacts or in the custom module. The same problem is.
Also, I have the error ajax message but not always. I can disable it in config_override.php with
$sugar_config['disableAjaxUI'] = true;
But it has no impact on the blank ListView custom module layout.
The blank layout contains no table wtih data.
- Manual
But I found other way how manually delete relations.
Here is citation:from https://stackoverflow.com/questions/50028256/how-to-remove-a-single-relationship
And here is the same way described: https://stackoverflow.com/questions/47816260/how-to-remove-custom-relationship-in-sugarcrm?rq=1
"In case you are not allowed you can use another method. You should first delete two files:
Metadata file:
custom\metadata~relationship_name~MetaData.php
TableDictionary file: custom\Extension\application\Ext\TableDictionary~relationship_name~.php
Now you have to remove fields from both related modules:
custom\Extension\modules~first_module_name~\ext\vardef~field_name~.php
custom\Extension\modules~second_module_name~\ext\vardef~field_name~.php
P.S: Remember to backup before deleting any files"
Is it right way full of needed steps?
I doubt and I care this is not full list of activities to delete all information about the relationsip.
I also found by the relationship name some files related to the deleted relationship and delete it too.
This way stay the custom module ListView layout workable.
But I’m not sure I will have no problem in the future after this manual operation.
Alex