AnsweredAssumed Answered

"Unexpected values found in emails" when upgrading to 8.0

Question asked by Nicolas Urech on May 4, 2018
Latest reply on Nov 20, 2018 by Zac Sprackett

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 ?

Outcomes