Leads list erroring

[derekforeman]

When clicking on a lead from the list of leads in the lead module I get a sql error;


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

As you would expect removing the ORDER BY clause eliminates the error, however I'm wondering how the error originated in the first place? I've not loaded any extensions or modules to sugar, not modified any code or touched the database structure.. As with all things the statement "it just appeared" comes to mind... I have been adding custom fields to the leads module but haven't removed any of the default fields... Any thoughts on where to go with this one?

Thanks

[Angel]

See this thread: http://www.sugarcrm.com/forums/showthread.php?t=23908

[derekforeman]

Got it,

$ diff Lead.php.new Lead.php
262,270c262
<
< //BEGIN: 6/20/07 -- Fix for problem where sorting by name on listview causes a MySQL error when attempting to pull up DetailView, Angel Maga####amagana[at]actsgold.com, Acts Automation, Inc., www.actsautomation.com
< if($order_by == "name DESC") {
< $order_by = "leads.first_name + leads.last_name DESC";
< } elseif ($order_by == "name ASC") {
< $order_by = "leads.first_name + leads.last_name ASC";
< }
< //END
<
---
>


Cheers Angel. Has this been picked up by the Sugar dev team?

[Angel]

I submitted it and Julian (Sugar Team) was going to try to get it into the E patch, but it looks like it didn't make it.

Hopefully some iteration of it will make it into a future release.