Automatic import of e-mails after Upgrade not function

sga · 15 March 2019 09:05

Hello

SuiteCRM Version 7.11.2
Sugar Version 6.5.25 (Build 344)

After updating to Version 7.11.2, the automatic import of e-mails for group mailboxes suddenly no longer works.

When I open a mail from a group mailbox, I can import it manually and it works. But the automatic import doesn’t work anymore.
You can see the error:

[7112][1][WARN] An Imap error detected: "IMAP expunge error"

in the Errorlog.
The Log is attached

We have Exchange 2007 version 08.03.0485.001 in use. Yes, this is an ancient version, but it can’t be changed so fast.

Before the update it worked tip top. Therefore I don’t assume that the problem is suddenly related to the exchange server.

What can we do?

Many thanks for the help.

Greetings Samigasi

Translated with www.DeepL.com/Translator

pgr · 15 March 2019 17:52

You are using XAMPP…

I would focus on this, to start:

Warning [2]: Declaration of 
AOPInboundEmail::handleCreateCase(Email $email, $userId) should be compatible with 
InboundEmail::handleCreateCase($email, $userId) in 
C:\\xampp\\htdocs\\E00suitecrm\\modules\\InboundEmail\\AOPInboundEmail.php auf Zeile 27

Warning [2]: imap_append() expects at least 3 parameters, 1 given in 
C:\\xampp\\htdocs\\E00suitecrm\\include\\Imap\\ImapHandler.php auf Zeile 456

Which version of SuiteCRM are you upgrading from?

pgr · 15 March 2019 18:02

Can you try changing this line

https://github.com/salesagility/SuiteCRM/blob/master/modules/InboundEmail/InboundEmail.php#L3585

to add the “Email” word after the parenthesis, like so:

public function handleCreateCase(Email $email, $userId)

Tell me

If this makes the warning above stop from appearing in the logs
If it solves your problem

Thanks

sga · 18 March 2019 08:09

Hello

Thank you so much for your help.

Yes, we still have Xampp in action.
But this will be replaced in the long run.

I have inserted the code.
Since we don’t receive daily mails, I can give feedback only in a few days.

friendly greetings

sga · 18 March 2019 09:54

Hello

Now I can answer the questions:

the error mentioned above is partially gone. The error concerning ImapHandler is still present
no the automatic import does not work yet.

I have the code in the directory:
C:\xampp\htdocs\suitecrm\modules\InboundEmail\InboundEmail.php
changed. Is that correct?

We have two SuiteCRM directories:

htdocs\suitecrm
and htdocs\E00suitecrm

The directory E00suitecrm is a test environment.
Sorry, I forgot to mention that.

Could it have something to do with it?
https://github.com/salesagility/SuiteCRM/commit/7bfc829a54db9983011ed7e01974ac45da090ba8#diff-2aadc7f50e2480defbfecef7a0295a66

The current log is attached.

Greetings

sga · 18 March 2019 12:55

Hello

We’ve found the solution.

We found the recommendation of afnieves in bug #6888 7.10.12 Auto Import of Emails not working implemented and it worked.

The solution is attached as an image.

If solved.

Greetings

mallen1278 · 15 May 2019 07:22

It appears this fix is to address the Exchange issue. I havent tested completely. But if someone can send me the files from an 7.11.4 version it would be appreciated. I made the changes but not sure I did correctly.

But the main issue for me has always been that the email is sending from the admin address I entered during install, not the group address. I am filling out From and Reply To fields in the Group account. I leave the AOP email details blank because if I enter anything here it appears to break things.

Latest log

From address and name pair format is incorrect, use "from@emailaddress.org <Name of Person>" format.
From address and name pair is invalid.
codes:1, 4, 7, 10, 16, 15
Wed May 15 17:16:22 2019 [110877][1][ERROR] Unable to find relationship emails_email_templates
Wed May 15 17:16:22 2019 [110877][1][ERROR] Unable to find relationship emails_email_templates
Wed May 15 17:16:22 2019 [110877][1][ERROR] Unable to find relationship emails_email_templates
Wed May 15 17:16:22 2019 [110877][1][ERROR] Invalid email address given: [Michael Allen ] Called at /var/www/html/suitecrm_7_11/modules/InboundEmail/AOPInboundEmail.php:201 from function handleReplyType.
Wed May 15 17:16:22 2019 [110877][1][ERROR] Invalid email address given: [Michael Allen ] Called at /var/www/html/suitecrm_7_11/modules/InboundEmail/AOPInboundEmail.php:202 from function displayComposeEmail.
Wed May 15 17:16:22 2019 [110877][1][FATAL] SugarPHPMailer encountered an error: Invalid address:  (Reply-To):
Wed May 15 17:16:22 2019 [110877][1][FATAL] Attachements not found
Wed May 15 17:16:22 2019 [110877][1][ERROR] Invalid email from address or name detected before sending. Details:
From field is not set.
From-name is not set.
From address and name pair is not set.
codes:1, 7, 13
Invalid address:  (Reply-To):
Wed May 15 17:17:02 2019 [110897][1][ERROR] ImapHandler trying to use a non valid resource stream.
Wed May 15 17:17:02 2019 [110897][1][ERROR] ImapHandler trying to use a non valid resource stream.
Wed May 15 17:17:02 2019 [110897][1][FATAL] *** FOLDERS: addBean() is trying to save to a non-saved or non-existent folder
Wed May 15 17:17:02 2019 [110897][1][ERROR] Unable to find relationship emails_email_templates
Wed May 15 17:17:02 2019 [110897][1][ERROR] Unable to find relationship emails_email_templates
Wed May 15 17:17:02 2019 [110897][1][ERROR] Saving Email with invalid From name and/or Address. Details:
From field is not set.
From address is not set.
From-name is not set.
From name is not set.
From address and name pair format is incorrect, use "from@emailaddress.org <Name of Person>" format.
From address and name pair is invalid.
codes:1, 4, 7, 10, 16, 15
Wed May 15 17:17:02 2019 [110897][1][ERROR] Unable to find relationship emails_email_templates
Wed May 15 17:17:02 2019 [110897][1][ERROR] Contact address is incorrect to Email: 552aabe2-d787-315c-f5d0-5cdbac46e837
Wed May 15 17:17:02 2019 [110897][1][FATAL] *** FOLDERS: addBean() is trying to save to a non-saved or non-existent folder
Wed May 15 17:17:02 2019 [110897][1][ERROR] Unable to find relationship emails_email_templates
Wed May 15 17:17:02 2019 [110897][1][ERROR] Saving Email with invalid From name and/or Address. Details:
From field is not set.
From address is not set.
From-name is not set.
From name is not set.
From address and name pair format is incorrect, use "from@emailaddress.org <Name of Person>" format.
From address and name pair is invalid.
codes:1, 4, 7, 10, 16, 15
Wed May 15 17:17:02 2019 [110897][1][ERROR] Unable to find relationship emails_email_templates
Wed May 15 17:17:02 2019 [110897][1][ERROR] Contact address is incorrect to Email: 552aabe2-d787-315c-f5d0-5cdbac46e837
Wed May 15 17:17:02 2019 [110897][1][FATAL] *** FOLDERS: addBean() is trying to save to a non-saved or non-existent folder
Wed May 15 17:17:02 2019 [110897][1][ERROR] Unable to find relationship emails_email_templates
Wed May 15 17:17:02 2019 [110897][1][ERROR] Saving Email with invalid From name and/or Address. Details:
From field is not set.
From address is not set.
From-name is not set.
From name is not set.
From address and name pair format is incorrect, use "from@emailaddress.org <Name of Person>" format.
From address and name pair is invalid.
codes:1, 4, 7, 10, 16, 15
Wed May 15 17:17:02 2019 [110897][1][ERROR] Unable to find relationship emails_email_templates
Wed May 15 17:17:02 2019 [110897][1][ERROR] Contact address is incorrect to Email: 552aabe2-d787-315c-f5d0-5cdbac46e837
Wed May 15 17:17:02 2019 [110897][1][FATAL] *** FOLDERS: addBean() is trying to save to a non-saved or non-existent folder
Wed May 15 17:17:02 2019 [110897][1][ERROR] Unable to find relationship emails_email_templates
Wed May 15 17:17:02 2019 [110897][1][ERROR] Saving Email with invalid From name and/or Address. Details:
From field is not set.
From address is not set.
From-name is not set.
From name is not set.
From address and name pair format is incorrect, use "from@emailaddress.org <Name of Person>" format.
From address and name pair is invalid.
codes:1, 4, 7, 10, 16, 15
Wed May 15 17:17:02 2019 [110897][1][ERROR] Unable to find relationship emails_email_templates
Wed May 15 17:17:02 2019 [110897][1][ERROR] Contact address is incorrect to Email: 552aabe2-d787-315c-f5d0-5cdbac46e837
Wed May 15 17:17:15 2019 [110838][1][FATAL] [ERROR] Failed to remove bean to index
Wed May 15 17:17:15 2019 [110838][1][FATAL] [ERROR] SuiteCRM\Search\Exceptions\SearchException: Elasticsearch trying to re-indexing a bean but indexer is disabled in configuration. in /var/www/html/suitecrm_7_11/lib/Search/ElasticSearch/ElasticSearchHooks.php:123
Stack trace:
#0 /var/www/html/suitecrm_7_11/lib/Search/ElasticSearch/ElasticSearchHooks.php(105): SuiteCRM\Search\ElasticSearch\ElasticSearchHooks->reIndex(Object(InboundEmail))
#1 /var/www/html/suitecrm_7_11/lib/Search/ElasticSearch/ElasticSearchHooks.php(92): SuiteCRM\Search\ElasticSearch\ElasticSearchHooks->reIndexSafe(Object(InboundEmail))
#2 /var/www/html/suitecrm_7_11/include/utils/LogicHook.php(272): SuiteCRM\Search\ElasticSearch\ElasticSearchHooks->beanDeleted(Object(InboundEmail), 'after_delete', Array)
#3 /var/www/html/suitecrm_7_11/include/utils/LogicHook.php(213): LogicHook->process_hooks(Array, 'after_delete', Array)
#4 /var/www/html/suitecrm_7_11/data/SugarBean.php(3129): LogicHook->call_custom_logic('InboundEmail', 'after_delete', Array)
#5 /var/www/html/suitecrm_7_11/data/SugarBean.php(5267): SugarBean->call_custom_logic('after_delete', Array)
#6 /var/www/html/suitecrm_7_11/modules/InboundEmail/InboundEmail.php(292): SugarBean->mark_deleted('444002f5-aafd-8...')
#7 /var/www/html/suitecrm_7_11/modules/InboundEmail/Delete.php(54): InboundEmail->mark_deleted('444002f5-aafd-8...')
#8 /var/www/html/suitecrm_7_11/include/MVC/View/SugarView.php(834): include_once('/var/www/html/s...')
#9 /var/www/html/suitecrm_7_11/include/MVC/View/views/view.classic.php(72): SugarView->includeClassicFile('modules/Inbound...')
#10 /var/www/html/suitecrm_7_11/include/MVC/View/SugarView.php(226): ViewClassic->display()
#11 /var/www/html/suitecrm_7_11/include/MVC/Controller/SugarController.php(435): SugarView->process()
#12 /var/www/html/suitecrm_7_11/include/MVC/Controller/SugarController.php(375): SugarController->processView()
#13 /var/www/html/suitecrm_7_11/include/MVC/SugarApplication.php(113): SugarController->execute()
#14 /var/www/html/suitecrm_7_11/index.php(52): SugarApplication->execute()
#15 {main}
Wed May 15 17:19:01 2019 [110935][1][ERROR] ImapHandler trying to use a non valid resource stream.
Wed May 15 17:19:01 2019 [110935][1][ERROR] ImapHandler trying to use a non valid resource stream.
Wed May 15 17:20:01 2019 [110956][1][ERROR] ImapHandler trying to use a non valid resource stream.
Wed May 15 17:20:01 2019 [110956][1][ERROR] ImapHandler trying to use a non valid resource stream.
Wed May 15 17:21:02 2019 [110994][1][ERROR] ImapHandler trying to use a non valid resource stream.
Wed May 15 17:21:02 2019 [110994][1][ERROR] ImapHandler trying to use a non valid resource stream.

sga · 15 May 2019 08:46

Hi

What file do you need?

We don’t know much about SuiteCRM, so I can’t really help with the admin problem.

Greetings Sam

mallen1278 · 15 May 2019 10:51

Bug 6866 has a fix mentioned a few posts back.

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

The adjusted files mentioned in the solution. I adjusted mine to match the solution as best I could, but the line numbers were incorrect so I would expect the fix was tested on a different version of SuiteCRM. Hoping someone has applied the changes to 7.11.4 and confirmed it fixed their problem. If so, if someone could supply the updated files so I can confirm I got it right, and if not, upload the correct files.

sga · 15 May 2019 12:21

Hello

We have version 7.11.2.
We did exactly what was in the print screen of my mail where I wrote that the problem was solved.
The last point with the entry in config_overde.php we didn’t do because we still have an Exchange 2010.
it’s working fine right now.

I’ll attach the two files to you.

Greetings Sam