Assigning Accounts to Secuirt group fail if filter by "Member Of" #3754

New issue

Open

opened 2026-02-20 16:09:27 -05:00 by deekerman · 0 comments

deekerman commented

2026-02-20 16:09:27 -05:00

Owner

Originally created by @robertmilowski on GitHub (Jun 5, 2019).

Issue

Tried to assign secuirty group to the accountes filtered by "member of" field. choose "Select All (43)" (More then 20 accounts) , next select group and press ASSIGN button, system failed with "Database failure. Please refer to suitecrm.log for details."

Expected Behavior

Group should be assign to all 43 accounts

Actual Behavior

system crash with "Database failure. Please refer to suitecrm.log for details."
Unknown column 'jt1.name' in 'where clause'

Wed Jun 5 22:44:58 2019 [858519][1][FATAL] Mysqli_query failed.
Wed Jun 5 22:44:58 2019 [858519][1][FATAL] Query Failed: SELECT
accounts.*,
email_addresses.email_address email_address,
'' email_addresses_non_primary, accounts.name as account_name,
users.user_name as assigned_user_name ,accounts_cstm.jjwg_maps_lng_c,accounts_cstm.jjwg_maps_lat_c,accounts_cstm.jjwg_maps_geocode_status_c,accounts_cstm.jjwg_maps_address_c FROM accounts LEFT JOIN users
ON accounts.assigned_user_id=users.id LEFT JOIN email_addr_bean_rel on accounts.id = email_addr_bean_rel.bean_id and email_addr_bean_rel.bean_module='Accounts' 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 accounts_cstm ON accounts.id = accounts_cstm.id_c where (((jt1.name like 'dYSTRBUTOR nad%')) AND accounts.deleted=0) AND ( accounts.deleted IS NULL OR accounts.deleted=0 ): MySQL error 1054: Unknown column 'jt1.name' in 'where clause'
Wed Jun 5 22:44:58 2019 [858519][1][FATAL] Exception handling in /home/rimerits/domains/folder.path.pl/public_html/CRM/include/MVC/Controller/SugarController.php:400
Wed Jun 5 22:44:58 2019 [858519][1][FATAL] Exception in Controller: Database failure. Please refer to suitecrm.log for details.
Wed Jun 5 22:44:58 2019 [858519][1][FATAL] backtrace:
#0 /home/folders/domains/folder.path.pl/public_html/CRM/include/database/DBManager.php(353): sugar_die('Database failur...')
#1 /home/folders/domains/folder.path.pl/public_html/CRM/include/database/DBManager.php(328): DBManager->registerError(' Query Failed: ...', ' Query Failed: ...', true)
#2 /home/folders/domains/folder.path.pl/public_html/CRM/include/database/MysqliManager.php(179): DBManager->checkError(' Query Failed: ...', true)
#3 /home/folders/domains/folder.path.pl/public_html/CRM/modules/SecurityGroups/MassAssign.php(54): MysqliManager->query('SELECT\n ...', true)
#4 /home/folders/domains/folder.path.pl/public_html/CRM/include/MVC/View/SugarView.php(834): include_once('/home/folders/...')
#5 /home/folders/domains/folder.path.pl/public_html/CRM/include/MVC/View/views/view.classic.php(72): SugarView->includeClassicFile('modules/Securit...')
#6 /home/folders/domains/folder.path.pl/public_html/CRM/include/MVC/View/SugarView.php(226): ViewClassic->display()
#7 /home/folders/domains/folder.path.pl/public_html/CRM/include/MVC/Controller/SugarController.php(435): SugarView->process()
#8 /home/folders/domains/folder.path.pl/public_html/CRM/include/MVC/Controller/SugarController.php(375): SugarController->processView()
#9 /home/folders/domains/folder.path.pl/public_html/CRM/include/MVC/SugarApplication.php(113): SugarController->execute()
#10 /home/folders/domains/folder.path.pl/public_html/CRM/index.php(52): SugarApplication->execute()
#11 {main}

Possible Fix

