After upgrade to 7.9.0

Everything looks fine except when I go to my email option I get this:

EMAILS
No results found for “basic_search”
Create “basic_search” as a new Email

© Supercharged by SuiteCRM © Powered By SugarCRM

Any thoughts before I roll it back? :slight_smile:

Phil

If you can please make a screenshot, I think it could be helpful. If you have trouble uploading it to the forums, just upload it to PasteBin or a similar service, and tell us the link.

And also, do your logs show any error when that screen shows?

thanks

Hey There

so image is here : https://imagebin.ca/v/3OAU7y3zupUf

And nothing showing in the logs other than :

Mon May 29 14:20:41 2017 [58522][-none-][FATAL] Query Failed: SELECT id FROM aow_workflow WHERE aow_workflow.flow_module = ‘ACLActions’ AND aow_workflow.status = ‘Active’ AND (aow_workflow.run_when = ‘Always’ OR aow_workflow.run_when = ‘On_Save’ OR aow_workflow.run_when = ‘Create’) AND aow_workflow.deleted = 0 : MySQL error 1146: Table ‘pdowling_pdsuitecrm.aow_workflow’ doesn’t exist

But this error is not occuring when I go to email.

BTW I had to rollback my live install. So this is a fully clean install and this is exactly the same error.

Phil

Please navigate to Admin -> Repair and run a Quick Repair & Rebuild. Once this runs, scroll to the bottom of the page and if there are any SQL queries click ‘Execute’.

But I’m afraid that might not be enough to solve it. I’ve seen that error in systems that failed to install completely, a problem which can then arise in many different forms. So I would say that FATAL error needs your attention, even if it doesn’t seem to cause directly the Emails module problem.

Can you check upgradeWizard.log and try and find out if there were any errors during installation? Sometimes the installer needs more memory or more time to complete (settings you can tweak in php.ini).

Hi there,

There are additional steps to this upgrade which are highlighted in the Release Notes below.

https://suitecrm.com/wiki/index.php/Release_notes_7.9.0

https://suitecrm.com/wiki/index.php/Release_notes_7.9.0_User_Guide

As we have revamped the Email Client you need to resync your IMAP accounts with SuiteCRM as we have made the prodominent table that older versions used (email_cache) redundant now.

Please check out these additional steps and then let us know how you get on.

Hi Samus

OK so I followed the instructions…

When I try to syn email I get :

Sync Inbound Email Account. This may take several minutes. Going away from this page will not cancel the process, so feel free to move on or wait for confirmation…
Processing ‘Tech’ Inbound Email Account…
0 record updated
Done Processing Inbound Email Accounts
IMAP errors detected

If I try to use the add function to add an email address on this screen in the screenshot below, nothing happens…:outbound works. But not for inbound.

https://imagebin.ca/v/3OFdUWY1kCIh

Following is the last several lines from my suitecrm.log which seems to indicate some issues. Would you be able to guide me to fixing these?

As a matter of note. The mail server I am using does present cert errors even though I am not using SSL. When I try to change the monitored inboxes I get this:

https://imagebin.ca/v/3OFgCoFaeMfp

This is my email setup - note no SSL selected.

https://imagebin.ca/v/3OFgNjlPEO2z

I am unsure if this is relevant to the issues I am having. However I thought I would mention it just in case. Although it is hard to adjust email settings with this issue. We’re on shared hosting so it’s a tricky problem to address as our domain name will not match the servers domain name.

Thanks for your help.

Phil

Tue May 30 08:02:26 2017 [25359][1][ERROR] Unable to find relationship emails_email_templates
Tue May 30 08:02:26 2017 [25359][1][FATAL] emails_email_templates_idb for emails_email_templates failed to load

Tue May 30 08:02:26 2017 [25359][1][ERROR] Unable to find relationship emails_email_templates
Tue May 30 08:02:26 2017 [25359][1][FATAL] emails_email_templates_idb for emails_email_templates failed to load

Tue May 30 08:02:26 2017 [25359][1][ERROR] Unable to find relationship emails_email_templates
Tue May 30 08:02:26 2017 [25359][1][FATAL] emails_email_templates_idb for emails_email_templates failed to load

