SugarCRM crafted MySQL queries FAILS after silentUpgrade 6.1.2 to 6.3.0

**savoirfaire** · 2011-12-09, 06:14 PM

Here is an example of what is logged in sugarcrm.log :

SELECT prospect_lists.id , prospect_lists.name , prospect_lists.description , prospect_lists.list_type , prospect_lists.assigned_user_id , 'prospectlists' panel_name FROM prospect_lists INNER JOIN prospect_lists_prospects ON leads.id=prospect_lists_prospects.related_id AND prospect_lists_prospects.prospect_list_id='593803c 3-505e-acc7-a85c-4e78d076b78d' AND prospect_lists_prospects.deleted=0 AND prospect_lists_prospects.related_type = 'Leads' where prospect_lists.deleted=0 ORDER BY prospect_lists.id asc LIMIT 0,11;

and thus it returns : ERROR 1054 (42S22): Unknown column 'leads.id' in 'on clause'

--------

There is many queries like this. Especially we hit them on the Leads module, when clicking on a Contact.
It results in a 'Database failure, please refer to sugarcrm.log' message at the bottom of the Lead informaiton.