Unify communications within SuiteCRM! Leverage Twilio to make calls, send SMS chats, and launch SMS campaigns directly from your CRM. Enhance customer engagement and streamline workflows.
#778 - MySQL Error when trying to save settings
SuiteCRM log shows 10 of these errors (1 for each user I have): Fri Nov 17 17:15:17 2017 [2912][1][FATAL] Query Failed: UPDATE users SET extension='',voip_access='',allow_phone_mobile='',allow_phone_work='',allow_phone_home='',allow_phone_other='',allow_browser='' WHERE id='1': MySQL error 1366: Incorrect integer value: '' for column 'allow_phone_mobile' at row 1
Then I see errors like: Fri Nov 17 17:33:02 2017 [3436][1][FATAL] Caught settingsException ('Data missing') settingsException 'Data missing' in C:\Websites\modules\rolus_Twilio_Account\rolus_Twilio_Account_sugar.php(112)
0 C:\Websites\modules\rolus_Twilio_Account\fetch_verified_numbers.php(22): rolus_Twilio_Account_sugar->getClient()
1 C:\Websites\modules\rolus_Twilio_Account\index.php(32): require_once('C:\Websites\mod...')
2 C:\Websites\include\MVC\View\SugarView.php(761): include_once('C:\Websites\mod...')
3 C:\Websites\include\MVC\View\views\view.classic.php(74): SugarView->includeClassicFile('modules/rolus_T...')
4 C:\Websites\include\MVC\View\SugarView.php(169): ViewClassic->display()
5 C:\Websites\include\MVC\Controller\SugarController.php(371): SugarView->process()
6 C:\Websites\include\MVC\Controller\SugarController.php(318): SugarController->processView()
7 C:\Websites\include\MVC\SugarApplication.php(105): SugarController->execute()
8 C:\Websites\index.php(52): SugarApplication->execute()
9
Fri Nov 17 17:33:02 2017 [3436][1][FATAL] Caught settingsException ('Cannot connect to Twilio') settingsException 'Cannot connect to Twilio' in C:\Websites\modules\rolus_Twilio_Account\fetch_verified_numbers.php(24)