Popup windows search returning empty

[leowolff]

Sugar 5.2

Hello, I am using a few custom modules, one of them called Offering has a button that call a popup on Services module, that popup should bring a list of all the services register (200+), but it comes empty (not blank). The popup windows (popupdefs.php) comes with the search fields on the top (searchdefs.php), and the listview on the botton, but empty.

popupdefs.php :

 $module_name = 'oqc_Product';
$_module_name = 'oqc_product';
$_object_name = 'oqc_product';
$popupMeta = array('moduleMain' => $module_name,
                        'varName' => $module_name,
                        'orderBy' => $_module_name . '.name',
                        'whereClauses' => 
                            array('name' => $_module_name. '.name', 
                                    $_object_name . '_number' => $_module_name. '.'. $_object_name.'_number'),
                            'searchInputs'=> array($_module_name . '_number', 'name', 'priority','status'),
                            'listview' => 'modules/' . $module_name . '/metadata/listviewdefs.php',
                            'search'   => 'modules/' . $module_name . '/metadata/searchdefs.php',
                            
                        );
?> 
 

Any tip where should I start looking to find the bug?


Regards

[crmsiva]

Set the log level to debug and check the query used for popup in sugarcrm.log file

[andopes]

Hi Leo

Edit the file include/ListView/ListViewData.php and add this line

 echo "<LI>$main_query</LI>"; 
  

Just after the line

 $main_query = $ret_array['select'] . $params['custom_select'] . $ret_array['from'] . $params['custom_from'] . $ret_array['where'] . $params['custom_where'] . $ret_array['order_by'] . $params['custom_order_by']; 
  

Try to access the popup again.
A sql query will be displayed.
Copy this and execute on phpMyAdmin, it should return an error.
Also let us know it.

Cheers

[leowolff]

Thanks a lot Andre, you are taking me by hand into the world of programming... The SQL generated was:

 SELECT oqc_product.id ,oqc_product_cstm.numteclado_c,oqc_product_cstm.fonte_c,oqc_product_cstm.entrega_c,oqc_product_cstm.vga_c,oqc_product_cstm.ethernet_c,oqc_product_cstm.usb_c,oqc_product_cstm.zigbee_c,oqc_product_cstm.garantia_c,oqc_product_cstm.datafab_c,oqc_product_cstm.desccpu_c, oqc_product.name , jt0.name accounts_oqc_product_name, jtl0.accounts_oqctaccounts_ida accounts_oqctaccounts_ida, jt1.name relatedcategory , oqc_product.relatedcategory_id , CONCAT(IFNULL(jt2.first_name,''),' ',IFNULL(jt2.last_name,'')) personincharge , oqc_product.assigned_user_id FROM oqc_product LEFT JOIN oqc_product_cstm ON oqc_product.id = oqc_product_cstm.id_c LEFT JOIN accounts_oqc_product_c jtl0 ON oqc_product.id=jtl0.accounts_oqqc_product_idb AND jtl0.deleted=0 LEFT JOIN accounts jt0 ON jt0.id=jtl0.accounts_oqctaccounts_ida AND jt0.deleted=0 AND jt0.deleted=0 LEFT JOIN oqc_category jt1 ON oqc_product.relatedcategory_id = jt1.id AND jt1.deleted=0 LEFT JOIN users jt2 ON oqc_product.personincharge_id = jt2.id AND jt2.deleted=0 where (oqc_product.catalog_id like '609502e8-4884-8ca5-7b3e-49f7396733b8%') AND oqc_product.deleted=0 ORDER BY oqc_product.name ASC 
  

The error is in the end, this command:
(oqc_product.catalog_id like '609502e8-4884-8ca5-7b3e-49f7396733b8%') AND

It should be blank there, no rule to apply to select a product catalog.

Ok, now how do I change the code (which file) to erase that line from the select?

Regards

[andopes]

Actually I don't know the details regarding the Open Quotes and Contracts, so you should contact the maintainer of the project.

Cheers

[leowolff]

SOLVED, thanks a lot.

The problem was with a flag in the product catalog module.

[pablovannini]

Hi
I have the same problem ¿what flag did you change?
regards

[leowolff]

Go to product catalog module, select the catalog that you are using, and make sure that the active checkbox is empty.