i done custom relationships it create relationship table but not show subpanel?

**shrisamsalunke** · 2012-01-31, 01:29 PM

hello everyone,
i created custom relationship between contacts and notes, it create contacts_notes_c table in database but in contacts detail view i can't see notes subpanel.
i refer this link SugarCRM many-to-one relations to standard modules - Lone Wolves - Web, game, and open source development

**andopes** · 2012-01-31, 02:02 PM

There is already two possible relationships between Contacts and Notes:

parent_type/parent_id
contact_id

What is the need to create a third one?

Cheers

**shrisamsalunke** · 2012-02-01, 01:07 AM

hi andopes,
i used community edition and whatever relationship table i created is perfect for me i juz want to see notes subpanel in contact details view so can you help me for showing subpanel by coding.........and thanks to rply me...........

**heta** · 2012-02-01, 05:29 AM

was that a one to many relationship? AFAIK, if you have one contact has many notes, you should see the subpanel in detail view of contact.

second check would be, just all files check custom/Extension/modules/Contacts/Ext/Layoutdefs/ and check if you have a subpanel definition for Notes or not?

**shrisamsalunke** · 2012-02-01, 06:08 AM

hi heta,
this is my one to many relationship in sugar log file i get below errors
Wednesday 01 February 2012 08:02:05 AM CET [3792][1][FATAL] Error fetching relationship from cache notes_contacts
Wednesday 01 February 2012 08:02:05 AM CET [3792][1][FATAL] Error fetching relationship from cache notes_contacts
Wednesday 01 February 2012 08:02:05 AM CET [3792][1][FATAL] Error fetching relationship from cache notes_contacts

so i can't understand why this take relation note_contacts i want contacts_notes...............so if you know solution pls tell me.............and thanks to rply me

**andopes** · 2012-02-01, 09:14 AM

Make sure there is a relationship definition at custom/metadata
Delete the script cache/modules/Relationships/Relationship.cache.php
Do a quick repair and rebuild

Cheers

**shrisamsalunke** · 2012-02-02, 11:49 AM

hi andopes,
after rebuild relationships and Quick Repair and Rebuild my subpanel is shown in detailsview but i can't understand what exactly happen internally after rebuild or repair and i found one error above my subpanel that is

Warning: mysqli_query() [function.mysqli-query]: Empty query in /opt/lampp/htdocs/CRM/include/database/MysqliManager.php on line 164

**andopes** · 2012-02-02, 01:21 PM

The query is empty because your relationship, or related fields, are buggy.

**shrisamsalunke** · 2012-02-03, 04:03 AM

hi,
i checked my contacts_notesMetadata.php file in both side custom/metadata and metadata but lhs and rhs values are correct so..................where i have to change for this issue..............pls guide me

**andywest** · 2012-02-03, 08:05 AM

Can you attach all the files you have created

Thread: i done custom relationships it create relationship table but not show subpanel?

LinkBack

Thread Tools

Search Thread

Display

i done custom relationships it create relationship table but not show subpanel?

Re: i done custom relationships it create relationship table but not show subpanel?

Re: i done custom relationships it create relationship table but not show subpanel?

Re: i done custom relationships it create relationship table but not show subpanel?

Re: i done custom relationships it create relationship table but not show subpanel?

Re: i done custom relationships it create relationship table but not show subpanel?

Re: i done custom relationships it create relationship table but not show subpanel?

Re: i done custom relationships it create relationship table but not show subpanel?

Re: i done custom relationships it create relationship table but not show subpanel?

Re: i done custom relationships it create relationship table but not show subpanel?

Thread Information

Users Browsing this Thread

Similar Threads

how to insert new record in relationship table from subpanel create button manualy?

create a subpanel that will show custom php page

one-many relationships - studio creates a relationship table

create custom subpanel with new DB table

Bookmarks

Bookmarks

Posting Permissions