"Unexpected values found in emails" when upgrading to 8.0

Hello,

When doing the upgrade from 7.9.4 to 8.0, I had this warning during the healthcheck :

82. Unexpected values found in emails
Invalid status and type for emails: status=read, type=out Learn more...

83. Unexpected values found in emails
Invalid status and type for emails: status=read, type=archived Learn more...

84. Unexpected values found in emails
Invalid status and type for emails: status=read, type=draft Learn more...

The explanation link is broken : http://support.sugarcrm.com/Knowledge_Base/Installation_Upgrade/Troubleshooting_Health_Check_Output/Health_Check_Error_Invalid_Status_and_Type_for_Emails/

I did the update anyway and now all my existing emails have a status of "Archived" instead of Sent/Read/Unread. I sent a new e-mail and it was set to "Archived" instead of Sent.

I saw that in the database, the table "emails" has a new field "state". So it seems that the interface display the state instead of the status of the e-mail because the e-mail has the state "sent" in the database;

How to fix this ?

Parents

0 Bastien R over 6 years ago

According to sugarcrm, this is on purpose (https://support.sugarcrm.com/Knowledge_Base/Installation_Upgrade/What_to_Expect_When_Upgrading_to_8.0/ )
7.9: Email records may have a status of Read, Unread, Sent, etc.
8.0: Email records have a status of Draft or Archived."
That is a silly step back...
Cancel
Vote Up +1 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Dave Newbern over 6 years ago in reply to Bastien R

This is more than a silly step beck. This is very useful when trying to use SugarCRM as a support-system - being able to tell which emails are the new ones relating to a case and not having to look through them all. Though along with the removal of being able to "send as" a group user, it is becoming painfully obvious that SugarCRM wants nothing to do with the support side of CRM. Or they have no idea how businesses operate. Or they want to foster the development of more customizations at he partner level by allowing partners to offer to re-code all of the value back into the email module. Frustrated.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Bastien R over 6 years ago in reply to Dave Newbern

I have exactly the same issues as you. We use sugarcrm mainly for our customer's support. The "send as" address (
Allow users to send emails using the "From" Name and Address as the reply to address), is an essential functionnality. It's broke since 8.0.0 and they weren't able to fix it in the 8.0.1...
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Bastien R over 6 years ago in reply to Dave Newbern

I have exactly the same issues as you. We use sugarcrm mainly for our customer's support. The "send as" address (
Allow users to send emails using the "From" Name and Address as the reply to address), is an essential functionnality. It's broke since 8.0.0 and they weren't able to fix it in the 8.0.1...
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data