Imported emails are blank

[minbar]

Hello,

I have tried looking around for a solution to this but can’t find one, so I’m hoping someone on here can help.

I have Espo monitoring a folder in my G Suite mailbox called CRM and then I just move email in to that folder when I want them imported into Espo, but with some emails (and I can’t seem to see any pattern) once it’s imported the message body will be blank. Most emails work just fine but some don’t and I just can’t work out why it is, so I’m hoping someone on here can shed some light on this and maybe suggest a fix or at least confirm if this is a bug in Espo or not. I’m running Espo on an up to date Ubuntu 16.04 server running on the Google Cloud, but I can’t really suggest any method to reproduce the issue because other than importing certain customer emails.

The other issue I have as result of this this that once Espo has tried to import it once and I remove it Espo will not try and import it again, so is there any way to make Espo try it again?

Any help with this would be appreciated.

Many thanks..

[tanya]

Hello
Did you installed MailParse?

[minbar]

Hi tanya, thanks for your reply. The only modules I have installed are the default ones, how can I tell if MailParse is installed?

[tanya]

"php -m" command in CLI will show if it's installed and loaded.

https://www.espocrm.com/documentatio...mail-fetching/

[minbar]

Ok I’m that case MailParse isn’t installed. I have been Looking for instructions on how to install it but I’m getting stuck find details about installing for php7.0. Do you have any instructions for it?

many thanks.

[tanya]

https://serverpilot.io/community/articles/how-to-install-the-php-mailparse-extension.html

https://pecl.php.net/package/mailparse

[minbar]

Thanks tanya. I have tired following the instructions on the server pilot like you gave me but I am getting an error on the second line
sudo pecl7.0-sp install --nodeps mailparse Saying pecl7.0-sp: Command not found. I have been searching for a solution to this but its not driving me nuts, any ideas why this is?

[tanya]

https://askubuntu.com/questions/943455/install-pecl-extension-in-ubuntu-16-04-with-php-7-0-18

https://askubuntu.com/questions/403327/install-pecl-packages-on-ubuntu

[minbar]

Thanks tanya.. After several more hours playing around with it I think I have got mailparse installed. It now showing using the phpinfo() function but it doesn't show using php -m so does that mean its not loaded properly?

[minbar]

Hi tanya.. I am still having the same problem even though mailparse is installed.. Any ideas what else could be causing this please?

[tanya]

Hello
Check again apache error log and espocrm log, please

[minbar]

Hi Tanya,
The apache log for today shows:-
PHP Warning: Module 'mailparse' already loaded in Unknown on line 0
[Mon Oct 09 06:25:04.074083 2017] [ssl:warn] [pid 1831] AH01906: zarquon.digitalelk.uk:443:0 server certificate is a CA certificate (BasicConstraints: CA == TRUE !?)
[Mon Oct 09 06:25:04.074178 2017] [mpm_prefork:notice] [pid 1831] AH00163: Apache/2.4.18 (Ubuntu) OpenSSL/1.0.2g configured -- resuming normal operations
[Mon Oct 09 06:25:04.074183 2017] [core:notice] [pid 1831] AH00094: Command line: '/usr/sbin/apache2'
[Mon Oct 09 16:25:12.877787 2017] [mpm_prefork:notice] [pid 1831] AH00171: Graceful restart requested, doing restart
[Mon Oct 09 16:25:12.985372 2017] [ssl:warn] [pid 1831] AH01906: zarquon.digitalelk.uk:443:0 server certificate is a CA certificate (BasicConstraints: CA == TRUE !?)
[Mon Oct 09 16:25:12.985483 2017] [mpm_prefork:notice] [pid 1831] AH00163: Apache/2.4.18 (Ubuntu) OpenSSL/1.0.2g configured -- resuming normal operations
[Mon Oct 09 16:25:12.985489 2017] [core:notice] [pid 1831] AH00094: Command line: '/usr/sbin/apache2'
[Mon Oct 09 16:25:24.301112 2017] [mpm_prefork:notice] [pid 1831] AH00171: Graceful restart requested, doing restart
[Mon Oct 09 16:25:24.371779 2017] [ssl:warn] [pid 1831] AH01906: zarquon.digitalelk.uk:443:0 server certificate is a CA certificate (BasicConstraints: CA == TRUE !?)
[Mon Oct 09 16:25:24.371892 2017] [mpm_prefork:notice] [pid 1831] AH00163: Apache/2.4.18 (Ubuntu) OpenSSL/1.0.2g configured -- resuming normal operations
[Mon Oct 09 16:25:24.371898 2017] [core:notice] [pid 1831] AH00094: Command line: '/usr/sbin/apache2'
[Mon Oct 09 16:25:29.778632 2017] [mpm_prefork:notice] [pid 1831] AH00169: caught SIGTERM, shutting down
[Mon Oct 09 16:25:34.191374 2017] [ssl:warn] [pid 19592] AH01906: zarquon.digitalelk.uk:443:0 server certificate is a CA certificate (BasicConstraints: CA == TRUE !?)
[Mon Oct 09 16:25:34.225674 2017] [ssl:warn] [pid 19594] AH01906: zarquon.digitalelk.uk:443:0 server certificate is a CA certificate (BasicConstraints: CA == TRUE !?)
[Mon Oct 09 16:25:34.229396 2017] [mpm_prefork:notice] [pid 19594] AH00163: Apache/2.4.18 (Ubuntu) OpenSSL/1.0.2g configured -- resuming normal operations
[Mon Oct 09 16:25:34.229420 2017] [core:notice] [pid 19594] AH00094: Command line: '/usr/sbin/apache2'

As you can see I restarted apache a few times, the espocrm log for today shows:-
[2017-10-09 15:20:02] Espo.WARNING: E_WARNING: Declaration of Espo\Modules\Advanced\Core\Google\Clients\Contacts :roductPing() should be compatible with Espo\Modules\Advanced\Core\Google\Clients\Google:roductPing($url = NULL) {"code":2,"message":"Declaration of Espo\\Modules\\Advanced\\Core\\Google\\Clients\\Co ntacts:roductPing() should be compatible with Espo\\Modules\\Advanced\\Core\\Google\\Clients\\Go ogle:roductPing($url = NULL)","file":"/var/www/html/crm/application/Espo/Modules/Advanced/Core/Google/Clients/Contacts.php","line":204,"context":{"file":"/var/www/html/crm/vendor/composer/../../application/Espo/Modules/Advanced/Core/Google/Clients/Contacts.php"}} []

This is repeated in the espocrm log every 10 minues and apart from this there is nothing else in the espocrm log for today and I have been having the same issue today with emails being imported blank.

Many thanks

[tanya]

The first row - http://www.somacon.com/p520.php
The last one - It's only warning and it is not related with blank emails...(will be fixed)

[minbar]

Hi Tanya,

I have solved the mailparse already loaded issue, I just had it referenced in two config files so that error doesn't show up any more. But I'm still having the blank email issue, what else could it be?

[tanya]

Are the new imported emails empty or old?