Email attachments and images not accessable when receiving email

JamesPrivate · 11 April 2021 14:19

Hi Guys,

Just upgraded from 7.8.4 to 7.11.18.

When someone sends an email to the new install, I can’t access an attachment (something as simple as a text file).

If I forward the email, then the attachment shows up and is accessible. So it is there, I just can’t access it when reading the email.

I also don’t see an image placed in the email by the sender. For example, they used the Windows snipping tool to put the image in the email.

Any ideas what may be going on?

Screen shot when received

Here is the screen shot when I forward, now attachment can be seen

John · 5 July 2021 12:32

Hey there,

Are you still having issues with this?

I believe that the Email functionality behaves quite differently now, as of 7.9

The CRM now grabs the minimal amount of information from the Mail server, for the initial viewing of the Email

You should be able to view the attachment, and all other info related to the Email record, by clicking “Import” on the Actions menu

You can read on this more here:

JamesPrivate · 15 July 2021 17:17

Hi John,

Yes, I am still having this issue. Thank you for getting back. This is version 7.11.18 that I am having this problem.

I just tried your suggestion, but don’t see an IMPORT option. We get voicemail in our Inbox. Sometimes we just want to listen quickly, w/o hassle. Same with quite a few other attachments.

Just these:

JamesPrivate · 15 July 2021 17:23

Just tried another user account, and it does indeed have the IMPORT. This one only has the following below. But I still do not see the attachment. And now after playing with it, the IMPORT goes away if you read the email, and then come back to it later. Then you see the list above.

JamesPrivate · 15 July 2021 17:50

Looks like there was an issue with this in earlier version, but after reviewing the code in 7.11.18, it was changed as suggested in these link. But still not working for me. I have ensured Permissions on everything is Enabled and set to ALL.

github.com/salesagility/SuiteCRM

function isOwner() in SugarBean.php is not checking permissions ok

opened 09:11PM - 15 Oct 19 UTC

closed 02:25PM - 04 Nov 19 UTC

Abuelodelanada

Type: Bug Status:Fix Proposed Priority:Important

#### Issue Investigating why an user with "owner permissions" in 'Notes' mo…dule could not enter the DetailView of a record that was created by him, I found that we have a problem with the method [`isOwner()` in SugarBean.php](https://github.com/salesagility/SuiteCRM/blob/master/data/SugarBean.php#L1673) The `isOwner()` method is [checking: `isset($this->assigned_user_id)`](https://github.com/salesagility/SuiteCRM/blob/master/data/SugarBean.php#L1685) ```php } elseif (isset($this->assigned_user_id)) { if ($this->assigned_user_id == $user_id) { return true; } return false; } ``` But if `$this->assigned_user_id` is `''` the function [`isset`](https://www.php.net/isset) will return true, so the execution will enter into the `elseif` and will check `$this->assigned_user_id == $user_id` and in other words will check something like this: `'' == '7cb40869-3ca6-7c88-006c-5da61ac6dc6e'` which is `false`. This behavior prevents the execution from reaching the next check that will return `true` because the record was created by the user, so `$this->created_by == $user_id` is `true` ```php //other wise if there is a created_by that is the owner if (isset($this->created_by) && $this->created_by == $user_id) { return true; } ``` #### Expected Behavior `isOwner()` checks permissions in a good way ;-) #### Actual Behavior A user that creates a 'Note' cannot go to the DetailView of that record. The `isOwner()` method is not checking permissions in a bad way. #### Possible Fix We should use [`!empty()`](https://www.php.net/empty#refsect1-function.empty-description) instead of [`isset()`](https://www.php.net/isset) #### Steps to Reproduce 1. Create and Role and assign an user to this Role. 2. Set the followings permissions to the module Notes for this Role: ``` access: 89 delete: -99 edit: 75 export: -99 import: -99 list: 75 view: 75 ``` 3. Login with this user 4. Create a Note 5. Try to go to the DetailView. #### Your Environment * SuiteCRM Version used: 7.10.20 * Environment name and version (e.g. MySQL, PHP 7): MySQL 8.0.x / PHP 7.3.x

John · 26 July 2021 15:02

Hey,

Thank you for the clarifications!

hmmm

As far as I’m aware, the “Import” action, as well as the shorter list of actions:

Should only appear if the Email has not yet been imported into the CRM
(This is the stage in which the Attachments are normally not available to use/see in Notes/Documents modules)

Only after Importing, should you see the longer set of options:

(As well as attachments then being available)

You can tell if an Email has been imported by the Purple Checkmark:

So, the Actions available shouldn’t change simply from:
Clicking onto the Record -> Navigating away -> Clicking onto the record again

However, it seems to be behaving differently on your instance, is that right?

Do you recall what Upgrade path you have taken from 7.8.4->7.11.18?
I’d like to try to replicate it.

Also, after upgrading, have you run either:

Quick Repair and Rebuild
Rebuild JS Grouping Files
In Admin->Repair ?

I would recommend running these, as it can rule out any odd caching issues from the Upgrade

It may also be worth ensuring the File/Folder permissions are up-to-date, especially on any new files from the upgrades.

We usually recommend:

sudo chmod -R 755 .
sudo chmod -R 775 cache custom modules themes data upload config_override.php
sudo chown -R www-data:www-data .

(Replacing www-data with your web server user)

JamesPrivate · 5 August 2021 00:07

I have done the rebuilds (more times than I can remember !)

Here is my upgrade path

(if fails go to C:\wamp64\www\SuiteCRM\cache\upgrades\temp and delete file)
7.8.4 to 7.8.10
7.8.10 to 7.8.29
ran the batch file to create theme cach directorys - see documents
7.8.x to 7.9.16
7.9.16 to 7.10.6
7.10.x to 7.11.18

BTW - This is not the first time I’ve had this problem. Ive done this upgrade several times, and different versions of just about everything and have always ran into this problem.

JamesPrivate · 12 August 2021 14:52

I also tried this path, which broke in 7.9.17, but then I continued as indicated above to see if it would “self correct”. Have tried several upgrade paths, but always have ended up with this problem.

7.8.4 -> 7.8.11 -> 7.8.19->7.8.27->7.8.31 (email good to this point)

From 7.8.31 jumped to 7.9.17 and email is broken

JamesPrivate · 25 December 2022 13:46

Well, if anyone is still out there, still having this issue. Tried a brand new, fresh install of SuiteCRM 8.2.2 Still do not have ability to view attachments when viewing an email. Can see they are there, but can’t access the attachment. I can perform an import, and then the attachment is available. But not until then. Is this the expected behavior?

This is what it looks like

And then when I open the email

As you can see, there is no link to click on to view the attachment. Now, if I select Import, then it looks like this. Seems odd that you need to import in order to gain access to the attachment? Is this expected behavior? I don’t even have to select where it gets imported, just import to nothing???

Once import has been peformed, all of these options show up below the email, and then the attachment can be viewed