I was checking the Activity Log, and ordered it by Date descending.

When I then click on the Complaints / Home, it gives error:

DB function failed with error number 1054 Unknown column 'm.date' in 'order clause' SQL=SELECT m.*, concat(m.name, " ", m.email, " ", m.phone, " ", m.ip_address) as sender, g.area as area, u.name as resolver, e.name as editor FROM jos_complaints as m left join jos_complaint_areas as g on (m.complaint_area_id = g.id) left join jos_users as u on (m.resolver_id = u.id) left join jos_users as e on (m.editor_id = e.id) ORDER BY m.date asc LIMIT 0, 20

I can fix it by re-ordering the Activity Log based on, for example, the Id, or the User. However, if I choose to re-order the Activity Log again by the date, and then go to Complaints / Home, then it gives same error.

Getting similar problems when I order in other fields.