Unalbe to delete imap email

[brendan-pike]

After an upgrade from 7.13 to 8.3.1 I've found I can not delete email from email / imap,

We do not auto-import or convert any email. Trying to delete an email using bulk action - delete does not work, neither does viewing the email in full then selecting delete from imap in the actions.

Nothing in logs indicates any issues I could see.

We use PHP 7.4.33 (cli) (built: Jun 8 2023 15:23:07) ( NTS ) Copyright (c) The PHP Group Zend Engine v3.4.0, Copyright (c) Zend Technologies with Zend OPcache v7.4.33, Copyright (c), by Zend Technologies

I tested this in Firefox 115.0.2 (64-bit) on linux.

I think its unrelated but the 'test connection' email account tool on the existing inbound account failed even though it would successfully read new email. I then added a new account with the same details and then the connection test worked.

Let me know if I can help further.

[johnM2401]

Hey!

Thanks for getting in touch

I've tried to replicate, but haven't been able to yet, i'm afraid Would you be able to give us a little bit more information on this issue?

ie: Was this an Email Account that existed pre-upgrade? (or added post-upgrade) Was this with a particular Email Provider? (ie: outlook/gmail) On your newly created Email Account, do you still see this issue? (Or are you able to delete Emails on this new account?)

If you are able to delete emails successfully on the newly created account, (which passes the connection test), then this may indicate an issue with the credentials used in the original email account.

But it would be good to get more info to narrow things down.

Thanks!

[brendan-pike]

Thanks John

1. The account was pre-existing.
2. I use fastmail.com but I will try adding a gmail account and see if works and report back.
3. I also re-added the same account post upgrade but still can't delete emails
4. I reviewed the app password access I created and it states the account can: "Has access to • Download, modify, and permanently delete your mail. (IMAP/POP) • Send mail from you. (SMTP)"

When trying to delete it goes quite slow and then reloads the same email, this in the logs:

Mon Aug  7 14:41:37 2023 [1050871][1][FATAL] ImapHandler trying to use a non valid resource stream.
Mon Aug  7 14:41:37 2023 [1050871][1][FATAL] ImapHandler trying to use a non valid resource stream.
Mon Aug  7 14:41:43 2023 [1050871][1][FATAL] An Imap error detected: "IMAP reopen error"
Mon Aug  7 14:41:43 2023 [1050871][1][FATAL] An Imap error detected: "IMAP mailMove error"
Mon Aug  7 14:41:43 2023 [1050871][1][FATAL] INBOUNDEMAIL: MoveEmail to Trash FAILED - trying hard delete for message: 16303
Mon Aug  7 14:41:43 2023 [1050871][1][FATAL] An Imap error detected: "IMAP expunge error"
Mon Aug  7 14:41:43 2023 [1050670][1][FATAL] ImapHandler trying to use a non valid resource stream.
Mon Aug  7 14:41:43 2023 [1050670][1][FATAL] ImapHandler trying to use a non valid resource stream.
Mon Aug  7 14:41:47 2023 [1050871][1][ERROR] Unable to find relationship emails_email_templates
Mon Aug  7 14:41:47 2023 [1050871][1][ERROR] Unable to find relationship emails_email_templates
Mon Aug  7 14:41:48 2023 [1050670][1][FATAL] ImapHandler trying to use a non valid resource stream.
Mon Aug  7 14:41:48 2023 [1050670][1][FATAL] ImapHandler trying to use a non valid resource stream.
Mon Aug  7 14:42:02 2023 [1050899][1][FATAL] ImapHandler trying to use a non valid resource stream.
Mon Aug  7 14:42:02 2023 [1050899][1][FATAL] ImapHandler trying to use a non valid resource stream.

• I have also now tried a gmail account and that worked correctly. So the issue is something to do with the way fastmail.com interacts.
• I should also point out that we used fastmail without problems in SuiteCRM 7.*

[brendan-pike]

@johnM2401 please review and let me know what more information I can provide.

[Mausino]

@brendan-pike @johnM2401 I have with email in fresh version of SuiteCRN 8.4 also issues.

I cant see subject of the email in list view.. still see (no_subject) In detailview i dont see from, to, subject all is empty. Also problem with import. When you you by luck import email.. you have also prolbem with relationshipts. I looked to database and dont email_text -> description field in DB saved null value. Same problem with table emails -> parent_type + parent_id there is also null

if somebody want i can create new issue with screenshots or new post where i will describe all in screens from crm and DB.

It look like all email module is broken in new SuiteCRM 8.4