Need Help!!

We are running Sugar Version 3.5 MySQL Version 4.0.24
We are running into a few problems now that we are using the case module more.. When we search by Case Number this error appears. But now this error is also coming up on the screen when certain users try to log in. I can solve the problem quickly by just changing the users id. But if they search by case number it appears again,.


Error retrieving Case list: Query Failed:SELECT cases.*, accounts.name as account_name1, 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 cases.number asc LIMIT 0,20::MySQL error 1054: Unknown column 'cases.number' in 'order clause'