Mass Update Error: MySQL error 1054: Unknown column 'jt1.name' in 'where clause'

[lateefkhan]

Hi,
I have upgraded my SugarCRM from 5.0 (Build 3098) to Build 3391. Now when i want to import contacts including approx 800 leads, it gives me the following error:

Query Failed:SELECT leads.*, email_addresses.email_address, users.user_name assigned_user_name , leads_cstm.* FROM leads LEFT JOIN users ON leads.assigned_user_id=users.id LEFT JOIN email_addr_bean_rel on leads.id = email_addr_bean_rel.bean_id and email_addr_bean_rel.bean_module='Leads' and email_addr_bean_rel.deleted = 0 and email_addr_bean_rel.primary_address=1 LEFT JOIN email_addresses on email_addresses.id = email_addr_bean_rel.email_address_id LEFT JOIN leads_cstm ON leads.id = leads_cstm.id_c where (((leads.assigned_user_id in ('3c53c50a-a35a-fe5d-fe70-486b457818da') ) AND ( leads.status in ('New') ) AND ( jt1.name like 'education %')) AND leads.deleted=0) AND leads.deleted=0 ::MySQL error 1054: Unknown column 'jt1.name' in 'where clause'

when i try to update the leads in 20 20 sets its don without error.
I tried to fix this issue, i could not find jt1.name, i think it is a linked table (custom table). Any one could help me please

[andopes]

Hi lateefkhan

It seems the Contacts vardefs had been corrupted.
Copy the Contacts vardefs.php from a clean sugar installation (exactly the same version) and run the Quick Repair and Rebuild from Admin -> Repair

Cheers