Sort preferences are stored in the client.sort_prefs column of the database and it remembers the last applied sort settings. Therefore, when a client sorts the data by time, the history is not available and the error occurs.
Before doing any work on your database please make sure that you have a current backup, as this will make a permanent change to your database.
Note: To backup the database, refer to How to Backup/Restore the WHD Database.
1. Stop WHD Services - Start/Stop WHD Services.
2. Open the WHD database.
3. Execute the SQL statement:
update client set sort_prefs = null where client_id = X
4. Start WHD Services.