Tue May 30 08:02:26 2017 [25359][1][ERROR] Unable to find relationship emails_email_templates
Tue May 30 08:02:26 2017 [25359][1][FATAL] emails_email_templates_idb for emails_email_templates failed to load

Tue May 30 08:02:26 2017 [25359][1][ERROR] IMAP error detected: SECURITY PROBLEM: insecure server advertised AUTH=PLAIN
Tue May 30 08:02:26 2017 [25359][1][ERROR] IMAP error detected: Client tried to access nonexistent namespace. (Mailbox name should probably be prefixed with: INBOX.) (0.001 + 0.000 secs).

As a side note.

I seem to be having very similar issues to the author of this:

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

Phil

I posted too quick, seems like there is a small delay in the logging.

Here is the last few lines of my suitecrm.log

Tue May 30 08:18:19 2017 [81691][1][ERROR] Unable to find relationship emails_email_templates
Tue May 30 08:18:19 2017 [81691][1][FATAL] emails_email_templates_idb for emails_email_templates failed to load

Tue May 30 08:18:19 2017 [81691][1][ERROR] Unable to find relationship emails_email_templates
Tue May 30 08:18:19 2017 [81691][1][FATAL] emails_email_templates_idb for emails_email_templates failed to load

Tue May 30 08:18:19 2017 [81691][1][ERROR] Unable to find relationship emails_email_templates
Tue May 30 08:18:19 2017 [81691][1][FATAL] emails_email_templates_idb for emails_email_templates failed to load

Tue May 30 08:18:19 2017 [81691][1][ERROR] Unable to find relationship emails_email_templates
Tue May 30 08:18:19 2017 [81691][1][FATAL] emails_email_templates_idb for emails_email_templates failed to load

Tue May 30 08:18:19 2017 [81691][1][ERROR] IMAP error detected: SECURITY PROBLEM: insecure server advertised AUTH=PLAIN
Tue May 30 08:18:19 2017 [81691][1][ERROR] IMAP error detected: Client tried to access nonexistent namespace. (Mailbox name should probably be prefixed with: INBOX.) (0.001 + 0.000 secs).
Tue May 30 08:21:02 2017 [91574][1][ERROR] Unable to find relationship emails_email_templates
Tue May 30 08:21:02 2017 [91574][1][FATAL] emails_email_templates for emails_email_templates failed to load

Tue May 30 08:21:02 2017 [91574][1][FATAL] Failed to load relationship emails_email_templates while saving Emails

Phil

I am having the exact same problem. Empty email view.

I have had success by editing the email accounts within [Profile] and reselecting the “Monitored Folders”, “Trash” and “Sent” folders again. This seems to repopulate the appropriate fields allows the Email Centre to show.

So it would be lovely to be able to even be able to edit the email settings under profile. However when I click add (because I need to add the email account) I get nothing at all. But I do have this in the error_log:

