Results 1 to 5 of 5

Thread: Bug in Relationships - Relationships not configurable anymore

  1. #1
    icedieler is offline Member
    Join Date
    Mar 2011
    Posts
    8

    Unhappy Bug in Relationships - Relationships not configurable anymore

    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):

    Code:
    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!
    Attached Images Attached Images  

  2. #2
    andopes's Avatar
    andopes is offline A Sugar Hero | Help Forum Moderator
    Join Date
    Jul 2006
    Location
    São Paulo - Brazil
    Posts
    8,335

    Default Re: Bug in Relationships - Relationships not configurable anymore

    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
    André Lopes
    DevToolKit / Project of the Month - June 2009
    Lampada Global Services- Open Source Solutions
    Avenida Ipiranga, 318
    Bloco B - CJ 1602
    São Paulo, SP 01046-010
    Brazil
    Office: +55 11 3237-3110
    Mobile: +55 11 7636-5859
    e-mail: andre@lampadaglobal.com

    Lampada Global delivers offshore software development and support services to customers around the world.
    Lampada is proud to be a SugarCRM Gold Partner, revolutionizing Customer Relationship Management.

    I DO NOT answer questions through PM and Email. If you need some help post your question into SugarForum.

  3. #3
    icedieler is offline Member
    Join Date
    Mar 2011
    Posts
    8

    Question Re: Bug in Relationships - Relationships not configurable anymore

    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!
    Attached Images Attached Images   

  4. #4
    andopes's Avatar
    andopes is offline A Sugar Hero | Help Forum Moderator
    Join Date
    Jul 2006
    Location
    São Paulo - Brazil
    Posts
    8,335

    Default Re: Bug in Relationships - Relationships not configurable anymore

    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
    André Lopes
    DevToolKit / Project of the Month - June 2009
    Lampada Global Services- Open Source Solutions
    Avenida Ipiranga, 318
    Bloco B - CJ 1602
    São Paulo, SP 01046-010
    Brazil
    Office: +55 11 3237-3110
    Mobile: +55 11 7636-5859
    e-mail: andre@lampadaglobal.com

    Lampada Global delivers offshore software development and support services to customers around the world.
    Lampada is proud to be a SugarCRM Gold Partner, revolutionizing Customer Relationship Management.

    I DO NOT answer questions through PM and Email. If you need some help post your question into SugarForum.

  5. #5
    icedieler is offline Member
    Join Date
    Mar 2011
    Posts
    8

    Default Re: Bug in Relationships - Relationships not configurable anymore

    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 Code:
    <?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.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Relationships in Studio->Opportunities->Relationships
    By malika_gupta in forum Developer Tools
    Replies: 0
    Last Post: 2011-04-09, 11:42 AM
  2. Help with relationships
    By jimbarnes in forum Developer Help
    Replies: 2
    Last Post: 2010-03-31, 06:35 PM
  3. Relationships
    By archie in forum Help
    Replies: 6
    Last Post: 2009-10-11, 05:15 PM
  4. relationships
    By Meyer in forum Help
    Replies: 6
    Last Post: 2007-12-20, 04:12 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •