After uprade o 7.11.0 all workflow related with sending email stopped working.
All actions which are logic hooks which should send an email give user error 500.
Workflow are seen as in progress but nothing happens even after 48h.
No information in logs even on error level.
For example
Send email if name of field changes.
I tested it on demo installation and problem occurs also in there.
This is critical element of our company installation.
Hi, Did you get a resolution to this one?
I am also facing the same issue, any workflow which has an email in returns a 500 error.
I have also noticed the group email account has disappeared and when you try to add a new group email account you receive error messages either refusing the connection or the username and password incorrect even if they are copied from notepad.
I wasted to much time trying figure out whats wrong and went back to old version.
7.10.12 is only way i can help you :(
thinking of doing the same, is there many differences in the tables or was it easy enough to revert back.
I also got copy of database so i have no idea. Guess we need to wait.
Can you please check your web server logs? You turn them on in your php.ini and specify the file name (usually php_errors.log). Then restart your web server.
Then you should be able to see what is breaking PHP in that log. This would be of great help in order to fix the problem. Thanks
Hi,
Here is the error log.
[29-Jan-2019 10:50:30 Europe/London] PHP Notice: Undefined index: labelsAndValues in /var/www/html/suitecrm/modules/Charts/Dashlets/OutcomeByMonthDashlet/OutcomeByMonthDashlet.php on line 126
[29-Jan-2019 10:50:30 Europe/London] PHP Notice: Undefined property: OutcomeByMonthDashlet::$seedBean in /var/www/html/suitecrm/include/Dashlets/Dashlet.php on line 252
[29-Jan-2019 10:50:31 Europe/London] PHP Notice: Undefined index: labelsAndValues in /var/www/html/suitecrm/modules/Charts/Dashlets/OutcomeByMonthDashlet/OutcomeByMonthDashlet.php on line 126
[29-Jan-2019 10:50:31 Europe/London] PHP Notice: Undefined property: OutcomeByMonthDashlet::$seedBean in /var/www/html/suitecrm/include/Dashlets/Dashlet.php on line 252
[29-Jan-2019 10:50:54 Europe/London] PHP Notice: Undefined property: AORReportsDashlet::$seedBean in /var/www/html/suitecrm/include/Dashlets/Dashlet.php on line 252
[29-Jan-2019 10:50:54 Europe/London] PHP Notice: Undefined property: AORReportsDashlet::$seedBean in /var/www/html/suitecrm/include/Dashlets/Dashlet.php on line 252
[29-Jan-2019 10:50:54 Europe/London] PHP Notice: Undefined property: AORReportsDashlet::$seedBean in /var/www/html/suitecrm/include/Dashlets/Dashlet.php on line 252
[29-Jan-2019 10:50:54 Europe/London] PHP Notice: Undefined property: AORReportsDashlet::$seedBean in /var/www/html/suitecrm/include/Dashlets/Dashlet.php on line 252
[29-Jan-2019 10:50:54 Europe/London] PHP Notice: Undefined property: AORReportsDashlet::$seedBean in /var/www/html/suitecrm/include/Dashlets/Dashlet.php on line 252
[29-Jan-2019 10:50:54 Europe/London] PHP Notice: Undefined property: AORReportsDashlet::$seedBean in /var/www/html/suitecrm/include/Dashlets/Dashlet.php on line 252
[29-Jan-2019 10:50:54 Europe/London] PHP Notice: Undefined property: AORReportsDashlet::$seedBean in /var/www/html/suitecrm/include/Dashlets/Dashlet.php on line 252
[29-Jan-2019 10:50:55 Europe/London] PHP Notice: Undefined property: AORReportsDashlet::$seedBean in /var/www/html/suitecrm/include/Dashlets/Dashlet.php on line 252
[29-Jan-2019 10:50:55 Europe/London] PHP Notice: Undefined property: AORReportsDashlet::$seedBean in /var/www/html/suitecrm/include/Dashlets/Dashlet.php on line 252
[29-Jan-2019 10:50:55 Europe/London] PHP Notice: Undefined property: AORReportsDashlet::$seedBean in /var/www/html/suitecrm/include/Dashlets/Dashlet.php on line 252
[29-Jan-2019 10:50:55 Europe/London] PHP Notice: Undefined property: AORReportsDashlet::$seedBean in /var/www/html/suitecrm/include/Dashlets/Dashlet.php on line 252
[29-Jan-2019 10:50:55 Europe/London] PHP Notice: Undefined property: AORReportsDashlet::$seedBean in /var/www/html/suitecrm/include/Dashlets/Dashlet.php on line 252
[29-Jan-2019 10:50:55 Europe/London] PHP Notice: Undefined property: AORReportsDashlet::$seedBean in /var/www/html/suitecrm/include/Dashlets/Dashlet.php on line 252
[29-Jan-2019 10:50:55 Europe/London] PHP Notice: Undefined property: AORReportsDashlet::$seedBean in /var/www/html/suitecrm/include/Dashlets/Dashlet.php on line 252
[29-Jan-2019 10:51:02 Europe/London] PHP Notice: Undefined property: AORReportsDashlet::$seedBean in /var/www/html/suitecrm/include/Dashlets/Dashlet.php on line 252
[29-Jan-2019 10:51:02 Europe/London] PHP Notice: Undefined property: AORReportsDashlet::$seedBean in /var/www/html/suitecrm/include/Dashlets/Dashlet.php on line 252
[29-Jan-2019 10:51:02 Europe/London] PHP Notice: Undefined property: AORReportsDashlet::$seedBean in /var/www/html/suitecrm/include/Dashlets/Dashlet.php on line 252
[29-Jan-2019 10:51:02 Europe/London] PHP Notice: Undefined property: AORReportsDashlet::$seedBean in /var/www/html/suitecrm/include/Dashlets/Dashlet.php on line 252
[29-Jan-2019 10:51:02 Europe/London] PHP Notice: Undefined property: AORReportsDashlet::$seedBean in /var/www/html/suitecrm/include/Dashlets/Dashlet.php on line 252
[29-Jan-2019 10:51:02 Europe/London] PHP Notice: Undefined property: AORReportsDashlet::$seedBean in /var/www/html/suitecrm/include/Dashlets/Dashlet.php on line 252
[29-Jan-2019 10:51:02 Europe/London] PHP Notice: Undefined property: AORReportsDashlet::$seedBean in /var/www/html/suitecrm/include/Dashlets/Dashlet.php on line 252
[29-Jan-2019 10:51:03 Europe/London] PHP Notice: Undefined property: AORReportsDashlet::$seedBean in /var/www/html/suitecrm/include/Dashlets/Dashlet.php on line 252
[29-Jan-2019 10:51:03 Europe/London] PHP Notice: Undefined property: AORReportsDashlet::$seedBean in /var/www/html/suitecrm/include/Dashlets/Dashlet.php on line 252
[29-Jan-2019 10:51:03 Europe/London] PHP Notice: Undefined property: AORReportsDashlet::$seedBean in /var/www/html/suitecrm/include/Dashlets/Dashlet.php on line 252
[29-Jan-2019 10:51:03 Europe/London] PHP Notice: Undefined property: AORReportsDashlet::$seedBean in /var/www/html/suitecrm/include/Dashlets/Dashlet.php on line 252
[29-Jan-2019 10:51:03 Europe/London] PHP Notice: Undefined property: AORReportsDashlet::$seedBean in /var/www/html/suitecrm/include/Dashlets/Dashlet.php on line 252
[29-Jan-2019 10:51:03 Europe/London] PHP Notice: Undefined property: AORReportsDashlet::$seedBean in /var/www/html/suitecrm/include/Dashlets/Dashlet.php on line 252
[29-Jan-2019 10:51:03 Europe/London] PHP Notice: Undefined property: AORReportsDashlet::$seedBean in /var/www/html/suitecrm/include/Dashlets/Dashlet.php on line 252
[29-Jan-2019 10:51:08 Europe/London] PHP Notice: Undefined property: AORReportsDashlet::$seedBean in /var/www/html/suitecrm/include/Dashlets/Dashlet.php on line 252
[29-Jan-2019 10:51:08 Europe/London] PHP Notice: Undefined index: aor in /var/www/html/suitecrm/modules/AOR_Reports/aor_utils.php on line 231
[29-Jan-2019 10:51:08 Europe/London] PHP Notice: Undefined index: aor in /var/www/html/suitecrm/modules/AOR_Reports/aor_utils.php on line 231
[29-Jan-2019 10:51:08 Europe/London] PHP Notice: Undefined index: aor in /var/www/html/suitecrm/modules/AOR_Reports/aor_utils.php on line 231
[29-Jan-2019 10:51:08 Europe/London] PHP Notice: Undefined index: aor in /var/www/html/suitecrm/modules/AOR_Reports/aor_utils.php on line 231
[29-Jan-2019 10:52:07 Europe/London] PHP Notice: Only variables should be passed by reference in /var/www/html/suitecrm/modules/AOW_Actions/actions/actionCreateRecord.php on line 166
[29-Jan-2019 10:52:32 Europe/London] PHP Notice: Undefined property: AORReportsDashlet::$seedBean in /var/www/html/suitecrm/include/Dashlets/Dashlet.php on line 252
[29-Jan-2019 10:52:32 Europe/London] PHP Notice: Undefined property: AORReportsDashlet::$seedBean in /var/www/html/suitecrm/include/Dashlets/Dashlet.php on line 252
[29-Jan-2019 10:52:32 Europe/London] PHP Notice: Undefined property: AORReportsDashlet::$seedBean in /var/www/html/suitecrm/include/Dashlets/Dashlet.php on line 252
[29-Jan-2019 10:52:32 Europe/London] PHP Notice: Undefined property: AORReportsDashlet::$seedBean in /var/www/html/suitecrm/include/Dashlets/Dashlet.php on line 252
[29-Jan-2019 10:52:32 Europe/London] PHP Notice: Undefined property: AORReportsDashlet::$seedBean in /var/www/html/suitecrm/include/Dashlets/Dashlet.php on line 252
[29-Jan-2019 10:52:32 Europe/London] PHP Notice: Undefined property: AORReportsDashlet::$seedBean in /var/www/html/suitecrm/include/Dashlets/Dashlet.php on line 252
[29-Jan-2019 10:52:32 Europe/London] PHP Notice: Undefined property: AORReportsDashlet::$seedBean in /var/www/html/suitecrm/include/Dashlets/Dashlet.php on line 252
[29-Jan-2019 10:53:00 Europe/London] PHP Notice: Undefined property: AORReportsDashlet::$seedBean in /var/www/html/suitecrm/include/Dashlets/Dashlet.php on line 252
[29-Jan-2019 10:53:00 Europe/London] PHP Notice: Undefined property: AORReportsDashlet::$seedBean in /var/www/html/suitecrm/include/Dashlets/Dashlet.php on line 252
[29-Jan-2019 10:53:00 Europe/London] PHP Notice: Undefined property: AORReportsDashlet::$seedBean in /var/www/html/suitecrm/include/Dashlets/Dashlet.php on line 252
[29-Jan-2019 10:53:00 Europe/London] PHP Notice: Undefined property: AORReportsDashlet::$seedBean in /var/www/html/suitecrm/include/Dashlets/Dashlet.php on line 252
[29-Jan-2019 10:53:00 Europe/London] PHP Notice: Undefined property: AORReportsDashlet::$seedBean in /var/www/html/suitecrm/include/Dashlets/Dashlet.php on line 252
[29-Jan-2019 10:53:00 Europe/London] PHP Notice: Undefined property: AORReportsDashlet::$seedBean in /var/www/html/suitecrm/include/Dashlets/Dashlet.php on line 252
[29-Jan-2019 10:53:00 Europe/London] PHP Notice: Undefined property: AORReportsDashlet::$seedBean in /var/www/html/suitecrm/include/Dashlets/Dashlet.php on line 252
[29-Jan-2019 10:53:00 Europe/London] PHP Notice: Undefined property: AORReportsDashlet::$seedBean in /var/www/html/suitecrm/include/Dashlets/Dashlet.php on line 252
[29-Jan-2019 10:53:00 Europe/London] PHP Notice: Undefined property: AORReportsDashlet::$seedBean in /var/www/html/suitecrm/include/Dashlets/Dashlet.php on line 252
[29-Jan-2019 10:53:00 Europe/London] PHP Notice: Undefined property: AORReportsDashlet::$seedBean in /var/www/html/suitecrm/include/Dashlets/Dashlet.php on line 252
[29-Jan-2019 10:53:00 Europe/London] PHP Notice: Undefined property: AORReportsDashlet::$seedBean in /var/www/html/suitecrm/include/Dashlets/Dashlet.php on line 252
[29-Jan-2019 10:53:00 Europe/London] PHP Notice: Undefined property: AORReportsDashlet::$seedBean in /var/www/html/suitecrm/include/Dashlets/Dashlet.php on line 252
[29-Jan-2019 10:53:00 Europe/London] PHP Notice: Undefined property: AORReportsDashlet::$seedBean in /var/www/html/suitecrm/include/Dashlets/Dashlet.php on line 252
[29-Jan-2019 10:53:00 Europe/London] PHP Notice: Undefined property: AORReportsDashlet::$seedBean in /var/www/html/suitecrm/include/Dashlets/Dashlet.php on line 252
[29-Jan-2019 10:53:08 Europe/London] PHP Notice: Undefined property: AORReportsDashlet::$seedBean in /var/www/html/suitecrm/include/Dashlets/Dashlet.php on line 252
[29-Jan-2019 10:53:08 Europe/London] PHP Notice: Undefined property: AORReportsDashlet::$seedBean in /var/www/html/suitecrm/include/Dashlets/Dashlet.php on line 252
[29-Jan-2019 10:53:08 Europe/London] PHP Notice: Undefined property: AORReportsDashlet::$seedBean in /var/www/html/suitecrm/include/Dashlets/Dashlet.php on line 252
[29-Jan-2019 10:53:08 Europe/London] PHP Notice: Undefined property: AORReportsDashlet::$seedBean in /var/www/html/suitecrm/include/Dashlets/Dashlet.php on line 252
[29-Jan-2019 10:53:08 Europe/London] PHP Notice: Undefined property: AORReportsDashlet::$seedBean in /var/www/html/suitecrm/include/Dashlets/Dashlet.php on line 252
[29-Jan-2019 10:53:08 Europe/London] PHP Notice: Undefined property: AORReportsDashlet::$seedBean in /var/www/html/suitecrm/include/Dashlets/Dashlet.php on line 252
[29-Jan-2019 10:53:08 Europe/London] PHP Notice: Undefined property: AORReportsDashlet::$seedBean in /var/www/html/suitecrm/include/Dashlets/Dashlet.php on line 252
[29-Jan-2019 10:53:09 Europe/London] PHP Notice: Undefined property: AORReportsDashlet::$seedBean in /var/www/html/suitecrm/include/Dashlets/Dashlet.php on line 252
[29-Jan-2019 10:53:09 Europe/London] PHP Notice: Undefined property: AORReportsDashlet::$seedBean in /var/www/html/suitecrm/include/Dashlets/Dashlet.php on line 252
[29-Jan-2019 10:53:09 Europe/London] PHP Notice: Undefined property: AORReportsDashlet::$seedBean in /var/www/html/suitecrm/include/Dashlets/Dashlet.php on line 252
[29-Jan-2019 10:53:09 Europe/London] PHP Notice: Undefined property: AORReportsDashlet::$seedBean in /var/www/html/suitecrm/include/Dashlets/Dashlet.php on line 252
[29-Jan-2019 10:53:09 Europe/London] PHP Notice: Undefined property: AORReportsDashlet::$seedBean in /var/www/html/suitecrm/include/Dashlets/Dashlet.php on line 252
[29-Jan-2019 10:53:09 Europe/London] PHP Notice: Undefined property: AORReportsDashlet::$seedBean in /var/www/html/suitecrm/include/Dashlets/Dashlet.php on line 252
[29-Jan-2019 10:53:09 Europe/London] PHP Notice: Undefined property: AORReportsDashlet::$seedBean in /var/www/html/suitecrm/include/Dashlets/Dashlet.php on line 252
[29-Jan-2019 10:53:11 Europe/London] PHP Notice: Only variables should be passed by reference in /var/www/html/suitecrm/modules/AOW_Actions/actions/actionCreateRecord.php on line 166
[29-Jan-2019 10:54:09 Europe/London] PHP Notice: Only variables should be passed by reference in /var/www/html/suitecrm/modules/AOW_Actions/actions/actionCreateRecord.php on line 166
[29-Jan-2019 10:54:24 Europe/London] PHP Notice: Undefined property: AORReportsDashlet::$seedBean in /var/www/html/suitecrm/include/Dashlets/Dashlet.php on line 252
[29-Jan-2019 10:54:24 Europe/London] PHP Notice: Undefined property: AORReportsDashlet::$seedBean in /var/www/html/suitecrm/include/Dashlets/Dashlet.php on line 252
[29-Jan-2019 10:54:24 Europe/London] PHP Notice: Undefined property: AORReportsDashlet::$seedBean in /var/www/html/suitecrm/include/Dashlets/Dashlet.php on line 252
[29-Jan-2019 10:54:24 Europe/London] PHP Notice: Undefined property: AORReportsDashlet::$seedBean in /var/www/html/suitecrm/include/Dashlets/Dashlet.php on line 252
[29-Jan-2019 10:54:24 Europe/London] PHP Notice: Undefined property: AORReportsDashlet::$seedBean in /var/www/html/suitecrm/include/Dashlets/Dashlet.php on line 252
[29-Jan-2019 10:54:24 Europe/London] PHP Notice: Undefined property: AORReportsDashlet::$seedBean in /var/www/html/suitecrm/include/Dashlets/Dashlet.php on line 252
[29-Jan-2019 10:54:24 Europe/London] PHP Notice: Undefined property: AORReportsDashlet::$seedBean in /var/www/html/suitecrm/include/Dashlets/Dashlet.php on line 252
[29-Jan-2019 10:54:25 Europe/London] PHP Notice: Undefined property: AORReportsDashlet::$seedBean in /var/www/html/suitecrm/include/Dashlets/Dashlet.php on line 252
[29-Jan-2019 10:54:25 Europe/London] PHP Notice: Undefined property: AORReportsDashlet::$seedBean in /var/www/html/suitecrm/include/Dashlets/Dashlet.php on line 252
[29-Jan-2019 10:54:25 Europe/London] PHP Notice: Undefined property: AORReportsDashlet::$seedBean in /var/www/html/suitecrm/include/Dashlets/Dashlet.php on line 252
[29-Jan-2019 10:54:25 Europe/London] PHP Notice: Undefined property: AORReportsDashlet::$seedBean in /var/www/html/suitecrm/include/Dashlets/Dashlet.php on line 252
[29-Jan-2019 10:54:25 Europe/London] PHP Notice: Undefined property: AORReportsDashlet::$seedBean in /var/www/html/suitecrm/include/Dashlets/Dashlet.php on line 252
[29-Jan-2019 10:54:25 Europe/London] PHP Notice: Undefined property: AORReportsDashlet::$seedBean in /var/www/html/suitecrm/include/Dashlets/Dashlet.php on line 252
[29-Jan-2019 10:54:25 Europe/London] PHP Notice: Undefined property: AORReportsDashlet::$seedBean in /var/www/html/suitecrm/include/Dashlets/Dashlet.php on line 252
The above seedBean error is logged when navigating to the email module or to the workflow containing sending an email.
Line 252 in the PHP is as follows:
252 if(!is_object($this->seedBean)) {
In my case no error in php but after qucik rebuild i got information in CRM log
Tue Jan 29 14:39:01 2019 [29167][1][ERROR] ImapHandler trying to use a non valid resource stream.
Tue Jan 29 14:39:01 2019 [29167][1][ERROR] ImapHandler trying to use a non valid resource stream.
Tue Jan 29 14:39:01 2019 [29167][1][FATAL] Job 558911fe-f971-1189-de3d-5c5057d4237d (Zadania procesów przep艂ywu pracy) failed in CRON run
I have just checked my error log and getting similar error messages:
Mon Jan 28 13:19:03 2019 [26691][1][FATAL] Scheduler cannot write PID file. Please check permissions on cache/modules/Schedulers/lastrun
Mon Jan 28 13:19:06 2019 [26691][1][FATAL] Job 36002cd3-6318-4aa5-90ca-5c4f0137c942 (Process Workflow Tasks) failed in CRON run
Mon Jan 28 13:20:07 2019 [26696][1][FATAL] SCHEDULERS: could not get an IMAP connection resource for ID [ b8d8f2f1-d1fc-b65b-ef50-5b0fb7093670 ]. Skipping mailbox [ ].
Mon Jan 28 13:20:08 2019 [26696][1][FATAL] Job 15a80bc6-0b30-cfde-8aa9-5c4f0156f731 (Process Workflow Tasks) failed in CRON run
Mon Jan 28 13:21:05 2019 [26712][1][FATAL] Job ae1f6f4c-c189-f140-8b29-5c4f01f128c1 (Process Workflow Tasks) failed in CRON run
Mon Jan 28 13:22:01 2019 [27099][1][FATAL] Scheduler cannot write PID file. Please check permissions on cache/modules/Schedulers/lastrun
Mon Jan 28 13:22:02 2019 [27099][1][FATAL] SCHEDULERS: could not get an IMAP connection resource for ID [ b8d8f2f1-d1fc-b65b-ef50-5b0fb7093670 ]. Skipping mailbox [ ].
Mon Jan 28 13:22:04 2019 [27099][1][FATAL] Job 6eb159a2-d1c6-168f-8845-5c4f0133b90b (Process Workflow Tasks) failed in CRON run
Can you try this change to see if it works?
https://github.com/salesagility/SuiteCRM/commit/496419494462df000ede64b0b2112ff2cffee170
It's just a quick attempt at a fix, I didn't really look at this properly, so don't be surprised if it doesn't work...
Done that, looks the same.
Its really strange anything to with IMAP is having an issue e.g group mail boxes work flows etc, SMTP is fine and manual emails are working. The logs contain the same as above.
Thanks
I know what's wrong. A fix is coming soon.
I think the above commit fixes the issue.
If you have a the time to see if it works for you that would be great @AdminPL @liamvaughan
Hi @PedroErnst
Just tried this and it has resolved the issue.
Thank you.
Added PHP lint so we can hopefully avoid this in the future.
We upgraded from 7.10.11 to 7.11.1 to avoid email issues and have now inhereted exactly the same issue, clearly. All system emails are not working as described above.
Additionally however each time we do an upgrade we get a new System Email created and it is not clear in the Manual which is the live system account. The manual refers to the system email, never by an actual name, but various images show it as "system" but also more recently as "SuiteCRM" in places. Some clarity would be good.
Similarly some clarity on how to fix the above system/workflow error. ie which fixes do we need to apply. Or how soon will it be before 7.11.2 be released, as 7.11.1 is totally broken. Thanks in advance. (Dillon-Brown you are like a #TimeLord you deserve a Doctorate already :))
@parkerauk We aim to have a release at least once a month so the next 7.11.x ETA scheduled w/c 18
Upgraded to 7.11.2 and the issue remains. Any updates on this????
Hi @mtierno when I changed the PHP script above the workflows started working again.
Thanks
I have this issue to in 7.11.7 - still not fixed. Suite CRM log:
Sun Aug 25 19:27:50 2019 [10124][1][ERROR] ImapHandler trying to set a non valid resource az stream.
Sun Aug 25 19:27:50 2019 [10124][1][ERROR] ImapHandler trying to use a non valid resource stream.
I'm not sure how to read the issue here and what the fix is for now as I can't create cases from Emails as a result of it and i'm well and truly stuck :-) I've checked the file and I can see it's up to date with the changed file.
Many thanks.
Additional Note: Have upgraded to 7.11.8 but still not working - I haven't see the warnings for a while though (over the last couple of hours). Still clearly incredibly problematic.
I have a fresh install of 7.11.8. Personal email works correctly.
When I do a campaign the test list works correctly and when I use a small list of 10 targets using the cron, the emails are received.
When I send a list of 1500, 60 at a time I get:
Sun Sep 8 17:49:02 2019 [30489][1][ERROR] ImapHandler trying to use a non valid resource stream.
The emails bounce into the bounce-other folder.
Koozali SME Linux, PHP Remi 7.2 SuiteCRM 7.11.8
Thanks
@gyrcom maybe you're hitting a limit that your email provider has, and it starts to deny connections? For example, in Gmail, this applies.
Well, I backed up my database, wiped the server and installed 7.10.20. Everything now works as advertised. This is another lesson in staying with LTS versions. Thanks all