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

Question

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

sanjay Marwal · Accepted Answer

Hello Marwal, Your custom fields should appear in these locations custom/Extension/modules//Ext/Vardefs custom/Extension/modules//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