Email templates not loading

drivevertical · 17 May 2019 11:57

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

pgr · 18 May 2019 10:47

Maybe you can try to get your elasticSearch configuration correct so this error doesn’t occur. It might be breaking other things in the app.

Check your host URL for Elastic and the rest of the installation instructions:

https://docs.suitecrm.com/admin/administration-panel/search/elasticsearch/

drivevertical · 18 May 2019 12:13

The thing is we never configured or touched Elasticsearch since upgrading to 7.11 - it’s still set to Basic+Advance so I don’t know why Elasticsearch errors are show up? I know that the templates where working fine when it was 7.10.15 but now after upgrading it doesn’t. Composing and sending emails does.

ES

colorin · 18 May 2019 21:58

Hi,
i also have the same problem, mine is a new installation, among other things I also tested suitecrm demo and there is the same problem.
Thanks in advance for the help

Suitecrm 7.11.4
PHP 7.2
Mysql

drivevertical · 20 May 2019 13:42

I think this is a problem with 7.11.4 as I have seen others recently posted same problem.

Ed

pgr · 20 May 2019 17:48

I can’t reproduce on my installation.

Can somebody please provide exact steps? I would like to try on the same module where you are, coming from the same screen, pressing the same button etc.

drivevertical · 20 May 2019 18:51

Steps:

Click on Leads or Contacts
Click on email address in list view (have also tried in detail view)
Compose email pops up
Click Templates
Select a email template
Goes back to Compose Email but Template doesn’t fill in - nothing happens

I have tried on IE, Edge and Chrome without luck.

Ed

pgr · 21 May 2019 08:59

Sorry, works for me :huh:

The only thing strange that I see is that when I click the email address, I get two “compose” windows: one within SuiteCRM, and another that Windows opens on the Desktop with my default email client (Thunderbird).

Do you see any Javascript errors in your browser’s Developer console?

drivevertical · 21 May 2019 11:33

Ok, checked browser for any errors and did get this:

Line 50
Object Missing

and then this is the code - line 50 is the after the result data line.


else{fill_array_contents(the_key,field_to_name_array[the_key]);}}}
var popupConfirm=confirmDialog(array_contents,form_name);var name_to_value_array=JSON.parse('{'+array_contents.join(",")+'}')
closePopup();var result_data={"form_name":form_name,"name_to_value_array":name_to_value_array,"passthru_data":passthru_data,"popupConfirm":popupConfirm};call_back_function(result_data);}
function send_back_teams(module,form,field,error_message,request_data,form_team_id){var array_contents=Array();if(form_team_id){array_contents.push(form_team_id);}else{var j=0;for(i=0;i<form.elements.length;i++){if(form.elements[i].name==field){if(form.elements[i].checked==true){array_contents.push(form.elements[i].value);}}}}
if(array_contents.length==0){window.alert(error_message);return;}

I think it has something to do with this since this is the code for the templates and reference popup and data passthru.

ES

drivevertical · 21 May 2019 16:09

I just registered and tried doing this with suitecrm demo which is running 7.11.4 and it’s also doing the same thing not pulling the email template when composing an email.

So I thinks this is a 7.11.4 issue since it’s happening on your environment and with your online demo.

ES

drivevertical · 22 May 2019 11:25

Any suggestions?

ES

drivevertical · 22 May 2019 17:09

Further diagnosing and setup a new fresh install of suitecrm and email templates still not working.

ES

pgr · 23 May 2019 10:18

Maybe there is some difference in the way your Accounts are set up. Please make sure you fill all fields (reply-to, from-name, etc).

drivevertical · 23 May 2019 11:20

I checked but this isn’t working on suitecrm online demo and the new test install I did which would be default setup with no changes? Have you looked at the suitecrm online demo?

ES

pgr · 23 May 2019 16:10

I assume it is not working on the online demo, because you said so - I don’t need to go and check because I believe you

But since it is working in my installation, I was wondering if it could be related to the way the email account is configured. For example, on the live demo you can’t configure an account, can you?

This is why I made my request above for you to try adding every field in the configuration.

BX_GROUP · 23 May 2019 17:28

Hi SuiteCRM.

Email Templates do not work for us on Version 7.10.16

Click on Contacts --> Click on Contact’s Email Address.
Click on Template Search arrow button
Click the search Search Template button
Click any template.

What should happen is: my email body should be replaced with the new body of the template.

What does happen is: Nothing - No javascript errors nor any errors in the php log or suitecrm log that I can find.

— Another way to reproduce:

Click on Emails
click Compose
Click Search template button
Click Search button in the pop-up search.
Click any template

What should happen is: my email body should be replaced with the new body/subject of the template.
What does happen is: Nothing. Again, no javascript errors nor any server log errors.

Just thought I’d share since this is a different version having similar issues as the poster here.

colorin · 23 May 2019 17:29

Hello,
I did various tests, even with the demo version, creating an email account but with the same problem. I also tried the 7.10.16 LTS version even with this one I can’t use the template.
Seems really weird, do you think it could be some package PHP missing?

pgr · 23 May 2019 17:53

You can try running

composer install

on your SuiteCRM directory to update the 3rd party packages. but this shouldn’t be necessary, they come in our own upgrade packages.

sfdan · 23 May 2019 19:52

I tried running composer install, it gave me an error because vendor/browserstack/browserstack-local doesn’t exist. I ran composer install --no-dev and running that didn’t seem to fix the email template issue.

pgr · 24 May 2019 10:00

Sorry,

composer install --no-dev

… was in fact the correct thing to try, my mistake.

If that didn’t help I think you might be getting this bug (which already has a proposed fix):

https://github.com/salesagility/SuiteCRM/issues/7271