Menu
Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1
  • 2

TOPIC: v7.11.1 - Campaign email variables fail: [ERROR] Unable to find relationship emails_email_templates

v7.11.1 - Campaign email variables fail: [ERROR] Unable to find relationship emails_email_templates 5 months 3 days ago #77800

  • stephenmchugh
  • stephenmchugh's Avatar
  • Offline
  • Senior Member
  • Posts: 67
  • Thank you received: 6
  • Karma: 0
Campaign email variables ($contact_firs_name etc.) are not populated. Test emails are successfully delivered. Bounced email are successfully processed.

New upgrade to v7.11.1 and PHP Version 7.2.15 and ubuntu0.18.04.1

The only error that gets logged is below. Connected or coincidence?

Thu Feb 14 12:51:11 2019 [11916][1][ERROR] Unable to find relationship emails_email_templates
Thu Feb 14 12:51:11 2019 [11916][1][ERROR] Saving Email with invalid From name and/or Address. Details:
From field is not set.
From-name is not set.
From name is not set.
codes:1, 7, 10
The administrator has disabled public write access.

v7.11.1 - Campaign email variables fail: [ERROR] Unable to find relationship emails_email_templates 5 months 19 hours ago #77910

  • pgr
  • pgr's Avatar
  • Offline
  • Administrator
  • Posts: 10481
  • Thank you received: 1563
  • Karma: 359
Since this is an upgrade, I suggest removing and re-adding email accounts to try and get rid of those log messages.

The code to replace variables has been touched in this release, to fix bugs. It is possible that some other new bug was introduced, but I haven't seen others complaining, and this was tested specifically before release.

Please try my suggestion and then keep me updated on this. Thanks.

My SuiteCRM In-depth blog.
Thank you for always stating your SuiteCRM version, checking your logs, reading the Docs, and searching before you ask!
The administrator has disabled public write access.

v7.11.1 - Campaign email variables fail: [ERROR] Unable to find relationship emails_email_templates 4 months 4 weeks ago #77938

  • stephenmchugh
  • stephenmchugh's Avatar
  • Offline
  • Senior Member
  • Posts: 67
  • Thank you received: 6
  • Karma: 0
@PGR, which "email accounts"? Just the outgoing? Or both outgoing and incoming, including the bounce handling?

If I remove the bounce handling account, will that affect existing campaigns which are still using it?
The administrator has disabled public write access.

v7.11.1 - Campaign email variables fail: [ERROR] Unable to find relationship emails_email_templates 4 months 4 weeks ago #77947

  • stephenmchugh
  • stephenmchugh's Avatar
  • Offline
  • Senior Member
  • Posts: 67
  • Thank you received: 6
  • Karma: 0
Problem is worse now. I removed all email accounts (inbound and outbound) then created a new SMTP outbound account. Email won't send now.

Also, even when I delete ALL email accounts, iI can still see the old Outbound account in my Profile >> Email Settings >> "Outgoing SMTP Mail Servers"

That shouldn't be there, right?
The administrator has disabled public write access.

v7.11.1 - Campaign email variables fail: [ERROR] Unable to find relationship emails_email_templates 4 months 4 weeks ago #77952

  • pgr
  • pgr's Avatar
  • Offline
  • Administrator
  • Posts: 10481
  • Thank you received: 1563
  • Karma: 359
Remember that Accounts are set both in individual user's accounts, and in Admin / Outbound Email and Admin / Inbound Email.

When I get confused about configurations I always find it helpful to track things directly from the database, tables inbound_email and outbound_email

My SuiteCRM In-depth blog.
Thank you for always stating your SuiteCRM version, checking your logs, reading the Docs, and searching before you ask!
The administrator has disabled public write access.

v7.11.1 - Campaign email variables fail: [ERROR] Unable to find relationship emails_email_templates 4 months 3 weeks ago #78326

  • scottcrumpler
  • scottcrumpler's Avatar
  • Offline
  • New Member
  • Posts: 10
  • Thank you received: 1
  • Karma: 0
Having the same problem with 7.11.2 - email variables are not populating in campaign emails.

This is a clean install of 7.11.2
Apache Version 2.4.38
PHP Version 7.2.15
MySQL Version 10.1.38-MariaDB

