After upgrading to 4.5 GA I was having trouble searching for some of my custom fields so I ran Repair Custom Fields. After running it all my data in those fields was deleted from the database. I did this on a clone of my production server so it did no real harm but is this expected behavior. Am I doing something wrong or should I just never run this on the production server.
I am on a windows bitrock installation with MySQL 3.23.49 PHP 4.4.3 Windows XP Sugar 4.5GA Apache 2.0.55
This is what the Repair Custom Fields ran
Scanning Accounts
Dropping Column account_number_c from accounts_cstm for module Accounts
Dropping Column amf_expires_c from accounts_cstm for module Accounts
Dropping Column amf_fee_c from accounts_cstm for module Accounts
Dropping Column amf_level_c from accounts_cstm for module Accounts
Dropping Column amf_status_c from accounts_cstm for module Accounts
Dropping Column department_c from accounts_cstm for module Accounts
Dropping Column existing_product_version_c from accounts_cstm for module Accounts
Dropping Column module_3d_brachytherapy_c from accounts_cstm for module Accounts
Dropping Column module_3d_external_beam_c from accounts_cstm for module Accounts
Dropping Column module_dao_imrt_c from accounts_cstm for module Accounts
Dropping Column module_jimrt_c from accounts_cstm for module Accounts
Dropping Column module_solid_imrt_c from accounts_cstm for module Accounts
Dropping Column number_of_workstations_c from accounts_cstm for module Accounts
Dropping Column phone_1_type_c from accounts_cstm for module Accounts
Dropping Column phone_2_type_c from accounts_cstm for module Accounts
Dropping Column phone_3_type_c from accounts_cstm for module Accounts
Dropping Column phone_4_c from accounts_cstm for module Accounts
Dropping Column phone_4_type_c from accounts_cstm for module Accounts
Dropping Column referred_by_c from accounts_cstm for module Accounts
Dropping Column sales_region_c from accounts_cstm for module Accounts
Dropping Column sales_team_c from accounts_cstm for module Accounts
Dropping Column mass_mailings_c from accounts_cstm for module Accounts
Dropping Column source_c from accounts_cstm for module Accounts
Dropping Column existing_product_2d_c from accounts_cstm for module Accounts
Dropping Column tps_shiped_date_c from accounts_cstm for module Accounts
Dropping Column tps_version_sent_c from accounts_cstm for module Accounts
Dropping Column tps_version_in_use_c from accounts_cstm for module Accounts
Dropping Column brachy_amf_expires_c from accounts_cstm for module Accounts
Dropping Column conformal_of_licenses_c from accounts_cstm for module Accounts
Dropping Column conformal_amf_expires_c from accounts_cstm for module Accounts
Dropping Column dimrt_of_licenses_c from accounts_cstm for module Accounts
Dropping Column jimrt_of_licenses_c from accounts_cstm for module Accounts
Dropping Column dimrt_amf_expires_c from accounts_cstm for module Accounts
Dropping Column jimrt_amf_expires_c from accounts_cstm for module Accounts
Dropping Column simrt_amf_expires_c from accounts_cstm for module Accounts
Dropping Column simrt_of_licenses_c from accounts_cstm for module Accounts
Dropping Column mtps_shiped_date_c from accounts_cstm for module Accounts
Dropping Column mtps_version_sent_c from accounts_cstm for module Accounts
Dropping Column mtps_version_in_use_c from accounts_cstm for module Accounts
Dropping Column mtps_of_licenses_c from accounts_cstm for module Accounts
Dropping Column mtps_amf_expires_c from accounts_cstm for module Accounts
Dropping Column qa_tool_of_licenses_c from accounts_cstm for module Accounts
Dropping Column qa_tool_version_sent_c from accounts_cstm for module Accounts
Dropping Column qa_tool_version_in_use_c from accounts_cstm for module Accounts
Dropping Column qa_tool_lasts_shipped_c from accounts_cstm for module Accounts
Dropping Column qa_tool_amf_expires_c from accounts_cstm for module Accounts
54 field(s) missing from accounts_cstm
Adding Column Account_Number_c to accounts_cstm
Adding Column AMF_Expires_c to accounts_cstm
Adding Column AMF_Fee_c to accounts_cstm
Adding Column AMF_Level_c to accounts_cstm
Adding Column AMF_Status_c to accounts_cstm
Adding Column Department_c to accounts_cstm
Adding Column Existing_Product_Version_c to accounts_cstm
Adding Column Module_3D_Brachytherapy_c to accounts_cstm
Adding Column Module_3D_External_Beam_c to accounts_cstm
Adding Column Module_DAO_IMRT_c to accounts_cstm
Adding Column Module_JIMRT_c to accounts_cstm
Adding Column Module_Solid_IMRT_c to accounts_cstm
Adding Column Number_of_Workstations_c to accounts_cstm
Adding Column Phone_1_Type_c to accounts_cstm
Adding Column Phone_2_Type_c to accounts_cstm
Adding Column Phone_3_Type_c to accounts_cstm
Adding Column Phone_4_c to accounts_cstm
Adding Column Phone_4_Type_c to accounts_cstm
Adding Column Referred_By_c to accounts_cstm
Adding Column Sales_Region_c to accounts_cstm
Adding Column Sales_Team_c to accounts_cstm
Adding Column Mass_Mailings_c to accounts_cstm
Adding Column Source_c to accounts_cstm
Adding Column Existing_Product_2D_c to accounts_cstm
Adding Column TPS_Shiped_Date_c to accounts_cstm
Adding Column TPS_Version_Sent_c to accounts_cstm
Adding Column TPS_Version_In_Use_c to accounts_cstm
Adding Column Brachy_of_Licenses_c to accounts_cstm
Adding Column Brachy_AMF_Expires_c to accounts_cstm
Adding Column Brachy_AMF_Fee_c to accounts_cstm
Adding Column Conformal_of_Licenses_c to accounts_cstm
Adding Column Conformal_AMF_Expires_c to accounts_cstm
Adding Column Conformal_AMF_Fee_c to accounts_cstm
Adding Column DIMRT_of_Licenses_c to accounts_cstm
Adding Column JIMRT_of_Licenses_c to accounts_cstm
Adding Column DIMRT_AMF_Expires_c to accounts_cstm
Adding Column JIMRT_AMF_Expires_c to accounts_cstm
Adding Column SIMRT_AMF_Expires_c to accounts_cstm
Adding Column DIMRT_AMF_Fee_c to accounts_cstm
Adding Column JIMRT_AMF_Fee_c to accounts_cstm
Adding Column SIMRT_AMF_Fee_c to accounts_cstm
Adding Column SIMRT_of_Licenses_c to accounts_cstm
Adding Column MTPS_Shiped_Date_c to accounts_cstm
Adding Column MTPS_Version_Sent_c to accounts_cstm
Adding Column MTPS_Version_In_Use_c to accounts_cstm
Adding Column MTPS_of_Licenses_c to accounts_cstm
Adding Column MTPS_AMF_Expires_c to accounts_cstm
Adding Column MTPS_AMF_Fee_c to accounts_cstm
Adding Column QA_Tool_of_Licenses_c to accounts_cstm
Adding Column QA_Tool_Version_Sent_c to accounts_cstm
Adding Column QA_Tool_Version_In_Use_c to accounts_cstm
Adding Column QA_Tool_Lasts_Shipped_c to accounts_cstm
Adding Column QA_Tool_AMF_Expires_c to accounts_cstm
Adding Column QA_Tool_AMF_Fee_c to accounts_cstm
Scanning Bugs
Fixing Column Type for closed_c changing tinyint(1) to bool
Dropping Column foundbuild_c from bugs_cstm for module Bugs
Dropping Column fixedbuild_c from bugs_cstm for module Bugs
Dropping Column death_or_injury_c from bugs_cstm for module Bugs
Dropping Column bug_number__c from bugs_cstm for module Bugs
Dropping Column target_build_c from bugs_cstm for module Bugs
Dropping Column fixedversion_c from bugs_cstm for module Bugs
Dropping Column foundversion_c from bugs_cstm for module Bugs
Dropping Column prowess_hardware_c from bugs_cstm for module Bugs
Dropping Column targetversion_c from bugs_cstm for module Bugs
Dropping Column feature_c from bugs_cstm for module Bugs
10 field(s) missing from bugs_cstm
Adding Column FoundBuild_c to bugs_cstm
Adding Column FixedBuild_c to bugs_cstm
Adding Column Death_Or_Injury_c to bugs_cstm
Adding Column Bug_Number__c to bugs_cstm
Adding Column Target_Build_c to bugs_cstm
Adding Column FixedVersion_c to bugs_cstm
Adding Column FoundVersion_c to bugs_cstm
Adding Column Prowess_Hardware_c to bugs_cstm
Adding Column TargetVersion_c to bugs_cstm
Adding Column Feature_c to bugs_cstm
Scanning Cases
Fixing Column Type for prowess_hardware_c changing tinyint(1) to bool
Dropping Column death_or_injury_c from cases_cstm for module Cases
1 field(s) missing from cases_cstm
Adding Column Death_or_Injury_c to cases_cstm
Scanning Contacts
Dropping Column initial_c from contacts_cstm for module Contacts
Dropping Column web_site_c from contacts_cstm for module Contacts
Dropping Column phone_1_type_c from contacts_cstm for module Contacts
Dropping Column phone_2_type_c from contacts_cstm for module Contacts
Dropping Column phone_3_type_c from contacts_cstm for module Contacts
Dropping Column phone_4_c from contacts_cstm for module Contacts
Dropping Column phone_4_type_c from contacts_cstm for module Contacts
Dropping Column mail_salutation_c from contacts_cstm for module Contacts
Dropping Column credentials_c from contacts_cstm for module Contacts
Dropping Column mass_mailings_c from contacts_cstm for module Contacts
Dropping Column referred_by_c from contacts_cstm for module Contacts
Dropping Column source_c from contacts_cstm for module Contacts
Dropping Column nickname_c from contacts_cstm for module Contacts
13 field(s) missing from contacts_cstm
Adding Column Initial_c to contacts_cstm
Adding Column Web_Site_c to contacts_cstm
Adding Column Phone_1_Type_c to contacts_cstm
Adding Column Phone_2_Type_c to contacts_cstm
Adding Column Phone_3_Type_c to contacts_cstm
Adding Column Phone_4_c to contacts_cstm
Adding Column Phone_4_Type_c to contacts_cstm
Adding Column Mail_Salutation_c to contacts_cstm
Adding Column Credentials_c to contacts_cstm
Adding Column Mass_Mailings_c to contacts_cstm
Adding Column Referred_By_c to contacts_cstm
Adding Column Source_c to contacts_cstm
Adding Column Nickname_c to contacts_cstm
Scanning Opportunities
Dropping Column quote_number_c from opportunities_cstm for module Opportunities
1 field(s) missing from opportunities_cstm
Adding Column Quote_Number_c to opportunities_cstm
Done


LinkBack URL
About LinkBacks



Reply With Quote
Bookmarks