OK, just got the upgrade to 6.2.3 to finally run and complete, but now I'm getting a SQL error when doing a search in certain modules.

10/21/11 09:35:49 [5968][6e4c3ec5-ee75-4277-9bba-48418426a033][FATAL] Query Failed: SELECT TOP 11 opportunities.id , opportunities.name , opportunities.sales_stage , opportunities.amount_usdollar , opportunities.currency_id , opportunities.date_closed , opportunities.assigned_user_id FROM opportunities LEFT JOIN opportunities_cstm ON opportunities.id = opportunities_cstm.id_c where (((opportunities.name like 'Simmons%' ) OR ( accounts.name like 'Simmons%'))) AND opportunities.deleted=0 ORDER BY opportunities.date_entered DESC: SQL Server error:

The multi-part identifier "accounts.name" could not be bound.

Based on what I can tell, this would imply the query used by SugarCRM CE is not properly written.

Anyone have any suggestions on how to best proceed to correct this?

This is SugarCRM CE 6.2.3 running on a MSSQL 2008 R2 DB engine.

Thanks.

-Mark-