Case query sorted by Account - SQL Error

[EFSNetworks]

Whenever I click on a case to view its details I get the following error:

This happens only when the cases are sorted by account. If I sort the cases by any other column then try to view the details on a case - the query pulls up the case details correclty.

Here is a copy of the error message

Error retrieving Case list: Query Failed:SELECT cases.*, accounts.name as account_name1, accounts.assigned_user_id account_name1_owner, users.user_name as assigned_user_name , cases_cstm.* FROM cases LEFT JOIN users ON cases.assigned_user_id=users.id LEFT JOIN accounts ON cases.account_id=accounts.id LEFT JOIN cases_cstm ON cases.id = cases_cstm.id_c where cases.deleted=0 AND accounts.deleted=0 ORDER BY account_name ASC LIMIT 2,1::MySQL error 1054: Unknown column 'account_name' in 'order clause'[/SIZE][/SIZE][/FONT][/COLOR]

[ksechrist]

I am experiencing the exact same thing! Anyone, please, help?

[Angel]

This must be "Error 1054" day. LOL

Does the same occur if you sort the list view on a column other than Account Name prior to viewing one of the cases?