Email dashlet not showing recent emails and tons of Unable to find relationship emails_email_templates errors

SuiteCRM Forum - English Language SuiteCRM General Discussion
#1

After upgrading to 7.12.2

  1. Emails dashlet does not show recent emails after the upgrade date
  2. Refreshing the dashlet generates the following errors

Tue Jan 18 20:09:40 2022 [94088][a9d61101-30c5-40d7-8128-587a4f72fb34][ERROR] Unable to find relationship emails_email_templates
Tue Jan 18 20:09:40 2022 [94088][a9d61101-30c5-40d7-8128-587a4f72fb34][ERROR] Invalid email address given: [*** *** <@***.com>] Called at C:\Bitnami\wampstack-7.1.33-0\apps\suitecrm\include\ListView\ListViewData.php:444 from function get_list_view_data.

Lots of errors for different emails are displayed. Not sure if it’s related but auto-import of emails is also having issues.

#2

Hi @binfer,

What version were you on before the update?
What version of PHP are you using?
Are your location permissions configured as suggested in the install guide?

#3

What version were you on before the update? 7.12
What version of PHP are you using? php-7.3.22-Win32-VC15-x64
Are your location permissions configured as suggested in the install guide? Yes. we are running on windows.

#4

Not sure if the issues are connected but every time I send an email. I see the following log dump in suitecrm.log. And the contact to which the email is sent shows the email in the history but the contact column is blank.

Tue Jan 25 11:29:47 2022 [108660][a9d61101-30c5-40d7-8128-587a4f72fb34][ERROR] Unable to find relationship emails_email_templates
Tue Jan 25 11:29:47 2022 [108660][a9d61101-30c5-40d7-8128-587a4f72fb34][ERROR] Saving Email with invalid From name and/or Address. Details:
From field is not set.
From-name is not set.
From name is empty.
From address and name pair format is incorrect, use "from@emailaddress.org " format.
From address and name pair is invalid.
codes:1, 7, 11, 16, 15
Tue Jan 25 11:29:47 2022 [108660][a9d61101-30c5-40d7-8128-587a4f72fb34][ERROR] Unable to find relationship emails_email_templates
Tue Jan 25 11:29:47 2022 [108660][a9d61101-30c5-40d7-8128-587a4f72fb34][ERROR] Array
(
[0] => Unhandled email save and store as sent error: 0
[1] => 6
)

Tue Jan 25 11:29:49 2022 [108660][a9d61101-30c5-40d7-8128-587a4f72fb34][ERROR] Unable to find relationship emails_email_templates
Tue Jan 25 11:29:49 2022 [108660][a9d61101-30c5-40d7-8128-587a4f72fb34][ERROR] Unable to find relationship emails_email_templates
Tue Jan 25 11:29:49 2022 [108660][a9d61101-30c5-40d7-8128-587a4f72fb34][ERROR] Unable to find relationship emails_email_templates
Tue Jan 25 11:29:49 2022 [108660][a9d61101-30c5-40d7-8128-587a4f72fb34][ERROR] ImapHandler trying to use a non valid resource stream.
Tue Jan 25 11:29:49 2022 [108660][a9d61101-30c5-40d7-8128-587a4f72fb34][ERROR] ImapHandler trying to use a non valid resource stream.