Outlook Plugin not saving JPG attachments

I'm using the official Outlook Plugin with Vtiger 7.3 and just noticed it's not saving jpg (or png) attachments in the Storage folder. This used to work and still works with pdf and other file types. It's not a max_file_upload issue (I've set this to 50M).

Our live 7.3 instance has been updated many times over the years but this issue is also present on a fresh install of V7.3.

Anyone got any ideas on how to fix this please?

This looks like a bug. Am I the only one using the Outlook Plugin?

@david.pettigrew I wonder if it could be anything to do with this one? #1511 (closed). If you check the code which handles the comms between Outlook and vtiger maybe there is some similarity? Also check the merge requests mentioned in that ticket too. 7.3 introduced obfuscated filenames under the /storage directory and there were quite a few issues with the initial implementation.

Also - check your .htaccess file. Make sure all the appropriate file extensions are included - especially case. The standard .htaccess is not case insensitive.

Also - I just came across some changes that were made recently which may have something to do with it... See

https://code.vtiger.com/vtiger/vtigercrm/blob/master/vtlib/Vtiger/Functions.php#L647

The strtolower statement was added between 10 and 8 months ago. Without it any files with upper case letters in the extension would fail to be accepted.

Hi Alan. First of all, thanks for your suggestions and taking time to reply. I have the following in my .htaccess file in the storage folder:

deny from all <FilesMatch "(?i).(gif|tiff|jpe?g|png)$"> Order Allow,deny Allow from all

but still get the same issue. I've followed the links you mention and the code is OK for the strtolower function. I don't have enough knowledge of Vtiger (or PHP) to know where to look for the code that links from the Outlook plugin to Vtiger but fear it may be compiled code in the plugin itself.

I've also done some further testing on a clean install and find that an email with pdf, jpg and JPG attachments that fails to link correctly with the Outlook plugin (only the pdf file is linked) does link correctly if done with the mail manager in Vtiger. In this case, all three attached files are in the storage folder and have entries in the vtiger_attachments table.

However, if I try to link an email with a TIFF attachment, the attachment is not linked with either email client but in the case of mail manager, there is a zero byte file of the correct name in the storage folder and it's also listed in the attachments table.

Sorry to go on at length about this but, with 30 years experience of selling various CRM systems, I am acutely aware of how important it is to have a comprehensive email history available in the CRM system - even more so these days - and this is one area where Vtiger seems weak.

P.S. I noticed your post (#1571) about the calendar preview window and like the idea very much. It would also be great if something similar could be applied to the email list view as well so that hovering over a listed email pops up a window with a preview of the email body.

Sorry the .htaccess contents should read:

deny from all
<FilesMatch "(?i)\.(gif|tiff|jpe?g|png)$">
Order Allow,deny
Allow from all
</FilesMatch>

I'm at a bit of a loss unfortunately. I had a look back at some old threads on the mailling list (in which you contributed) when there was an issue after the 7.2 release...

http://lists.vtigercrm.com/pipermail/vtigercrm-developers/2019-November/038342.html

The important thing here is the path of the calls from Outlook. They arrive in webservice.php which is in the root directory of the vtiger installation. I would start there with adding debug logging, enabling php error_reporting (and logging) and tracing the path until you find the culprit.

It would be interesting to see what happens with the db queries in the vtiger log when a image attachment is trying to be saved vs a pdf... That's the bit that confuses me - I can't really see why a pdf would be treated differently to a jpg for example.

Thanks again Alan for your suggestions. I've tried enabling debug and looking at the logs but it's a bit beyond me. However I've also just discovered that Vtiger won't save documents of certain types either. I can save PDF documents but not other types such as JPGs or PNGs.

There are correct entries in the documents list view but, apart from PDFs, the file name is not hyperlinked and the other file types are not present in the storage folder. This is very similar to the issue with linking emails. I wondered if there is a common thread?

I found the following post and made the suggested change. https://discussions.vtiger.com/discussion/189435/cant-save-anything-that-is-uploaded

The different file types now upload correctly as documents and the hyperlinks work as they should.

I can now also link these file types correctly as email attachments but only with Vtiger Mail Manager. The Outlook plugin still fails to attach them.

Now looks like two bugs but perhaps that's progress ...