SQL error on Leads

[al3]

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.status in ('In Process')) AND leads.deleted=0 ORDER BY name ASC LIMIT 3,1::MySQL error 1054: Unknown column 'name' in 'order clause'

If Leads are sorted on Contact I get the above when I click on one of them.

If sorted by Account, it is OK.

I looked all over on where to file a bug, but didn't fine it.

Thanks,

Al
Sugar 4.5.1e, FreeBSD 6.2, MySQL 5.x, PHP 5.x, Apache 2.x

[sacramentojoe]

If you have access to the files, you can change this on the ListView.html file.

Change the top part where the name is to leads.last_name

, this should fix it

[al3]

If you have access to the files, you can change this on the ListView.html file.

Change the top part where the name is to leads.last_name

, this should fix it

Sorry, I just don't see the line in file to change. Can you give an example?

Thanks,
Al

[sacramentojoe]

ListView.html

<td scope="col" width="15%" class="listViewThS1"><slot><a href="{ORDER_BY}last_name" class="listViewThLinkS1">{MOD.LBL_LIST_NAME}{arrow _start}{last_name_arrow}{arrow_end}</span></a></slot></td>


See where it says <a href="{ORDER_BY}last_name

[al3]

ListView.html

<td scope="col" width="15%" class="listViewThS1"><slot><a href="{ORDER_BY}last_name" class="listViewThLinkS1">{MOD.LBL_LIST_NAME}{arrow _start}{last_name_arrow}{arrow_end}</span></a></slot></td>


See where it says <a href="{ORDER_BY}last_name

Here is what I put in /modules/leads/listview.html:
<!-- END: list_nav_row -->
<tr height="20">
<td scope="col" class="listViewThS1" NOWRAP>{CHECKALL}</td>
<td scope="col" width="20%" class="listViewThS1"><slot><a href="{ORDER_BY}leads.last_name" class="listViewThLinkS1">{MOD.LBL_LIST_NAME}{arrow _start}{last_name_arrow}{

-------
I still get:
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 4,1::MySQL error 1054: Unknown column 'name' in 'order clause'

Must be in a different module?

Al

[Angel]

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

[al3]

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

Thanks. Worked great.

Al