Hot Fix: v5.1.0 can create orphaned relationship definitions that cause errors

[clint]

This hot fix addresses bug 26104 - Removing A custom module after adding a relationship in studio causes SQL Errors

With the new relationship editor introduced in Sugar 5.1.0, there have been reports of errors with custom relationships. The symptoms appear after first creating relationships in Module Builder or Studio with custom modules and out-of-the-box modules (such as with a custom Vendors module and the Accounts module) and then uninstalling the custom module. Relationships to the custom module remain after uninstalling the custom module which causes various errors. These errors include a blank screen when entering a DetailView or SQL errors when displaying subpanels on DetailViews.

Fix: the attached module-loadable file includes fixes for two files:

·data/SugarBean.php

·include/SubPanel/SubPanelTiles.php).


Note: This fix will be included in the upcoming Sugar 5.1.0c (Newport) patch targeted for release in two weeks. The fix has not been fully QA'ed as of the posting of this thread and may still require additional changes. Please report any issues you find with this fix in the bug report.

Note: The attached file will only install on Sugar Community Edition 5.1.0b. If you are running a previous version of Sugar 5.1.0, you must first upgrade to 5.1.0b. Sugar Professional and Sugar Enterprise users will need to submit a support case at http://support.sugarcrm.com in order to get the Professional or Enterprise versions of this fix.



Installation: Download the attached file and install on your system using the Module Loader in the Admin screen. After installing via Module Loader, you will need to run "Repair Relationships" from the Admin->Repair screen.


Please let us know if this fix works for you.

Regards,
The Sugar Team

[mezzo]

Did not work for me.

I habe a Sugar 5.1RC update to sugar 5.1b. And I installed the hotfix as you described.

Best regards, Alex

[clint]

Did not work for me.

I habe a Sugar 5.1RC update to sugar 5.1b. And I installed the hotfix as you described.

Best regards, Alex

Hi Alex -

Can you provide more details about your environment and the issues you ran into? You are running Sugar 5.1.0b right? What relationships had you created? What specific symptoms are you seeing?

Thanks for your help in nailing down the solution to this problem.