Hyperlinks not showing up in e-mail notifications.

[nhellwig]

Whenever a new lead is assigned to a person, they receive a notification e-mail that looks like the following:

"Joe Smith has assigned a Lead to bmoore.

Name: Bruce Thomas
Lead Source: Employee
Status: Assigned
Description: This is a test account

You may review this Lead at:"

Everything is correct up to "You may reveiw this Lead at:". No hyperlink is sent with the notification e-mail, it is just left blank. I looked at the e-mail template and it appears to be correct showing <{URL}> where the URL is supposed to appear in the message. We are running SugarCRM Community Edition version 5.2.0e. Anyone have any ideas as to why the URL isn't appearing? Thanks in advance for any assistance.

Neil

[Angel]

Take a look at the config.php file for your install and verify that the site_url setting is defined.

[nhellwig]

Thanks for the reply Angel. The setting looks correct:

'site_url' => 'http://(our crm url)',

Of course the actual URL of our CRM is listed in the above example. Is there something that needs to be changed?

Thanks,

Neil

[Angel]

That would seem OK. That's a bit strange that it would generate the message, but not parse the URL.

Do you use e-mail templates within Sugar? If so, do you have any problems embedding fields and in turn, have them parse?

[nhellwig]

We are actually fairly new to SugarCRM so we haven't used the e-mail functions. We have been loading in leads and I am ready to start assigning them. This issue just came up when I started assigning leads to our sales staff. We haven't done anything out of the ordinary that I am aware of. I believe that it was a pretty standard installation. Could it possibly have anything to do with whether I am using the SugarCRM e-mail client or an external client? I wouldn't think so, but I thought I would ask.

Thanks,

Neil

[Angel]

No, I don't think it is due to that. Were that the case, you wouldn't receive the messages at all.

Something else is going on. It is possible that the e-mail template Sugar uses when sending the notification has become damaged in some way.

Take a look at the file <sugar>/include/language/en_us.notify_template.html

It contains a section that begins with the following:

<!-- BEGIN: Lead -->

and ends with

<!-- END: Lead -->

Copy the text between those tags and post it in your reply.

[nhellwig]

Here is the code:

<!-- BEGIN: Lead -->
{ASSIGNER} has assigned a Lead to {ASSIGNED_USER}.

Name: {LEAD_NAME}
Lead Source: {LEAD_SOURCE}
Status: {LEAD_STATUS}
Description: {LEAD_DESCRIPTION}

You may review this Lead at:
<{URL}>
<!-- END: Lead -->

Please let me know if something appears incorrect.

I also tried sending some e-mails with hyperlinks from SugarCRM to my personal account. All of the hyperlinks appeared as they should have when I checked my personal e-mail account.

Thanks,

Neil

[Angel]

That's rather bizarre. The template looks good and it is parsing the other fields. Kind of strange that it wouldn't parse URL.

A bit of a shot in the dark on my part, but have you taken a look at the sugarcrm.log file in the root of your install? Perhaps it contains further clues.

Not sure what else you could try that wouldn't require some hands-on troublehshooting.

[nhellwig]

I just tried assigning an account and a contact. The notification e-mails for each of these are missing the URL as well. This leads me to believe that there is something wrong with our listed URL since it appears that the issue is affecting all notifications.

[Angel]

That's weird because your site_url setting had something in it.

The real odd part about is that you are not even getting the text after the site_url value.

Open up <sugar>/data/SugarBean.php and check for this line:

$xtpl->assign("URL", $cleanUrl."/index.php?module={$this->module_dir}&action=DetailView&record={$this->id}");