[14-Jun-2017 09:17:45 America/Chicago] PHP Notice:  Trying to get property of non-object in /home1/l5y9y2w4/public_html/crmregent/modules/Emails/EmailUI.php on line 392
[14-Jun-2017 09:17:45 America/Chicago] PHP Notice:  Trying to get property of non-object in /home1/l5y9y2w4/public_html/crmregent/modules/Emails/EmailUI.php on line 393
[14-Jun-2017 09:17:45 America/Chicago] PHP Notice:  Trying to get property of non-object in /home1/l5y9y2w4/public_html/crmregent/modules/Emails/EmailUI.php on line 393
[14-Jun-2017 09:17:45 America/Chicago] PHP Notice:  Trying to get property of non-object in /home1/l5y9y2w4/public_html/crmregent/modules/Emails/EmailUI.php on line 393
[14-Jun-2017 09:17:45 America/Chicago] PHP Notice:  Trying to get property of non-object in /home1/l5y9y2w4/public_html/crmregent/modules/Emails/EmailUI.php on line 392
[14-Jun-2017 09:17:45 America/Chicago] PHP Notice:  Trying to get property of non-object in /home1/l5y9y2w4/public_html/crmregent/modules/Emails/EmailUI.php on line 393
[14-Jun-2017 09:17:45 America/Chicago] PHP Notice:  Trying to get property of non-object in /home1/l5y9y2w4/public_html/crmregent/modules/Emails/EmailUI.php on line 393
[14-Jun-2017 09:17:45 America/Chicago] PHP Notice:  Trying to get property of non-object in /home1/l5y9y2w4/public_html/crmregent/modules/Emails/EmailUI.php on line 393
[14-Jun-2017 09:17:45 America/Chicago] PHP Notice:  Trying to get property of non-object in /home1/l5y9y2w4/public_html/crmregent/modules/Emails/EmailUI.php on line 392
[14-Jun-2017 09:17:45 America/Chicago] PHP Notice:  Trying to get property of non-object in /home1/l5y9y2w4/public_html/crmregent/modules/Emails/EmailUI.php on line 393
[14-Jun-2017 09:17:45 America/Chicago] PHP Notice:  Trying to get property of non-object in /home1/l5y9y2w4/public_html/crmregent/modules/Emails/EmailUI.php on line 393
[14-Jun-2017 09:17:45 America/Chicago] PHP Notice:  Trying to get property of non-object in /home1/l5y9y2w4/public_html/crmregent/modules/Emails/EmailUI.php on line 393
[14-Jun-2017 09:17:45 America/Chicago] PHP Notice:  Trying to get property of non-object in /home1/l5y9y2w4/public_html/crmregent/modules/Emails/EmailUI.php on line 392
[14-Jun-2017 09:17:45 America/Chicago] PHP Notice:  Trying to get property of non-object in /home1/l5y9y2w4/public_html/crmregent/modules/Emails/EmailUI.php on line 393
[14-Jun-2017 09:17:45 America/Chicago] PHP Notice:  Trying to get property of non-object in /home1/l5y9y2w4/public_html/crmregent/modules/Emails/EmailUI.php on line 393
[14-Jun-2017 09:17:45 America/Chicago] PHP Notice:  Trying to get property of non-object in /home1/l5y9y2w4/public_html/crmregent/modules/Emails/EmailUI.php on line 393
[14-Jun-2017 09:20:31 America/Chicago] PHP Notice:  Trying to get property of non-object in /home1/l5y9y2w4/public_html/crmregent/modules/Emails/EmailUI.php on line 392
[14-Jun-2017 09:20:31 America/Chicago] PHP Notice:  Trying to get property of non-object in /home1/l5y9y2w4/public_html/crmregent/modules/Emails/EmailUI.php on line 393
[14-Jun-2017 09:20:31 America/Chicago] PHP Notice:  Trying to get property of non-object in /home1/l5y9y2w4/public_html/crmregent/modules/Emails/EmailUI.php on line 393
[14-Jun-2017 09:20:31 America/Chicago] PHP Notice:  Trying to get property of non-object in /home1/l5y9y2w4/public_html/crmregent/modules/Emails/EmailUI.php on line 393
[14-Jun-2017 09:20:31 America/Chicago] PHP Notice:  Trying to get property of non-object in /home1/l5y9y2w4/public_html/crmregent/modules/Emails/EmailUI.php on line 392
[14-Jun-2017 09:20:31 America/Chicago] PHP Notice:  Trying to get property of non-object in /home1/l5y9y2w4/public_html/crmregent/modules/Emails/EmailUI.php on line 393
[14-Jun-2017 09:20:31 America/Chicago] PHP Notice:  Trying to get property of non-object in /home1/l5y9y2w4/public_html/crmregent/modules/Emails/EmailUI.php on line 393
[14-Jun-2017 09:20:31 America/Chicago] PHP Notice:  Trying to get property of non-object in /home1/l5y9y2w4/public_html/crmregent/modules/Emails/EmailUI.php on line 393
[14-Jun-2017 09:20:32 America/Chicago] PHP Notice:  Trying to get property of non-object in /home1/l5y9y2w4/public_html/crmregent/modules/Emails/EmailUI.php on line 392
[14-Jun-2017 09:20:32 America/Chicago] PHP Notice:  Trying to get property of non-object in /home1/l5y9y2w4/public_html/crmregent/modules/Emails/EmailUI.php on line 393
[14-Jun-2017 09:20:32 America/Chicago] PHP Notice:  Trying to get property of non-object in /home1/l5y9y2w4/public_html/crmregent/modules/Emails/EmailUI.php on line 393
[14-Jun-2017 09:20:32 America/Chicago] PHP Notice:  Trying to get property of non-object in /home1/l5y9y2w4/public_html/crmregent/modules/Emails/EmailUI.php on line 393
[14-Jun-2017 09:20:32 America/Chicago] PHP Notice:  Trying to get property of non-object in /home1/l5y9y2w4/public_html/crmregent/modules/Emails/EmailUI.php on line 392
[14-Jun-2017 09:20:32 America/Chicago] PHP Notice:  Trying to get property of non-object in /home1/l5y9y2w4/public_html/crmregent/modules/Emails/EmailUI.php on line 393
[14-Jun-2017 09:20:32 America/Chicago] PHP Notice:  Trying to get property of non-object in /home1/l5y9y2w4/public_html/crmregent/modules/Emails/EmailUI.php on line 393
[14-Jun-2017 09:20:32 America/Chicago] PHP Notice:  Trying to get property of non-object in /home1/l5y9y2w4/public_html/crmregent/modules/Emails/EmailUI.php on line 393

