leads sort order by name

[sigarffs]

Hello,

There seems to be a problem when selecting a lead after sorting by first name. When selecting a lead the following query failure shows:

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.first_name like 'd%' AND leads.assigned_user_id ='721d3e61-f392-c7e9-36c4-4651bb8e44f4' AND leads.assigned_user_id ='721d3e61-f392-c7e9-36c4-4651bb8e44f4' ) AND leads.deleted=0 ORDER BY name ASC LIMIT 2,1::MySQL error 1054: Unknown column 'name' in 'order clause'

I tried the query in MySql. The table leads has no field called 'name'. This is the column name of the web interface. Seems to be a bug, because if name is substitute by first_name ( a column that exists in table leads) the query on MySql returns results.

Also, if leads are sorted by "status" (on the web interface) there are no problems. However, when sorting by "status", leads are not listed by name and it makes it hard finding them.

Suggestions and ideas are welcome.

Thank you.

Krassimri S.

[Angel]

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

[eggsurplus]

Another solution is to turn off the vcr by adding
'disable_vcr' => true,
to your config.php