SugarCRM Bug Tracker

Home | Search

Bug: Leads: listviewdefs.php, 'name' definition lacks 'orderby' -- db error occurs

Bug Number:	13173
Subject:	Leads: listviewdefs.php, 'name' definition lacks 'orderby' -- db error occurs
Type:	Defect
Status:	Closed
Sugar Edition:	open_source
Product Category:	Leads
Found In Release:	4.5.1d
Targeted Release:	4.5.1.patch
Priority:	Low
Resolution:	Out of Date
Date Entered:	2007-05-28 07:07:10 (GMT)
Date Modified:	2008-08-28 22:06:53 (GMT)
Description:	Due to "incomplete" 'name' definition in the listviewdefs.php, Sugar makes db error: 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 5,1::MySQL error 1054: Unknown column 'name' in 'order clause' , when trying to see record details (detailview) in the sorted (by name) listview. Adding to listviewdefs.php, 'name' definition: 'orderBy' => 'last_name', solves the problem.
Code Fix Proposed:

---

Notes

Subject: 13173 Bug

Note: Hi, Can you pls tell if the bug still exits, thanks

Posted by: anitha

Last Modified: 29 Jul 2008 23:17:42

You must be logged in to add a note.