by Rolustech

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.

Free 30 day trial
Try it Now

#778 - MySQL Error when trying to save settings

Closed Installation created by robl 7 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...