Problem with stamp

[mergulhao83]

Why entering this url goes ok:

http://pc275/homologacao/index.php?a...96090087708700

And entering this, get an error:

http://pc275/homologacao/index.php?a...96864027605700

The error:

aCaseError 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, teams.name AS team_name , cases_cstm.* FROM cases LEFT JOIN users ON cases.assigned_user_id=users.id LEFT JOIN teams ON cases.team_id=teams.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 0,1::MySQL error 1054: Unknown column 'account_name' in 'order clause'

The url that generates the error is generated by the ListView of cases ordering it by Account Name. When ordering by any other Column goes ok. The diference between one and the other is the "stamp" parameter.

Thanks for any help.

[mergulhao83]

The version is Sugar Pro 4.5.1.
Thanks for any help.

[kbrill]

To fix this, drop the account_name filed in the cases module. It is there from an older version of SugarCRM and is no longer used.