Results 1 to 2 of 2

Thread: After running repair custom fields in 4.5GA data missing

  1. #1
    dseaton is offline Sugar Community Member
    Join Date
    Jan 2006
    Posts
    10

    Default After running repair custom fields in 4.5GA data missing

    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
    Attached Files Attached Files

  2. #2
    dseaton is offline Sugar Community Member
    Join Date
    Jan 2006
    Posts
    10

    Unhappy Re: After running repair custom fields in 4.5GA data missing

    Is this a Bug or is there something wrong with my instalation? What can I do to avoid this in the future?
    Anyone have any ideas,
    Dale

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •