Can not see contact list or lead list. all other modules fine

[kbusiness]

Here is an error I got from a contact:
Error retrieving Contact list: Query Failed: SELECT leads.id , leads.first_name , leads.last_name , as name, leads.refered_by , leads.lead_source , leads.phone_work , leads.email1 , leads.lead_source_description , jt0.user_name assigned_user_name , jt0.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, leads.assigned_user_id , 'leads' panel_name FROM leads LEFT JOIN users jt0 ON jt0.id= leads.assigned_user_id AND jt0.deleted=0 AND jt0.deleted=0 where ( leads.contact_id= '7a482fd0-3ecf-da54-341c-4636eadbca0d' AND leads.deleted=0) AND leads.deleted=0 ORDER BY leads.last_name,leads.first_name asc LIMIT 0,10::MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'as name, leads.refered_by , leads.lead_source , leads.phone_work , leads.email1 ' at line 1

Contact delete not set to 1
Contact list set to show 25 items.

How can I fix the module to show the contact list since it won't index and creat a list of contacts when the contacts tab is selected.

[pblag]

Hi!

There is a problem in line
leads.last_name , as name,

the code should be
leads.last_name as name,

without sign ',' after last_name

to fix it you have to find this code in your sugarCRM code

leads.last_name , as name

and replace it with correct one
leads.last_name as name,

[kbusiness]

what surgarcrm file would i be fixing to change this proglem?