How to Recover a Crashing Hotshot Desktop App
If you attempted to open the Hotshot Mac app on macOS and the app appears to open for a moment, then immediately closes, open Applications in Finder, and right click on Hotshot, then click "Show package contents", click Contents > MacOS and then double click on Hotshot.
On a Mac, this will generate a Terminal crash log. If you see an error similar to the one below, then follow the steps in this article.
For Windows desktops, you can generate a similar log by attempting to run Hotshot from the command line. You can do that by opening a command prompt, then locating the Hotshot directory in your %ProgramFiles% location and running Hotshot.exe:
2018-06-11 12:35:00,662 - INFO - remoteCommand 'msgDown' from Peer
2018-06-11 12:35:00,662 - DEBUG - We have received 1 msgs during this connection.
2018-06-11 12:35:00,662 - INFO - msgID is 773955ddbd93730b9db5964e21d8cbc4
2018-06-11 12:35:00,664 - DEBUG - CH-9enAmdPm2ewsThBZ9MquqzHBUy4q5pf9 IS mentioned
2018-06-11 12:35:00,665 - DEBUG - CH-B4SAR7Pakv6jGtEG3jtrYKVBVSaKyn7N is NOT mentioned
2018-06-11 12:35:00,676 - CRITICAL - Major error occurred when trying to execute a SQL statement within the sqlThread. Error occurred while trying to execute statement: "INSERT INTO inbox VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?)" Here are the parameters; you might want to censor this data with asterisks (***) as it can contain private information:Here is the actual error message thrown by the sqlThread: table inbox has 13 columns but 14 values were supplied
2018-06-11 12:35:00,677 - CRITICAL - This program shall now abruptly exit!
...copying shared history...
...saving history...truncating history files...
Deleting expired sessions...none found.
Before following any of these steps, make sure that Hotshot is not running in any state on the computer in either Task Manager (Windows) or Activity Monitor (Mac)
If on a Mac, go to ~/Library/Application Support/Hotshot and delete “messages.dat”, on Windows you can find the Hotshot directory at %SystemDrive%:\Users\%UserName%\AppData\Roaming\Hotshot
Keep in mind, there are 2 .dat files: keys.dat, and messages.dat.
Delete the messages.dat located in the Hotshot directory. This will force Hotshot to recreate the local messaging database and re-sync all message history.
keys.dat should never be removed as deleting the Hotshot keys will make all users associated with the client unrecoverable.
Attempt to open Hotshot.
If the app still isn’t working, please contact us here. Please make sure to include your terminal log in your email.