opened 02:12PM - 01 Feb 22 UTC
closed 03:42PM - 10 Feb 22 UTC
Type: Bug
Priority:Critical
The UTF8 repair tool deleted a lot of email, I used it with the ROBO CLI version… from the official changelog (https://docs.suitecrm.com/admin/releases/7.12.x/)
It updated a lot of entry :

I have those errors log :

And after running the code, nearly all the updated entry had their email deleted.
After investigation, comparing SQL file before and after running the tool, in the table "email_addr_bean_rel" bunch of entry have been updated and marked as deleted (from field deleted=0 to deleted=1)
#### Issue
The repair tool, used in Synchronous mode with ROBO CLI, used the code in the officiel changelog :
https://docs.suitecrm.com/admin/releases/7.12.x/
#### Steps to Reproduce
1. Just run the tool using ROBO CLI : ./vendor/bin/robo repair:normalize-record-encoding --sync-run
#### Context
My users hate the search engine which is not really good, was thinking it would help.
#### Your Environment
* SuiteCRM Version used : 7.12.3
* Browser name and version : Chrome latest 97.0.4692.99
* Environment name and version : PHPMyAdmin 4.9.9, PHP7.4
* Operating System and version : Linux