How I can Delete Relate Field... manually becaue i am not able to delete from studio. (CE edition)

Hello , By mistake I created a relate field in studio and after finishing project when i try to export data from module that Error show "Database failure. Please refer to sugarcrm.log for details." and when i checked log than it shows "       

: MySQL error 1054: Unknown column 'fc_claims.fc_car_id_c' in  'on clause'

Please help me out.. Thanks

   
  • Hello Marwal,

    Your custom fields should appear in these locations

    custom/Extension/modules/<MODULE>/Ext/Vardefs
    custom/Extension/modules/<MODULE>/Ext/Layoutdefs (if you have a subpanel)

    Your custom relationships should appear here

    custom/metadata
    custom/Extension/application/Ext/TableDictionary/

    Just move those files to a directory named "Disabled" and then go to Admin > Repair > Quick Repair and Rebuild. That will manually remove the relationships, fields, and subpanels. Remember, when deleting vardefs and layoutdefs, you need to delete them on both sides of the relationship. So if you created a custom relationship between Accounts and Cases, you will need to go the Accounts directory and Cases diretory and remove the fields there. 

    Let me know if this helps. 

    Kind Regards, 

    Jason Smith