Again, I am going to leave this upgraded to see if we can make progress. However, I cannot leave it long term as we do not have the option for a test system. So if anyone has any relatively quick ideas, it would be much appreciated!

Phil

And again…

I am also seeing this in the suitecrm_log

Wed Jun 14 09:19:01 2017 [511165][1][ERROR] Unable to find relationship emails_email_templates
Wed Jun 14 09:19:01 2017 [511165][1][FATAL] emails_email_templates for emails_email_templates failed to load

Wed Jun 14 09:19:01 2017 [511165][1][FATAL] Failed to load relationship emails_email_templates while saving Emails
Wed Jun 14 09:19:01 2017 [511165][1][ERROR] Unable to find relationship emails_email_templates
Wed Jun 14 09:19:01 2017 [511165][1][FATAL] emails_email_templates_idb for emails_email_templates failed to load

Wed Jun 14 09:19:01 2017 [511165][1][ERROR] Unable to find relationship emails_email_templates
Wed Jun 14 09:19:01 2017 [511165][1][FATAL] emails_email_templates for emails_email_templates failed to load

Wed Jun 14 09:19:01 2017 [511165][1][FATAL] Failed to load relationship emails_email_templates while saving Emails
Wed Jun 14 09:19:01 2017 [511165][1][ERROR] Unable to find relationship emails_email_templates
Wed Jun 14 09:19:01 2017 [511165][1][FATAL] emails_email_templates_idb for emails_email_templates failed to load

Wed Jun 14 09:19:01 2017 [511165][1][ERROR] Unable to find relationship emails_email_templates
Wed Jun 14 09:19:01 2017 [511165][1][FATAL] emails_email_templates for emails_email_templates failed to load

Wed Jun 14 09:19:01 2017 [511165][1][FATAL] Failed to load relationship emails_email_templates while saving Emails
Wed Jun 14 09:19:01 2017 [511165][1][ERROR] Unable to find relationship emails_email_templates
Wed Jun 14 09:19:01 2017 [511165][1][FATAL] emails_email_templates_idb for emails_email_templates failed to load

Wed Jun 14 09:19:01 2017 [511165][1][ERROR] Unable to find relationship emails_email_templates
Wed Jun 14 09:19:01 2017 [511165][1][FATAL] emails_email_templates for emails_email_templates failed to load

Wed Jun 14 09:19:01 2017 [511165][1][FATAL] Failed to load relationship emails_email_templates while saving Emails
Wed Jun 14 09:19:01 2017 [511165][1][ERROR] IMAP error detected: SECURITY PROBLEM: insecure server advertised AUTH=PLAIN

A bunch of us are hoping that the kind folks at SuiteCRM will post a script or procedure that would downgrade an upgraded database to an 7.8.4 structure - so that we can get back to 7.84 (which is LTS) and which kicks serious ass.

It’s tough as it’s basically bricked for us.

And some more!

Wed Jun 14 09:19:01 2017 [511165][1][ERROR] Unable to find relationship emails_email_templates
Wed Jun 14 09:19:01 2017 [511165][1][FATAL] emails_email_templates for emails_email_templates failed to load

Wed Jun 14 09:19:01 2017 [511165][1][FATAL] Failed to load relationship emails_email_templates while saving Emails
Wed Jun 14 09:19:01 2017 [511165][1][ERROR] IMAP error detected: SECURITY PROBLEM: insecure server advertised AUTH=PLAIN
Wed Jun 14 09:30:02 2017 [515733][1][ERROR] Unable to find relationship emails_email_templates
Wed Jun 14 09:30:02 2017 [515733][1][FATAL] emails_email_templates for emails_email_templates failed to load

Wed Jun 14 09:30:02 2017 [515733][1][FATAL] Failed to load relationship emails_email_templates while saving Emails

This seems to give a little more information. I am not using SSL with the imap account. I am unsure if this is part of the issue?

Phil

@philemery

I did a backup of the folder in which suite is installed and also the DB. I find it relatively easy to restore it all back. As long as you remember to set the permissions again after copying back.

It’s the only way I can do this, because you are right, for me it’s pretty much bricked and I cannot wait as long as it takes to get ideas on fixing it. It’s community support so it’s fair enough, but we use this system live atm.

Phil

These bugs are fixed in 7.9.1, which should be coming out any day now (it was meant for past Monday, but is a bit delayed).

philemery, forget about a downgrade script, you’re never going to get one. There is only going back to backups (or VM snapshots) if an upgrade doesn’t work right for you… if you missed taking care of that, there’s simply no good alternative. I understand your frustration, I’ve made many sysadmin errors in my life, and some of them were a real pain.

Your solution is simply going to have to be 7.9.1., I’m afraid…

1 Like

Hey pgr

Well, no. That is good news and I can certainly wait for a few days.

Thanks very much for the info!

Phil

Thanks

I come from being a long time (since 1.5) Wordpress user and upgrades there are painless so never even considered backing up the DB first (I will with SuiteCRM now). Keep in mind that I’m not able to do business.

Not sure if they just don’t want to spend the time of a downgrade - which is fair (although I’ve been getting much more familiar with mySQL trying - so I guess there is that) or if it’s an admitting that 7.9 was not a great plan, but I think many folks are in this boat.

Sure wish I didn’t upgrade…

In general I’ve learned to accept there’s going to be issues that might not get resolved overnight and that would be unrealistic in most cases, especially more or less community developed software like this. So in general I’ve been happy with SuiteCRM given the low cost and appreciate they are adding new features and fixing bugs on an ongoing basis.

However, two recent decisions have given me pause.

  1. The whole Suite-P theme decision/design/strategy. I’m not quite sure what the significant actual benefits there are. For me at least SuiteR was doing just fine. I haven’t seen any specific benefits detailed anywhere. To me, being able to say it’s now based on Bootstrap, or “it looks more modern” or whatever, isn’t really a benefit. To me it’s a step backwards in screen layout from a usability / user efficiency standpoint.

  2. Why was 7.9.0 left up for download and not taken down when serious issues were discovered? If you use the email client in Suite, and you upgraded, you would quickly find out you couldn’t reply to or forward any messages. I would have immediately changed it’s status back to Beta once these things were discovered unless a new version was going to be released within 24 hours or so. Think of the poor souls that came along and downloaded it after these issues were discovered!? Yes, bugs are common in .0 versions but when the bugs have the potential of rendering key areas of the software unusable to the point a business can’t use it, then that’s another matter.

I think us as users need to take some responsibility though. I think one thing we all can do is try to create separate test instances of our Suite installs and databases and more frequently participate in the Beta releases so we can help these guys out with ironing out the major bugs BEFORE it goes into production release.

1 Like

Hey pgr.

So am I missing something? I upgraded to 7.9.1

Followed the instructions. And still no email!!!

EMAILS
You currently have no records saved. CREATE or Import one now.

Is what I am seeing!! This is the same error I had with 7.9.0. Nothing has changed!

NOW When I go to profile/settings. All it does is redirect me back to the users listing and I see the log full of the below

Unable to find relationship emails_email_templates

Any thoughts before I yet again roll this back?

Phil