The phone numbers should've never been touched. They should still be in _comprofiler in the cb_phone database column. If not check to see if the alias column is there and if it contains the phone numbers. If it does rename that column to cb_phone, but it shouldn't have renamed that column. The below query will change the alias column to cb_phone in the event the cb_phone column was renamed.


Please be sure to be making backups before running any direct database queries.

Why do you have a second phone field? Did you run CB > Tools > Sample Data and create a second one? The field with fieldid 96 should not exist and is likely the cause of your issues. The field with fieldid 43 is the reverted alias field. Check within _comprofiler if the phone numbers are stored in the "alias" column or the "cb_phone" column. If they're stored in the "alias" column delete that second cb_phone field (with fieldid 96) and run the query provided above again. If they're stored in the "cb_phone" column then simply delete the field with fieldid 96 directly through the database in _comprofiler_fields.