Steps to Reproduce

Context

Your Environment

Version 7.11.5
Sugar Version 6.5.25 (Build 344)
on Ubuntu 18.04

Originally created by @robertmilowski on GitHub (Jun 5, 2019). #### Issue Tried to assign secuirty group to the accountes filtered by "member of" field. choose "Select All (43)" (More then 20 accounts) , next select group and press ASSIGN button, system failed with "Database failure. Please refer to suitecrm.log for details." #### Expected Behavior Group should be assign to all 43 accounts #### Actual Behavior system crash with "Database failure. Please refer to suitecrm.log for details." Unknown column 'jt1.name' in 'where clause' > Wed Jun 5 22:44:58 2019 [858519][1][FATAL] Mysqli_query failed. Wed Jun 5 22:44:58 2019 [858519][1][FATAL] Query Failed: SELECT accounts.*, email_addresses.email_address email_address, '' email_addresses_non_primary, accounts.name as account_name, users.user_name as assigned_user_name ,accounts_cstm.jjwg_maps_lng_c,accounts_cstm.jjwg_maps_lat_c,accounts_cstm.jjwg_maps_geocode_status_c,accounts_cstm.jjwg_maps_address_c FROM accounts LEFT JOIN users ON accounts.assigned_user_id=users.id LEFT JOIN email_addr_bean_rel on accounts.id = email_addr_bean_rel.bean_id and email_addr_bean_rel.bean_module='Accounts' 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 accounts_cstm ON accounts.id = accounts_cstm.id_c where (((jt1.name like 'dYSTRBUTOR nad%')) AND accounts.deleted=0) AND ( accounts.deleted IS NULL OR accounts.deleted=0 ): MySQL error 1054: **Unknown column 'jt1.name' in 'where clause'** Wed Jun 5 22:44:58 2019 [858519][1][FATAL] Exception handling in /home/rimerits/domains/folder.path.pl/public_html/CRM/include/MVC/Controller/SugarController.php:400 Wed Jun 5 22:44:58 2019 [858519][1][FATAL] Exception in Controller: Database failure. Please refer to suitecrm.log for details. Wed Jun 5 22:44:58 2019 [858519][1][FATAL] backtrace: #0 /home/folders/domains/folder.path.pl/public_html/CRM/include/database/DBManager.php(353): sugar_die('Database failur...') #1 /home/folders/domains/folder.path.pl/public_html/CRM/include/database/DBManager.php(328): DBManager->registerError(' Query Failed: ...', ' Query Failed: ...', true) #2 /home/folders/domains/folder.path.pl/public_html/CRM/include/database/MysqliManager.php(179): DBManager->checkError(' Query Failed: ...', true) #3 /home/folders/domains/folder.path.pl/public_html/CRM/modules/SecurityGroups/MassAssign.php(54): MysqliManager->query('SELECT\n ...', true) #4 /home/folders/domains/folder.path.pl/public_html/CRM/include/MVC/View/SugarView.php(834): include_once('/home/folders/...') #5 /home/folders/domains/folder.path.pl/public_html/CRM/include/MVC/View/views/view.classic.php(72): SugarView->includeClassicFile('modules/Securit...') #6 /home/folders/domains/folder.path.pl/public_html/CRM/include/MVC/View/SugarView.php(226): ViewClassic->display() #7 /home/folders/domains/folder.path.pl/public_html/CRM/include/MVC/Controller/SugarController.php(435): SugarView->process() #8 /home/folders/domains/folder.path.pl/public_html/CRM/include/MVC/Controller/SugarController.php(375): SugarController->processView() #9 /home/folders/domains/folder.path.pl/public_html/CRM/include/MVC/SugarApplication.php(113): SugarController->execute() #10 /home/folders/domains/folder.path.pl/public_html/CRM/index.php(52): SugarApplication->execute() #11 {main} #### Possible Fix #### Steps to Reproduce #### Context #### Your Environment Version 7.11.5 Sugar Version 6.5.25 (Build 344) on Ubuntu 18.04