Subpanels not visible in Products

💬 General Discussion
1

Hi,

we are having Suitecrm 7.7.8 upgraded from 7.7.4 and have added a custom module ‘assets’ to track products serials.
have added a
assets -> many to one -> products
assets -> many to one -> contracts
assets -> many to one -> accounts

after a quick repair , I can see the asset subpanel in contracts and accounts but products looks set to not display any subpanel, con someone confirm if it is the way products is working ? if yes, how to disable it ?

I confirm that i have the relation in in custom/Extension/modules/AOS_Products/Ext/Layoutdefs

many thanks,
BM

2

found the issue and opened bug: AOS_Products detail view does not diplay subpanels #2869

Possible Fix

edit modules/AOS_Products\metadata\subpaneldefs.php

current
line53 //‘get_subpanel_data’ => ‘aos_products_aos_quotes_1’,
line54 ‘get_subpanel_data’ => ‘function:getCustomersPurchasedProductsQuery’,

modified
line53 ‘get_subpanel_data’ => ‘aos_products_aos_quotes_1’,
line54 //‘get_subpanel_data’ => ‘function:getCustomersPurchasedProductsQuery’,

after this modification my custom relationships are visible, this point to be an issue with function:getCustomersPurchasedProductsQuery

1 Like
3

sql_mode had to be adjusted

mode details here : https://github.com/salesagility/SuiteCRM/issues/2869

do we have requisits for mysql config somewhere?