Categorisation Helper error (stuck on Loading...)

[BusterCo]

• [x] I am on the latest ActivityWatch version.
• [x] I have searched the issues of this repo and believe that this is not a duplicate.

• Windows 11:
• ** v0.12.2**:

Describe the bug

The Categorisation helper is not loading common words in uncategorised events, meaning that it can not be used. It keeps displaying "Loading..." where on my other computer it displays frequently used categories. I have tried reinstalling AW, but this did not fix the issue. I have roughly a days worth of data collected.

To Reproduce

Go from the dashboard page to category Builder via the displayed banner. Do not find any common words but just the text "Loading..."

Expected behavior

I expect to see common visited sites/words which i can categorise.

Documentation

Most recent (server) log: 2024-04-11 17:03:38 [INFO ]: Using storage method: peewee (aw_server.main:33) 2024-04-11 17:03:38 [INFO ]: Starting up... (aw_server.main:41) 2024-04-11 17:03:38 [INFO ]: Using database file: C:\Users\spamm\AppData\Local\activitywatch\activitywatch\aw-server\peewee-sqlite.v2.db (aw_datastore.storages.peewee:126) 2024-04-11 17:03:38 [INFO ]: * Running on http://localhost:5600 (Press CTRL+C to quit) (werkzeug:224) 2024-04-11 17:03:42 [WARNING]: Gap was of negative duration and could NOT be safely merged (-0.558s). This warning will only show once per batch. (aw_transform.flood:54) 2024-04-11 17:03:42 [WARNING]: Gap was of negative duration but could be safely merged (-1.467s). This message will only show once per batch. (aw_transform.flood:46) 2024-04-11 17:03:42 [WARNING]: Gap was of negative duration but could be safely merged (-682.333s). This message will only show once per batch. (aw_transform.flood:46) 2024-04-11 17:03:42 [WARNING]: Gap was of negative duration and could NOT be safely merged (-485.596s). This warning will only show once per batch. (aw_transform.flood:54) 2024-04-11 17:03:42 [WARNING]: Gap was of negative duration but could be safely merged (-0.651s). This message will only show once per batch. (aw_transform.flood:46) 2024-04-11 17:03:42 [WARNING]: Gap was of negative duration and could NOT be safely merged (-24.505s). This warning will only show once per batch. (aw_transform.flood:54) 2024-04-11 17:03:42 [WARNING]: Gap was of negative duration but could be safely merged (-682.333s). This message will only show once per batch. (aw_transform.flood:46) 2024-04-11 17:03:42 [WARNING]: Gap was of negative duration and could NOT be safely merged (-485.596s). This warning will only show once per batch. (aw_transform.flood:54) 2024-04-11 17:03:42 [WARNING]: Gap was of negative duration and could NOT be safely merged (-0.558s). This warning will only show once per batch. (aw_transform.flood:54) 2024-04-11 17:03:42 [WARNING]: Gap was of negative duration but could be safely merged (-1.467s). This message will only show once per batch. (aw_transform.flood:46) 2024-04-11 17:03:42 [WARNING]: Gap was of negative duration but could be safely merged (-682.333s). This message will only show once per batch. (aw_transform.flood:46) 2024-04-11 17:03:42 [WARNING]: Gap was of negative duration but could be safely merged (-0.651s). This message will only show once per batch. (aw_transform.flood:46) 2024-04-11 17:03:42 [WARNING]: Gap was of negative duration but could be safely merged (-1236.523s). This message will only show once per batch. (aw_transform.flood:46) 2024-04-11 17:03:43 [WARNING]: Gap was of negative duration but could be safely merged (-2571.835s). This message will only show once per batch. (aw_transform.flood:46) 2024-04-11 17:03:43 [WARNING]: Gap was of negative duration but could be safely merged (-1030.028s). This message will only show once per batch. (aw_transform.flood:46) 2024-04-11 17:03:43 [WARNING]: Gap was of negative duration but could be safely merged (-228.56s). This message will only show once per batch. (aw_transform.flood:46) 2024-04-11 17:03:43 [WARNING]: Gap was of negative duration and could NOT be safely merged (-485.596s). This warning will only show once per batch. (aw_transform.flood:54) 2024-04-11 17:03:43 [WARNING]: Gap was of negative duration but could be safely merged (-28.101s). This message will only show once per batch. (aw_transform.flood:46) 2024-04-11 17:03:43 [WARNING]: Gap was of negative duration and could NOT be safely merged (-24.505s). This warning will only show once per batch. (aw_transform.flood:54) 2024-04-11 17:03:43 [WARNING]: Gap was of negative duration but could be safely merged (-5.054s). This message will only show once per batch. (aw_transform.flood:46) 2024-04-11 17:03:48 [INFO ]: 400 (127.0.0.1): [31m[1mPOST /api/0/query/ HTTP/1.1[0m (flask:25) 2024-04-11 17:06:06 [WARNING]: Gap was of negative duration and could NOT be safely merged (-0.558s). This warning will only show once per batch. (aw_transform.flood:54) 2024-04-11 17:06:06 [WARNING]: Gap was of negative duration but could be safely merged (-1.467s). This message will only show once per batch. (aw_transform.flood:46) 2024-04-11 17:06:06 [WARNING]: Gap was of negative duration but could be safely merged (-682.333s). This message will only show once per batch. (aw_transform.flood:46) 2024-04-11 17:06:06 [WARNING]: Gap was of negative duration and could NOT be safely merged (-485.596s). This warning will only show once per batch. (aw_transform.flood:54) 2024-04-11 17:06:06 [WARNING]: Gap was of negative duration but could be safely merged (-0.651s). This message will only show once per batch. (aw_transform.flood:46) 2024-04-11 17:06:06 [WARNING]: Gap was of negative duration and could NOT be safely merged (-24.505s). This warning will only show once per batch. (aw_transform.flood:54) 2024-04-11 17:06:06 [WARNING]: Gap was of negative duration but could be safely merged (-682.333s). This message will only show once per batch. (aw_transform.flood:46) 2024-04-11 17:06:06 [WARNING]: Gap was of negative duration and could NOT be safely merged (-485.596s). This warning will only show once per batch. (aw_transform.flood:54) 2024-04-11 17:06:06 [WARNING]: Gap was of negative duration and could NOT be safely merged (-0.558s). This warning will only show once per batch. (aw_transform.flood:54) 2024-04-11 17:06:06 [WARNING]: Gap was of negative duration but could be safely merged (-1.467s). This message will only show once per batch. (aw_transform.flood:46) 2024-04-11 17:06:06 [WARNING]: Gap was of negative duration but could be safely merged (-682.333s). This message will only show once per batch. (aw_transform.flood:46) 2024-04-11 17:06:06 [WARNING]: Gap was of negative duration but could be safely merged (-0.651s). This message will only show once per batch. (aw_transform.flood:46) 2024-04-11 17:06:06 [WARNING]: Gap was of negative duration but could be safely merged (-1236.523s). This message will only show once per batch. (aw_transform.flood:46) 2024-04-11 17:06:06 [WARNING]: Gap was of negative duration but could be safely merged (-2571.835s). This message will only show once per batch. (aw_transform.flood:46) 2024-04-11 17:06:06 [WARNING]: Gap was of negative duration but could be safely merged (-1030.028s). This message will only show once per batch. (aw_transform.flood:46) 2024-04-11 17:06:06 [WARNING]: Gap was of negative duration but could be safely merged (-228.56s). This message will only show once per batch. (aw_transform.flood:46) 2024-04-11 17:06:06 [WARNING]: Gap was of negative duration and could NOT be safely merged (-485.596s). This warning will only show once per batch. (aw_transform.flood:54) 2024-04-11 17:06:06 [WARNING]: Gap was of negative duration but could be safely merged (-28.101s). This message will only show once per batch. (aw_transform.flood:46) 2024-04-11 17:06:06 [WARNING]: Gap was of negative duration and could NOT be safely merged (-24.505s). This warning will only show once per batch. (aw_transform.flood:54) 2024-04-11 17:06:06 [WARNING]: Gap was of negative duration but could be safely merged (-5.054s). This message will only show once per batch. (aw_transform.flood:46) 2024-04-11 17:06:10 [INFO ]: 400 (127.0.0.1): [31m[1mPOST /api/0/query/ HTTP/1.1[0m (flask:25) 2024-04-11 17:06:15 [WARNING]: Gap was of negative duration and could NOT be safely merged (-0.558s). This warning will only show once per batch. (aw_transform.flood:54) 2024-04-11 17:06:15 [WARNING]: Gap was of negative duration but could be safely merged (-1.467s). This message will only show once per batch. (aw_transform.flood:46) 2024-04-11 17:06:15 [WARNING]: Gap was of negative duration but could be safely merged (-682.333s). This message will only show once per batch. (aw_transform.flood:46) 2024-04-11 17:06:15 [WARNING]: Gap was of negative duration and could NOT be safely merged (-485.596s). This warning will only show once per batch. (aw_transform.flood:54) 2024-04-11 17:06:16 [WARNING]: Gap was of negative duration but could be safely merged (-0.651s). This message will only show once per batch. (aw_transform.flood:46) 2024-04-11 17:06:16 [WARNING]: Gap was of negative duration and could NOT be safely merged (-24.505s). This warning will only show once per batch. (aw_transform.flood:54) 2024-04-11 17:06:16 [WARNING]: Gap was of negative duration but could be safely merged (-682.333s). This message will only show once per batch. (aw_transform.flood:46) 2024-04-11 17:06:16 [WARNING]: Gap was of negative duration and could NOT be safely merged (-485.596s). This warning will only show once per batch. (aw_transform.flood:54) 2024-04-11 17:06:16 [WARNING]: Gap was of negative duration and could NOT be safely merged (-0.558s). This warning will only show once per batch. (aw_transform.flood:54) 2024-04-11 17:06:16 [WARNING]: Gap was of negative duration but could be safely merged (-1.467s). This message will only show once per batch. (aw_transform.flood:46) 2024-04-11 17:06:16 [WARNING]: Gap was of negative duration but could be safely merged (-682.333s). This message will only show once per batch. (aw_transform.flood:46) 2024-04-11 17:06:16 [WARNING]: Gap was of negative duration but could be safely merged (-0.651s). This message will only show once per batch. (aw_transform.flood:46) 2024-04-11 17:06:16 [WARNING]: Gap was of negative duration but could be safely merged (-1236.523s). This message will only show once per batch. (aw_transform.flood:46) 2024-04-11 17:06:16 [WARNING]: Gap was of negative duration but could be safely merged (-2571.835s). This message will only show once per batch. (aw_transform.flood:46) 2024-04-11 17:06:16 [WARNING]: Gap was of negative duration but could be safely merged (-1030.028s). This message will only show once per batch. (aw_transform.flood:46) 2024-04-11 17:06:16 [WARNING]: Gap was of negative duration but could be safely merged (-228.56s). This message will only show once per batch. (aw_transform.flood:46) 2024-04-11 17:06:16 [WARNING]: Gap was of negative duration and could NOT be safely merged (-485.596s). This warning will only show once per batch. (aw_transform.flood:54) 2024-04-11 17:06:16 [WARNING]: Gap was of negative duration but could be safely merged (-28.101s). This message will only show once per batch. (aw_transform.flood:46) 2024-04-11 17:06:16 [WARNING]: Gap was of negative duration and could NOT be safely merged (-24.505s). This warning will only show once per batch. (aw_transform.flood:54) 2024-04-11 17:06:16 [WARNING]: Gap was of negative duration but could be safely merged (-5.054s). This message will only show once per batch. (aw_transform.flood:46) 2024-04-11 17:08:53 [WARNING]: Gap was of negative duration and could NOT be safely merged (-0.558s). This warning will only show once per batch. (aw_transform.flood:54) 2024-04-11 17:08:53 [WARNING]: Gap was of negative duration but could be safely merged (-1.467s). This message will only show once per batch. (aw_transform.flood:46) 2024-04-11 17:08:53 [WARNING]: Gap was of negative duration but could be safely merged (-682.333s). This message will only show once per batch. (aw_transform.flood:46) 2024-04-11 17:08:53 [WARNING]: Gap was of negative duration and could NOT be safely merged (-485.596s). This warning will only show once per batch. (aw_transform.flood:54) 2024-04-11 17:08:53 [WARNING]: Gap was of negative duration but could be safely merged (-0.651s). This message will only show once per batch. (aw_transform.flood:46) 2024-04-11 17:08:53 [WARNING]: Gap was of negative duration and could NOT be safely merged (-24.505s). This warning will only show once per batch. (aw_transform.flood:54) 2024-04-11 17:08:53 [WARNING]: Gap was of negative duration but could be safely merged (-682.333s). This message will only show once per batch. (aw_transform.flood:46) 2024-04-11 17:08:53 [WARNING]: Gap was of negative duration and could NOT be safely merged (-485.596s). This warning will only show once per batch. (aw_transform.flood:54) 2024-04-11 17:08:53 [WARNING]: Gap was of negative duration and could NOT be safely merged (-0.558s). This warning will only show once per batch. (aw_transform.flood:54) 2024-04-11 17:08:53 [WARNING]: Gap was of negative duration but could be safely merged (-1.467s). This message will only show once per batch. (aw_transform.flood:46) 2024-04-11 17:08:53 [WARNING]: Gap was of negative duration but could be safely merged (-682.333s). This message will only show once per batch. (aw_transform.flood:46) 2024-04-11 17:08:53 [WARNING]: Gap was of negative duration but could be safely merged (-0.651s). This message will only show once per batch. (aw_transform.flood:46) 2024-04-11 17:08:53 [WARNING]: Gap was of negative duration but could be safely merged (-1236.523s). This message will only show once per batch. (aw_transform.flood:46) 2024-04-11 17:08:53 [WARNING]: Gap was of negative duration but could be safely merged (-2571.835s). This message will only show once per batch. (aw_transform.flood:46) 2024-04-11 17:08:53 [WARNING]: Gap was of negative duration but could be safely merged (-1030.028s). This message will only show once per batch. (aw_transform.flood:46) 2024-04-11 17:08:53 [WARNING]: Gap was of negative duration but could be safely merged (-228.56s). This message will only show once per batch. (aw_transform.flood:46) 2024-04-11 17:08:53 [WARNING]: Gap was of negative duration and could NOT be safely merged (-485.596s). This warning will only show once per batch. (aw_transform.flood:54) 2024-04-11 17:08:53 [WARNING]: Gap was of negative duration but could be safely merged (-28.101s). This message will only show once per batch. (aw_transform.flood:46) 2024-04-11 17:08:53 [WARNING]: Gap was of negative duration and could NOT be safely merged (-24.505s). This warning will only show once per batch. (aw_transform.flood:54) 2024-04-11 17:08:53 [WARNING]: Gap was of negative duration but could be safely merged (-5.054s). This message will only show once per batch. (aw_transform.flood:46) 2024-04-11 17:08:54 [INFO ]: 400 (127.0.0.1): [31m[1mPOST /api/0/query/ HTTP/1.1[0m (flask:25) 2024-04-11 17:09:22 [INFO ]: Received heartbeat after pulse window, inserting as new event. (bucket: aw-watcher-window_BeastPC) (aw_server.api:279) 2024-04-11 17:12:35 [WARNING]: Gap was of negative duration and could NOT be safely merged (-0.558s). This warning will only show once per batch. (aw_transform.flood:54) 2024-04-11 17:12:35 [WARNING]: Gap was of negative duration but could be safely merged (-1.467s). This message will only show once per batch. (aw_transform.flood:46) 2024-04-11 17:12:35 [WARNING]: Gap was of negative duration but could be safely merged (-682.333s). This message will only show once per batch. (aw_transform.flood:46) 2024-04-11 17:12:35 [WARNING]: Gap was of negative duration and could NOT be safely merged (-485.596s). This warning will only show once per batch. (aw_transform.flood:54) 2024-04-11 17:12:35 [WARNING]: Gap was of negative duration but could be safely merged (-0.651s). This message will only show once per batch. (aw_transform.flood:46) 2024-04-11 17:12:35 [WARNING]: Gap was of negative duration and could NOT be safely merged (-24.505s). This warning will only show once per batch. (aw_transform.flood:54) 2024-04-11 17:12:35 [WARNING]: Gap was of negative duration but could be safely merged (-682.333s). This message will only show once per batch. (aw_transform.flood:46) 2024-04-11 17:12:35 [WARNING]: Gap was of negative duration and could NOT be safely merged (-485.596s). This warning will only show once per batch. (aw_transform.flood:54) 2024-04-11 17:12:36 [WARNING]: Gap was of negative duration and could NOT be safely merged (-0.558s). This warning will only show once per batch. (aw_transform.flood:54) 2024-04-11 17:12:36 [WARNING]: Gap was of negative duration but could be safely merged (-1.467s). This message will only show once per batch. (aw_transform.flood:46) 2024-04-11 17:12:36 [WARNING]: Gap was of negative duration but could be safely merged (-682.333s). This message will only show once per batch. (aw_transform.flood:46) 2024-04-11 17:12:36 [WARNING]: Gap was of negative duration but could be safely merged (-0.651s). This message will only show once per batch. (aw_transform.flood:46) 2024-04-11 17:12:36 [WARNING]: Gap was of negative duration but could be safely merged (-1236.523s). This message will only show once per batch. (aw_transform.flood:46) 2024-04-11 17:12:36 [WARNING]: Gap was of negative duration but could be safely merged (-2571.835s). This message will only show once per batch. (aw_transform.flood:46) 2024-04-11 17:12:36 [WARNING]: Gap was of negative duration but could be safely merged (-1030.028s). This message will only show once per batch. (aw_transform.flood:46) 2024-04-11 17:12:36 [WARNING]: Gap was of negative duration but could be safely merged (-228.56s). This message will only show once per batch. (aw_transform.flood:46) 2024-04-11 17:12:36 [WARNING]: Gap was of negative duration and could NOT be safely merged (-485.596s). This warning will only show once per batch. (aw_transform.flood:54) 2024-04-11 17:12:36 [WARNING]: Gap was of negative duration but could be safely merged (-28.101s). This message will only show once per batch. (aw_transform.flood:46) 2024-04-11 17:12:36 [WARNING]: Gap was of negative duration and could NOT be safely merged (-24.505s). This warning will only show once per batch. (aw_transform.flood:54) 2024-04-11 17:12:36 [WARNING]: Gap was of negative duration but could be safely merged (-5.054s). This message will only show once per batch. (aw_transform.flood:46)

Additional context

[github-actions[bot]]

Hi there! As you're new to this repo, please make sure you've used an appropriate issue template and searched for duplicates (it helps us focus on actual development!). We'd also like to suggest that you read our contribution guidelines and our code of conduct. Thanks a bunch for opening your first issue! 🙏

[BelKed]

Could you please install v0.12.3b15, and try to replicate the bug there? I believe it was fixed a while ago (https://github.com/ActivityWatch/activitywatch/issues/965) :)

[BusterCo]

Thanks for the quick reply. This version indeed fixes the abovementioned issue. Interesting however is that the popup/bar one the dashboard page that redirects you to the Categorization helper is not present in this version, and instead you must go to the page via the menu. Might be something to add back, as it is quite helpfull for new users?

Thanks again for the quick help!