Need Help.
I upgraded to 7.11.4 and now email templates are not loading when I am composing an email. The email template search box pops up but when I click on a template it doesn’t pull into the compose email window? Otherwise email work fine, can compose and send.
Suitecrm 7.11.4
PHP 7.2
MariaDB
Already checked permissions which are fine. Ran repair, rebuild javascript language. Tried different browsers. Following is error recent log:
Thu May 16 13:06:34 2019 [1760301][1][FATAL] Mysqli_query failed.
Thu May 16 13:06:34 2019 [1760301][1][FATAL] Query Failed: select * from WHERE id=‘null’ and deleted=0: 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 ‘WHERE id=‘null’ and deleted=0’ at line 1
Thu May 16 13:06:35 2019 [1760301][1][FATAL] MysqliManager: Empty query
Thu May 16 13:35:09 2019 [1812986][1][FATAL] Mysqli_query failed.
Thu May 16 13:35:09 2019 [1812986][1][FATAL] Query Failed: select * from WHERE id=‘null’ and deleted=0: 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 ‘WHERE id=‘null’ and deleted=0’ at line 1
Thu May 16 13:35:09 2019 [1812987][1][FATAL] Mysqli_query failed.
Thu May 16 13:35:09 2019 [1812987][1][FATAL] Query Failed: select * from WHERE id=‘null’ and deleted=0: 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 ‘WHERE id=‘null’ and deleted=0’ at line 1
Fri May 17 07:11:40 2019 [3677475][1][FATAL] Exception handling in /home/assuredf/public_html/crm/include/MVC/Controller/SugarController.php:400
Fri May 17 07:11:40 2019 [3677475][1][FATAL] Exception in Controller: Failed to parse Host URL ‘http://’
Fri May 17 07:11:40 2019 [3677475][1][FATAL] backtrace:
#0 /home/assuredf/public_html/crm/lib/Search/ElasticSearch/ElasticSearchClientBuilder.php(177): SuiteCRM\Search\ElasticSearch\ElasticSearchClientBuilder::sanitizeHost(Array)
#1 /home/assuredf/public_html/crm/lib/Search/ElasticSearch/ElasticSearchClientBuilder.php(63): SuiteCRM\Search\ElasticSearch\ElasticSearchClientBuilder::loadFromSugarConfig()
#2 /home/assuredf/public_html/crm/lib/Search/ElasticSearch/ElasticSearchIndexer.php(86): SuiteCRM\Search\ElasticSearch\ElasticSearchClientBuilder::getClient()
#3 /home/assuredf/public_html/crm/lib/Search/ElasticSearch/ElasticSearchIndexer.php(576): SuiteCRM\Search\ElasticSearch\ElasticSearchIndexer->__construct()
#4 /home/assuredf/public_html/crm/modules/Administration/repairDatabase.php(179): SuiteCRM\Search\ElasticSearch\ElasticSearchIndexer::repairElasticsearchIndex()
#5 /home/assuredf/public_html/crm/modules/Administration/QuickRepairAndRebuild.php(142): include_once(’/home/assuredf/…’)
#6 /home/assuredf/public_html/crm/modules/Administration/QuickRepairAndRebuild.php(124): RepairAndClear->repairDatabase()
#7 /home/assuredf/public_html/crm/modules/Administration/views/view.repair.php(61): RepairAndClear->repairAndClearAll(Array, Array, false, true)
#8 /home/assuredf/public_html/crm/include/MVC/View/SugarView.php(226): ViewRepair->display()
#9 /home/assuredf/public_html/crm/include/MVC/Controller/SugarController.php(435): SugarView->process()
#10 /home/assuredf/public_html/crm/include/MVC/Controller/SugarController.php(375): SugarController->processView()
#11 /home/assuredf/public_html/crm/include/MVC/SugarApplication.php(113): SugarController->execute()
#12 /home/assuredf/public_html/crm/index.php(52): SugarApplication->execute()
#13 {main}
Any suugestions?
Thanks
ES