Can't Open Leads

[rebdiamond]

I cannot open leads when I click on them from the Leads List. The only thing that works is for me to go to the Last Viewed list and click on the lead there.

Here is the error message I receive when clicking from the Leads List.

Error retrieving Lead list: Query Failed:SELECT leads.*, users.user_name assigned_user_name FROM leads LEFT JOIN users ON leads.assigned_user_id=users.id where leads.deleted=0 ORDER BY name ASC LIMIT 0,1::MySQL error 1054: Unknown column 'name' in 'order clause'

Any help is greatly appreciated.

Thank You

[Angel]

This is due to a known bug in Sugar.

See here for fix: http://www.sugarcrm.com/forums/showthread.php?t=23908

[eggsurplus]

Hi rebdiamond,

To get the message to go away mean time just click on a different column to sort. This should remove the issue. Just don't click on the name column or this will appear again.