SugarCRM Troubleshooting: Duplicate Column Error

sugarcrmdevelopers —  December 21, 2011

Some months back an interesting problem was brought to my attention. The problem at hand related to an error that occurred during the Quick Rebuild & Repair process and read as follows:

Executing repair query: Query Failed:ALTER TABLE leads_cstm add column my_customField_c char(36) NULL , add column my_customField_c char(36) NULL::MySQL error 1060: Duplicate column name ‘my_customField_c’