by Rolustech

SuiteCRM Plugin that bridges the gap between Twilio & SuiteCRM. To establish connection with your customers, A state-of-the-art Telephony solution for Voice (Inbound and Outbound) and SMS to run your business more efficiently and cost effectively. Works great with both VOIP and Land Lines.

Free 30 day trial
Try it Now

#778 - MySQL Error when trying to save settings

Closed Installation created by robl 6 years ago

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)

0 C:\Websites\modules\rolus_Twilio_Account\index.php(32): require_once()

1 C:\Websites\include\MVC\View\SugarView.php(761): include_once('C:\Websites\mod...')

2 C:\Websites\include\MVC\View\views\view.classic.php(74): SugarView->includeClassicFile('modules/rolus_T...')

3 C:\Websites\include\MVC\View\SugarView.php(169): ViewClassic->display()

4 C:\Websites\include\MVC\Controller\SugarController.php(371): SugarView->process()

5 C:\Websites\include\MVC\Controller\SugarController.php(318): SugarController->processView()

6 C:\Websites\include\MVC\SugarApplication.php(105): SugarController->execute()

7 C:\Websites\index.php(52): SugarApplication->execute()

8

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...