Afterwards, do a Admin / Repair / Quick Repair and Rebuild
Open Studio, module Contacts / Layouts / Filter
The filter field Target List is now available in the Hidden list and can be added to the Quick Filter and the Advance Filter layout.
thank you for your solution for (re)-introducing the target list filter to the contacts, it works great.
Meanwhile, I have one more question regarding the original thread request of adding the target list subpanel to the contact module:
When i click the âselectâ button in the target list subpanel for addding the contact to another list, the selection popup opens, but the existing lists are not displayed and thus cannot be selected. Could you provide us with a way to get this working again?
thank your for your quick reply. Actually, there are no clear and search buttons in the popup, it seems to be the dialogue for creating a new target list, see the screenshot attached.
Yes, if I open the URL you posted (/?module=ProspectLists&action=Popup), I get the same dialogue (target list creation dialogue with the buttons âSaveâ and âCancelâ. The page is opening in the tab where I put the URL, no popup is opened.
One more thing I just noticed: If I hit the âcreate target listâ button in the actions sidebar in the target list module, a popup with an error message opens (see attached image). Right now, it does not seem to be possible to create a new target list, the only way is to duplicate an existing list, emptying it manually and rename it.
@jansiero
It would be great if you added this code in gitHub to the core SuiteCRM system so that everybody could benefit from it.
From my understanding itâs just a matter to do the same for all the modules that are connected to target lists (accounts, contacts, leads, targets and users).
Hello @jansiero
I am looking for the ZIP file that was mentioned in this conversation - do you still have it? I canât see where to get it from the old chat.
Thanks very much,
Vanessa
When i add this filter to Targets module and search, it is working good. But when i try to exports all list, there is a database error. What is wrong?
âDatabase failure. Please refer to suitecrm.log for details.â
In log:
Sun Dec 6 22:35:20 2020 [20131][e433d2f0-c23e-3ad2-bd4d-5ee727929421][FATAL] Mysqli_query failed.
Sun Dec 6 22:35:20 2020 [20131][e433d2f0-c23e-3ad2-bd4d-5ee727929421][FATAL] Error exporting Prospects: .SELECT
prospects.,
email_addresses.email_address email_address,
ââ email_addresses_non_primary, users.user_name as assigned_user_name ,prospects_cstm.jjwg_maps_geocode_status_c,prospects_cstm.jjwg_maps_lng_c,prospects_cstm.jjwg_maps_lat_c,prospects_cstm.target_tag_c,prospects_cstm.jjwg_maps_address_c FROM prospects LEFT JOIN users
ON prospects.assigned_user_id=users.id LEFT JOIN email_addr_bean_rel on prospects.id = email_addr_bean_rel.bean_id and email_addr_bean_rel.bean_module = âProspectsâ and email_addr_bean_rel.deleted = 0 and email_addr_bean_rel.primary_address = 1 LEFT JOIN email_addresses on email_addresses.id = email_addr_bean_rel.email_address_id LEFT JOIN prospects_cstm ON prospects.id = prospects_cstm.id_c WHERE ((prospect_list_name like â1. gönderim gerçek liste%â)) AND prospects.deleted=0 Query Failed: SELECT
prospects.,
email_addresses.email_address email_address,
ââ email_addresses_non_primary, users.user_name as assigned_user_name ,prospects_cstm.jjwg_maps_geocode_status_c,prospects_cstm.jjwg_maps_lng_c,prospects_cstm.jjwg_maps_lat_c,prospects_cstm.target_tag_c,prospects_cstm.jjwg_maps_address_c FROM prospects LEFT JOIN users
ON prospects.assigned_user_id=users.id LEFT JOIN email_addr_bean_rel on prospects.id = email_addr_bean_rel.bean_id and email_addr_bean_rel.bean_module = âProspectsâ and email_addr_bean_rel.deleted = 0 and email_addr_bean_rel.primary_address = 1 LEFT JOIN email_addresses on email_addresses.id = email_addr_bean_rel.email_address_id LEFT JOIN prospects_cstm ON prospects.id = prospects_cstm.id_c WHERE ((prospect_list_name like â1. gönderim gerçek liste%â)) AND prospects.deleted=0 : MySQL error 1054: Unknown column âprospect_list_nameâ in âwhere clauseâ
Sun Dec 6 22:35:20 2020 [20131][e433d2f0-c23e-3ad2-bd4d-5ee727929421][FATAL] Exception handling in /var/www/sucrm/crm/include/MVC/Controller/SugarController.php:400
Sun Dec 6 22:35:20 2020 [20131][e433d2f0-c23e-3ad2-bd4d-5ee727929421][FATAL] Exception in Controller: Database failure. Please refer to suitecrm.log for details.
Sun Dec 6 22:35:20 2020 [20131][e433d2f0-c23e-3ad2-bd4d-5ee727929421][FATAL] backtrace: #0 /var/www/sucrm/crm/include/database/DBManager.php(353): sugar_die(âDatabase failurâŠâ) #1 /var/www/sucrm/crm/include/database/DBManager.php(328): DBManager->registerError(âError exportingâŠâ, âError exportingâŠâ, true) #2 /var/www/sucrm/crm/include/database/MysqliManager.php(179): DBManager->checkError(âError exportingâŠâ, true) #3 /var/www/sucrm/crm/custom/biz_FLA/classes/FLA_custom_export_utils.php(191): MysqliManager->query(âSELECT\n\t\t\t\t\tproâŠâ, true, âError exportingâŠâ) #4 /var/www/sucrm/crm/field_access_control_export.php(74): export(âProspectsâ) #5 /var/www/sucrm/crm/include/MVC/Controller/SugarController.php(1020): require_once(â/var/www/sucrm/âŠâ) #6 /var/www/sucrm/crm/include/MVC/Controller/SugarController.php(468): SugarController->handleEntryPoint() #7 /var/www/sucrm/crm/include/MVC/Controller/SugarController.php(373): SugarController->process() #8 /var/www/sucrm/crm/include/MVC/SugarApplication.php(113): SugarController->execute() #9 /var/www/sucrm/crm/index.php(52): SugarApplication->execute() #10 {main}
I added the filter to the targets module, added the field to the filter, filtered on the target list name, selected the search results and exported. This worked flawlessly.
Could the error be caused by your custom code? You have a custom class in your stack trace:
I uninstalled related plugin and tried again. It was same. What is problem, i donât know?
I m trying new instance of 7.11.15. Same thing happen. If you select first page records and then export, it is working. But if you select all records in bulk action menu, it doesnât work.
If i select all records page by page, i can export them. The problem is âselect allâ function
Mon Dec 7 17:52:06 2020 [30995][e433d2f0-c23e-3ad2-bd4d-5ee727929421][FATAL] Mysqli_query failed.
Mon Dec 7 17:52:06 2020 [30995][e433d2f0-c23e-3ad2-bd4d-5ee727929421][FATAL] Error exporting Prospects: .SELECT
prospects.,
email_addresses.email_address email_address,
ââ email_addresses_non_primary, users.user_name as assigned_user_name ,prospects_cstm.jjwg_maps_geocode_status_c,prospects_cstm.jjwg_maps_lng_c,prospects_cstm.jjwg_maps_lat_c,prospects_cstm.target_tag_c,prospects_cstm.jjwg_maps_address_c FROM prospects LEFT JOIN users
ON prospects.assigned_user_id=users.id LEFT JOIN email_addr_bean_rel on prospects.id = email_addr_bean_rel.bean_id and email_addr_bean_rel.bean_module = âProspectsâ and email_addr_bean_rel.deleted = 0 and email_addr_bean_rel.primary_address = 1 LEFT JOIN email_addresses on email_addresses.id = email_addr_bean_rel.email_address_id LEFT JOIN prospects_cstm ON prospects.id = prospects_cstm.id_c WHERE ((prospect_list_name like â15 ĆUBAT 2018 KONFERANS KATILIMCI LÄ°STESÄ°%â)) AND prospects.deleted=0 Query Failed: SELECT
prospects.,
email_addresses.email_address email_address,
ââ email_addresses_non_primary, users.user_name as assigned_user_name ,prospects_cstm.jjwg_maps_geocode_status_c,prospects_cstm.jjwg_maps_lng_c,prospects_cstm.jjwg_maps_lat_c,prospects_cstm.target_tag_c,prospects_cstm.jjwg_maps_address_c FROM prospects LEFT JOIN users
ON prospects.assigned_user_id=users.id LEFT JOIN email_addr_bean_rel on prospects.id = email_addr_bean_rel.bean_id and email_addr_bean_rel.bean_module = âProspectsâ and email_addr_bean_rel.deleted = 0 and email_addr_bean_rel.primary_address = 1 LEFT JOIN email_addresses on email_addresses.id = email_addr_bean_rel.email_address_id LEFT JOIN prospects_cstm ON prospects.id = prospects_cstm.id_c WHERE ((prospect_list_name like â15 ĆUBAT 2018 KONFERANS KATILIMCI LÄ°STESÄ°%â)) AND prospects.deleted=0 : MySQL error 1054: Unknown column âprospect_list_nameâ in âwhere clauseâ
Mon Dec 7 17:52:06 2020 [30995][e433d2f0-c23e-3ad2-bd4d-5ee727929421][FATAL] Exception handling in /var/www/sucrm/crm/include/MVC/Controller/SugarController.php:400
Mon Dec 7 17:52:06 2020 [30995][e433d2f0-c23e-3ad2-bd4d-5ee727929421][FATAL] Exception in Controller: Database failure. Please refer to suitecrm.log for details.
Mon Dec 7 17:52:06 2020 [30995][e433d2f0-c23e-3ad2-bd4d-5ee727929421][FATAL] backtrace: #0 /var/www/sucrm/crm/include/database/DBManager.php(353): sugar_die(âDatabase failurâŠâ) #1 /var/www/sucrm/crm/include/database/DBManager.php(328): DBManager->registerError(âError exportingâŠâ, âError exportingâŠâ, true) #2 /var/www/sucrm/crm/include/database/MysqliManager.php(179): DBManager->checkError(âError exportingâŠâ, true) #3 /var/www/sucrm/crm/include/export_utils.php(194): MysqliManager->query(âSELECT\n\t\t\t\t\tproâŠâ, true, âError exportingâŠâ) #4 /var/www/sucrm/crm/export.php(69): export(âProspectsâ) #5 /var/www/sucrm/crm/include/MVC/Controller/SugarController.php(1020): require_once(â/var/www/sucrm/âŠâ) #6 /var/www/sucrm/crm/include/MVC/Controller/SugarController.php(468): SugarController->handleEntryPoint() #7 /var/www/sucrm/crm/include/MVC/Controller/SugarController.php(373): SugarController->process() #8 /var/www/sucrm/crm/include/MVC/SugarApplication.php(113): SugarController->execute() #9 /var/www/sucrm/crm/index.php(52): SugarApplication->execute() #10 {main}
Coincidentally I stumbled upon the edit of your latest post. Your directive to use âselect allâ was key to reproduce the bug you found. You should really emphasize when you discover details on how to reproduce by posting a new comment.
The problem is caused by legacy code for exporting in the file include/SugarObjects/templates/person/Person.php
To fix it, comment out the following function and its contents (line 296 to line 345)
public function create_export_query($order_by, $where, $relate_link_join = '')
This legacy code made sure to export the e-mail addresses. It is obsolete as this is already supported by the base class method Sugarbean::create_export_query
Yes you are right.
Thank you for your support. When i comment out the function, it is working good.
when i comment out it, are there any bad effect to other export funcstions?
Hi, if you look into the function you will see its only purpose is to add email addresses. I donât expect adverse effects apart from a changed order of columns in the exported file.