Database failure when trying to configure inbound email

💬 General Discussion
1

Hi, when configuring inbound email I’m getting the following error, “Database failure. Please refer to suitecrm.log for details.”
Please see attached screenshot for the setting page. Thank you

2

This is the error log I’m getting.

Tue Jun 19 10:53:39 2018 [1484][b1f9c647-ec34-793b-dc8f-5b17f029977c][FATAL] log call at: modules/Administration/index.tpl:54 - MY_FRAME is not set

Tue Jun 19 10:54:05 2018 [1484][b1f9c647-ec34-793b-dc8f-5b17f029977c][FATAL] Mysqli_query failed.

Tue Jun 19 10:54:05 2018 [1484][b1f9c647-ec34-793b-dc8f-5b17f029977c][FATAL] Query Failed: UPDATE folders SET name = ‘INBOX (Email)’, parent_folder = ‘’, dynamic_query = ‘’, assign_to_id = ‘’, modified_by = ‘b1f9c647-ec34-793b-dc8f-5b17f029977c’ WHERE id = ‘bd200ba8-0c00-b07a-5b7e-5b28272b348c’: MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘s Email)’, parent_folder = ‘’, dynamic_query = ‘’, assign_to_id = ‘’, modified_b’ at line 1

Tue Jun 19 10:54:05 2018 [1484][b1f9c647-ec34-793b-dc8f-5b17f029977c][FATAL] Exception handling in C:\Bitnami\suitecrm-7.9.8-0\apps\suitecrm\htdocs\include\MVC\Controller\SugarController.php:402

Tue Jun 19 10:54:05 2018 [1484][b1f9c647-ec34-793b-dc8f-5b17f029977c][FATAL] Exception in Controller: Database failure. Please refer to suitecrm.log for details.

Tue Jun 19 10:54:05 2018 [1484][b1f9c647-ec34-793b-dc8f-5b17f029977c][FATAL] backtrace:
#0 C:\Bitnami\suitecrm-7.9.8-0\apps\suitecrm\htdocs\include\database\DBManager.php(353): sugar_die(‘Database failur…’)
#1 C:\Bitnami\suitecrm-7.9.8-0\apps\suitecrm\htdocs\include\database\DBManager.php(328): DBManager->registerError(’ Query Failed: …’, ’ Query Failed: …’, true)
#2 C:\Bitnami\suitecrm-7.9.8-0\apps\suitecrm\htdocs\include\database\MysqliManager.php(177): DBManager->checkError(’ Query Failed: …’, true)
#3 C:\Bitnami\suitecrm-7.9.8-0\apps\suitecrm\htdocs\include\SugarFolders\SugarFolders.php(1076): MysqliManager->query(‘UPDATE folders …’, true)
#4 C:\Bitnami\suitecrm-7.9.8-0\apps\suitecrm\htdocs\modules\InboundEmail\Save.php(328): SugarFolder->save()
#5 C:\Bitnami\suitecrm-7.9.8-0\apps\suitecrm\htdocs\include\MVC\View\SugarView.php(840): include_once(‘C:\Bitnami\suit…’)
#6 C:\Bitnami\suitecrm-7.9.8-0\apps\suitecrm\htdocs\include\MVC\View\views\view.classic.php(74): SugarView->includeClassicFile(‘modules/Inbound…’)
#7 C:\Bitnami\suitecrm-7.9.8-0\apps\suitecrm\htdocs\include\MVC\View\SugarView.php(207): ViewClassic->display()
#8 C:\Bitnami\suitecrm-7.9.8-0\apps\suitecrm\htdocs\include\MVC\Controller\SugarController.php(432): SugarView->process()
#9 C:\Bitnami\suitecrm-7.9.8-0\apps\suitecrm\htdocs\include\MVC\Controller\SugarController.php(375): SugarController->processView()
#10 C:\Bitnami\suitecrm-7.9.8-0\apps\suitecrm\htdocs\include\MVC\SugarApplication.php(109): SugarController->execute()
#11 C:\Bitnami\suitecrm-7.9.8-0\apps\suitecrm\htdocs\index.php(52): SugarApplication->execute()
#12 {main}

3

The issue was resolved by renaming the inbound mail group name it should not contain spaces and non-alphabetical characters.