Bug in Relationships - Relationships not configurable anymore

[icedieler]

I've got a very strange problem: I haven't done anything to a SugarCRM system as an admin. Just some records have been created by users without administrative rights.

But somehow the relationships got broken. Well, not the relationships themselves, the SugarCRM system works fine (except for another problem for which I will create a new thread after this one ). But I can't access the relationships in Studio anymore. I always get the following error (I have got the German language pack installed):

role_fields' => array ( 'usage' => 'query_only', ), 'opportunity_role_id' => array ( 'usage' => 'query_only', ), ); ?> {"center":{"title":"Opportunities Beziehungen","crumb":"<\/a> <\/a> | Studio<\/a> > Beratung<\/a> > Beziehungen<\/span>

","content":"\r\n
<\/div>\r\n* Beziehung im Studio erstellt<\/h3>

I have also attached a screenshot of the error since it looks kinda strange. I get the same error error message whenever I click on "Relationships" in any module of Studio.

Does anyone know what has happened here? The code snippet looks a bit like a vardefs file? I don't need to edit relationships right now, but I'll be lost if I would have to. I also tried quick repairs and to rebuild relationships ... but without any success.

Thanks in advance!

[andopes]

What is the version of your SugarCRM instance?
Did you install any package or customize code by hand?
Can you reproduce this same issue with en_us language pack?
Follow the tips in my first post here.


Regards

[icedieler]

I have Sugar 6.1.4 installed with only the german language pack for this version. The database is MySQL and the server runs on linux.
I have made customizations, but only to the language pack. Some expressions for the frontend needed to be renamed (e.g. Aktivitaeten (Activities) -> Aktion (Action)).

I have deactivated the language pack and tried again to access the relationships with the same result. I have attached some screenshots. The opportunities module delivers a longer error cade than the others. The opportunities module seems to be really broken since the error states "'opportunity_role_id' => array ( 'usage' => 'query_only', ), )" for every click on relationships, no matter which module. I even encounter that error message once in a while when viewing a detail page of an opportunity, between 2 subpanels.

One of the screenshots shows the error message when clicking on relationships in the opportunities module (the longer one), the other shows the error after clicking on relationships inside the campaigns module.

Your link doesn't work right now, but I can not spot a typo in the URL. Maybe the server is down right now.
Thank you for your help!

[andopes]

The Studio layout is 100% depending on ajax requests.
There are several javascrit functions which send to server specific requests and these javascript junctions fetch the response and try to fill in some specific layout fields with the response.
The big deal is: if the response is not the expected one error messages are displayed just like you can see.
By following the link I just provided you can see the request and responses and figure out what is wrong with responses.
Let us know both request and response from server so we can provide some clue.

Regards

[icedieler]

Thank you for your efforts!
I ripped one of our developers out of his project, put him in front of my monitor and told him "Repair it!". And he did as i told him. I think the solution could not have been found remotely since I guess it was SugarCRM's own fault.

Just in case anybody else has the same problem someday:

The file custom/modules/Contacts/metadata/subpanels/Opportunity_subpanel_contacts.php got corrupted

I don't know when or how it happened. I know that I once created a new subpanel/relationship for the Contacts module which I didn't need anymore later. The relationship just existed ... and suddenly got corrupted without getting touched by me anymore.

The file got filled with additional data at the wrong position:

 <?php
// created: 2011-04-18 17:23:38
$subpanel_layout['list_fields'] = array (
  'name' => 
  array (
    'name' => 'name',
    'vname' => 'LBL_LIST_NAME',
    'widget_class' => 'SubPanelDetailViewLink',
    'module' => 'Contacts',
    'width' => '23%',
    'default' => true,
  ),
  'account_name' => 
  array (
    'name' => 'account_name',
    'module' => 'Accounts',
    'target_record_key' => 'account_id',
    'target_module' => 'Accounts',
    'widget_class' => 'SubPanelDetailViewLink',
    'vname' => 'LBL_LIST_ACCOUNT_NAME',
    'width' => '22%',
    'sortable' => false,
    'default' => true,
  ),
  'email1' => 
  array (
    'name' => 'email1',
    'vname' => 'LBL_LIST_EMAIL',
    'widget_class' => 'SubPanelEmailLink',
    'width' => '30%',
    'sortable' => false,
    'default' => true,
  ),
  'phone_work' => 
  array (
    'name' => 'phone_work',
    'vname' => 'LBL_LIST_PHONE',
    'width' => '15%',
    'default' => true,
  ),
  'edit_button' => 
  array (
    'vname' => 'LBL_EDIT_BUTTON',
    'widget_class' => 'SubPanelEditRoleButton',
    'role_id' => 'opportunity_role_id',
    'module' => 'Contacts',
    'width' => '5%',
    'default' => true,
  ),
  'remove_button' => 
  array (
    'vname' => 'LBL_REMOVE',
    'widget_class' => 'SubPanelRemoveButton',
    'module' => 'Contacts',
    'width' => '5%',
    'default' => true,
  ),
  'first_name' => 
  array (
    'name' => 'first_name',
    'usage' => 'query_only',
  ),
  'last_name' => 
  array (
    'name' => 'last_name',
    'usage' => 'query_only',
  ),
  'salutation' => 
  array (
    'name' => 'salutation',
    'usage' => 'query_only',
  ),
  'account_id' => 
  array (
    'usage' => 'query_only',
  ),
  'opportunity_role_fields' => 
  array (
    'usage' => 'query_only',
  ),
  'opportunity_role_id' => 
  array (
    'usage' => 'query_only',
  ),
);
?>
role_fields' => 
  array (
    'usage' => 'query_only',
  ),
  'opportunity_role_id' => 
  array (
    'usage' => 'query_only',
  ),
); 

The last few lines were deleted and the system was up and running again.

Thank you for your help.