I created an email template with variables and sent it to a seed target list and the variables are blank in the sent e-mail:
Subject: , Tracking Variables for SuiteCRM
Message-ID: <EtXQT59mf1Eo3OTA28maZ2kyqWsATgX6fU7GyWETA@crm.regcfinvesting.com>
X-Mailer: PHPMailer 6.0.6 (https://github.com/PHPMailer/PHPMailer)
X-CampTrackID: dfb294f1-2062-c814-d43c-5c71574f487e
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="b1_EtXQT59mf1Eo3OTA28maZ2kyqWsATgX6fU7GyWETA"

--b1_EtXQT59mf1Eo3OTA28maZ2kyqWsATgX6fU7GyWETA
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

Tracking Variables

- First Name:=20
- Last Name:=20
- Full Name:=20


To remove yourself from this email list go to https://crm.regcfinvesting.co=
m/index.php?entryPoint=3Dremoveme&identifier=3Ddfb294f1-2062-c814-d43c-5c71=
574f487e
The administrator has disabled public write access.

v7.11.1 - Campaign email variables fail: [ERROR] Unable to find relationship emails_email_templates 4 months 3 weeks ago #78327

  • stephenmchugh
  • stephenmchugh's Avatar
  • Offline
  • Senior Member
  • Posts: 67
  • Thank you received: 6
  • Karma: 0
@scott, there’s another thread on the same issue, link below. I will attempt to create an issue in Github early next week. As far as I can see, the devs think they have fixed this new problem (email variable used to work fine for me, back in 7.10.7) but they haven’t. It seems it works for some and not for others.

Try this link: suitecrm.com/suitecrm/forum/suitecrm-7-0...late-insert-variable
The administrator has disabled public write access.

v7.11.1 - Campaign email variables fail: [ERROR] Unable to find relationship emails_email_templates 4 months 3 weeks ago #78412

  • scottcrumpler
  • scottcrumpler's Avatar
  • Offline
  • New Member
  • Posts: 10
  • Thank you received: 1
  • Karma: 0
stephenmchugh wrote:
@scott, there’s another thread on the same issue, link below. I will attempt to create an issue in Github early next week. As far as I can see, the devs think they have fixed this new problem (email variable used to work fine for me, back in 7.10.7) but they haven’t. It seems it works for some and not for others.

Try this link: suitecrm.com/suitecrm/forum/suitecrm-7-0...late-insert-variable

@stephenmchugh: Thanks for following up and for creating an issue for this when you get a chance. Hopefully they can release an update with a fix soon. This functionality is pretty critical to CRM.

Cheers,
Scott
The administrator has disabled public write access.

v7.11.1 - Campaign email variables fail: [ERROR] Unable to find relationship emails_email_templates 4 months 2 weeks ago #78568

  • stephenmchugh
  • stephenmchugh's Avatar
  • Offline
  • Senior Member
  • Posts: 67
  • Thank you received: 6
  • Karma: 0
scottcrumpler wrote:
@stephenmchugh: Thanks for following up and for creating an issue for this when you get a chance. Hopefully they can release an update with a fix soon. This functionality is pretty critical to CRM.
Agreed, this is core functionality. I didn't need to create a new issue. I've updated an existing issue in Github (issue link below) but the devs closed it back in January, presumably because they think they've fixed it! I guess you and I are living proof they are mistaken ;-)

I've asked @pgr how to get it re-opened. Stand by for an answer.

github.com/salesagility/SuiteCRM/issues/6535
The administrator has disabled public write access.

v7.11.1 - Campaign email variables fail: [ERROR] Unable to find relationship emails_email_templates 4 months 6 days ago #78931

  • stephenmchugh
  • stephenmchugh's Avatar
  • Offline
  • Senior Member
  • Posts: 67
  • Thank you received: 6
  • Karma: 0
@scott, the issue on Github has been re-opened. It's labeled as High Priority so fingers crossed......
The administrator has disabled public write access.
The following user(s) said Thank You: scottcrumpler

v7.11.1 - Campaign email variables fail: [ERROR] Unable to find relationship emails_email_templates 3 months 3 weeks ago #79482

  • scottcrumpler
  • scottcrumpler's Avatar
  • Offline
  • New Member
  • Posts: 10
  • Thank you received: 1
  • Karma: 0
@stephenmchugh - thanks for the update! Fingers crossed, indeed!

I really want to be able to shift more of my email marketing to Suite and this is definitely an impediment. I actually tried switching my PHP version down to 7.1 and then upgraded to 7.3 just to see if it was a weird PHP issue, but the problem persists regardless.


Cheers,

Scott
The administrator has disabled public write access.

v7.11.1 - Campaign email variables fail: [ERROR] Unable to find relationship emails_email_templates 3 months 3 weeks ago #79485

  • stephenmchugh
  • stephenmchugh's Avatar
  • Offline
  • Senior Member
  • Posts: 67
  • Thank you received: 6
  • Karma: 0
I don't get it. Perhaps @PGR or someone from Sales Agility could comment? We are seriously considering moving to the Sales Agility hosted service but my problem is that no-one seems concerned that this key functionality doesn't work. I can only assume that no-one is using SuiteCRM for e-mail marketing because lead variables don't work! If that assumption is correct, are there other issues I don't about?
The administrator has disabled public write access.

v7.11.1 - Campaign email variables fail: [ERROR] Unable to find relationship emails_email_templates 3 months 3 weeks ago #79488

  • stephenmchugh
  • stephenmchugh's Avatar
  • Offline
  • Senior Member
  • Posts: 67
  • Thank you received: 6
  • Karma: 0
@scott... did you see this thread? !!!!!

suitecrm.com/suitecrm/forum/suitecrm-7-0...uitecrm-7-10-7#79337
The administrator has disabled public write access.
The following user(s) said Thank You: pgr

v7.11.1 - Campaign email variables fail: [ERROR] Unable to find relationship emails_email_templates 3 months 6 days ago #80232

  • scottcrumpler
  • scottcrumpler's Avatar
  • Offline
  • New Member
  • Posts: 10
  • Thank you received: 1
  • Karma: 0
@stephenmchugh - My problem with the target list variables is occurring on a clean 7.11.x install, and those changes already appear to be there, so unfortunately I don't see a fix there. Did you try doing something with that, and did it work?
Last Edit: 3 months 6 days ago by scottcrumpler.
The administrator has disabled public write access.

v7.11.1 - Campaign email variables fail: [ERROR] Unable to find relationship emails_email_templates 3 months 6 days ago #80234

  • stephenmchugh
  • stephenmchugh's Avatar
  • Offline
  • Senior Member
  • Posts: 67
  • Thank you received: 6
  • Karma: 0
No, Target and Lead variables not working here (7.11.3) for Campaigns which is frustrating because it’s key functionality for any CRM. Double the frustration because it used to work fine back in the early days of 7.10

However, Contact variables DO work. I can only confirm that last name and first name for a Contact work, as they are the only two I tested.

I haven’t tested variables in one-off emails but I understand from other threads that they are borked too.

Rgds

‘Angry from Manchester’ :P
The administrator has disabled public write access.
  • Page:
  • 1
  • 2
Time to create page: 0.059 seconds
Powered by Kunena Forum