Error fetching relationship & Missing relationship definition

[davideps]

Hello,

I am using SugarCRM CE 6.1.4 on Ubuntu 10.04

I created a one-to-many relationship between DOCUMENTS and NOTES. I also creates several many-to-many relationships between NOTES AND NOTES. One problem that I encountered was that there was no "remove" button in the many-to-many subpanels in notes to remove a relationship.

Just recently, I clicked on the "edit" column of one of the subpanels (which had no rows of data) and got a "database failure error, check sugarcrm.log". I've pasted the tail end of the log below. I keep getting this message when viewing this particular note. But, others seem to display normally (still without the option to remove relationship instances).

Can anyone tell me how to fix this?

thank you,
-david


Tue May 10 09:53:06 2011 [2571][1][FATAL] Error fetching relationship from cache notes_documents
Tue May 10 09:53:06 2011 [2571][1][FATAL] Missing relationship definition notes_documents. skipping notes_documents subpanel
Tue May 10 09:53:09 2011 [2571][1][FATAL] Error fetching relationship from cache notes_documents
Tue May 10 09:53:09 2011 [2571][1][FATAL] Error fetching relationship from cache notes_documents
Tue May 10 09:53:09 2011 [2571][1][FATAL] Missing relationship definition notes_documents. skipping notes_documents subpanel
Tue May 10 09:53:13 2011 [2571][1][FATAL] Error fetching relationship from cache notes_documents
Tue May 10 09:53:13 2011 [2571][1][FATAL] Error fetching relationship from cache notes_documents
Tue May 10 09:53:13 2011 [2571][1][FATAL] Missing relationship definition notes_documents. skipping notes_documents subpanel
Tue May 10 09:53:15 2011 [2571][1][FATAL] Error fetching relationship from cache notes_documents
Tue May 10 09:53:15 2011 [2571][1][FATAL] Error fetching relationship from cache notes_documents
Tue May 10 09:53:15 2011 [2571][1][FATAL] Missing relationship definition notes_documents. skipping notes_documents subpanel
Tue May 10 09:53:17 2011 [2571][1][FATAL] Error fetching relationship from cache notes_documents
Tue May 10 09:53:17 2011 [2571][1][FATAL] Error fetching relationship from cache notes_documents
Tue May 10 09:53:17 2011 [2571][1][FATAL] Missing relationship definition notes_documents. skipping notes_documents subpanel
Tue May 10 09:53:17 2011 [2571][1][FATAL] MySQL error 1054: Unknown column 'edit_button' in 'order clause'

[jmertic]

Try Repairing Relationships, and then a Quick Rebuild and Repair.

[davideps]

Thank you. I think this may have cleared the error. But, I still do not have the option of adding a "remove" button to the notes subpanel that links one note with others. Whenever one creates a custom relationship in Studio, should there always be a way to create, edit, and remove that relationship through the panels.

-david

[jmertic]

You could add the button in the subpanel definition as shown below:

 'remove_button'=>array(
            'vname' => 'LBL_REMOVE',
             'widget_class' => 'SubPanelRemoveButton',
             'width' => '2%',
        ), 
  

[davideps]

hi jmertic,

So when you create a many-to-many relationship, a remove button isn't automatically one of the options in the subform layout?

I've not tried to edit any of the php code yet. I've worked exclusively through the web interface. Could you provide a little more detail? What would be the path to the file I need to add this code to? Do I need to add the code to a particular part of the file or just adding it to the end is sufficient?

thank you so much,
-david

[jmertic]

It should be added by default, but it seems in your case it wasn't.

To add this, copy the modules/<module name>/metdata/subpaneldefs.php to custom/modules/<module name>/metdata/subpaneldefs.php and then add the code snippet to the field list array.