Hi, I am having an issue in mass updating. Whenever I mass update the selected records on the present page, it works fine but when I select all like the records on all pages for mass update it gives an error “Database failure, check suitecrm.log for detials”. And when I check the suitecrm.log details it the gives the logs below:
Tue Jan 22 09:05:43 2019 [8946][e8bf0558-eb5b-c14b-9e92-5acbdf02d461][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.short_key_c,accounts_cstm.jjwg_maps_lng_c,accounts_cstm.jjwg_maps_geoco$
ON accounts.assigned_user_id=users.id LEFT JOIN email_addr_bean_rel on accounts.id = email_addr_bean_rel.bean_id a$
Tue Jan 22 09:05:43 2019 [8946][e8bf0558-eb5b-c14b-9e92-5acbdf02d461][FATAL] Exception handling in /var/www/html/include/MVC/Controller/SugarController.php:$
Tue Jan 22 09:05:43 2019 [8946][e8bf0558-eb5b-c14b-9e92-5acbdf02d461][FATAL] Exception in Controller: Database failure. Please refer to suitecrm.log for det$
Tue Jan 22 09:05:43 2019 [8946][e8bf0558-eb5b-c14b-9e92-5acbdf02d461][FATAL] backtrace:
#0 /var/www/html/include/database/DBManager.php(353): sugar_die(‘Database failur…’)
#1 /var/www/html/include/database/DBManager.php(328): DBManager->registerError(’ Query Failed: …’, ’ Query Failed: …’, true)
#2 /var/www/html/include/database/MysqliManager.php(179): DBManager->checkError(’ Query Failed: …’, true)
#3 /var/www/html/modules/SecurityGroups/MassAssign.php(54): MysqliManager->query(‘SELECT\n …’, true)
#4 /var/www/html/include/MVC/View/SugarView.php(818): include_once(’/var/www/html/m…’)
#5 /var/www/html/include/MVC/View/views/view.classic.php(72): SugarView->includeClassicFile(‘modules/Securit…’)
#6 /var/www/html/include/MVC/View/SugarView.php(211): ViewClassic->display()
#7 /var/www/html/include/MVC/Controller/SugarController.php(435): SugarView->process()
#8 /var/www/html/include/MVC/Controller/SugarController.php(375): SugarController->processView()
#9 /var/www/html/include/MVC/SugarApplication.php(113): SugarController->execute()
#10 /var/www/html/index.php(52): SugarApplication->execute()
#11 {main}
Tue Jan 22 09:06:02 2019 [9034][1][FATAL] Mysqli_query failed.
Tue Jan 22 09:06:02 2019 [9034][1][FATAL] Query Failed: SELECT port_porting.id AS id FROM port_porting LEFT JOIN port_porting_cstm port_porting_cstm ON port_porting.id = port_porting_cstm.id_c WHERE port_porting_cstm.status_c != ‘Done’ AND port_porting.date_entered = DATE_ADD(port_porting., INTERVAL) AND port_porting.deleted = 0 : MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server veersion for the right syntax to use near ’ INTERVAL ) AND port_porting.deleted = 0’ at line 1