Hi all,

I'm using Sugar Version 4.5.1 (Build 1197).
Here's my problem:
Selecting a call (or a meeting) from the list view by clicking on the subject while the list is ordered by related contacts results in an error:

Error retrieving Call list: Query Failed:SELECT calls.*, users.user_name as assigned_user_name , calls_cstm.*, CONCAT( calls.date_start, CONCAT(' ', calls.time_start) ) AS datetime FROM calls LEFT JOIN users ON calls.assigned_user_id=users.id LEFT JOIN calls_cstm ON calls.id = calls_cstm.id_c where calls.deleted=0 ORDER BY contact_name ASC LIMIT 0,1::MySQL error 1054: Unknown column 'contact_name' in 'order clause'

So I think, I located the probelm in include\DetailView\DetailView.php line 146:

$order = $this->getLocalSessionVariable($seed->module_dir.'2_'.$html_varName, "ORDER_BY");

In Version 4.2.1b the second argument of the getLocalSessionVariable statement was "ORDER_BY_DETAIL" instead of "ORDER_BY". Changing the argument to "ORDER_BY_DETAIL" solves the problem, but I'm not sure, if this causes any other problems...

Thanks for any help on this...

With best regards
Tanja