ActivityWatch / ActivityWatch/aw-server
Malformed sqlite database
- Lingua principale
- Python
- Stelle
- 128
- Fork
- 94
- Merge medio
- 4g 18h
- PR unite (30g)
- 3
Descrizione
So it happened, I have on that data from the end of 2019 and I was sad to delete but it is possible to recover the data on it.
```
sqlite3 /home/[your-user]/.local/share/activitywatch/aw-server/peewee-sqlite.v2.db ".dump" > dump.sql
rm -f /home/[your-user]/.local/share/activitywatch/aw-server/peewee-sqlite.v2.db
sqlite3 -init dump.sql /home/[your-user]/.local/share/activitywatch/aw-server/peewee-sqlite.v2.db
.quit
```
With this commands I was able to recreate a database and now activity watch starts. In case of this issue you have aw-qt reporting an error, if you press restart server aw-qt crashes...
With the more details button you see the error on peewee about the malformed database, so you need to do those commands and restart aw-qt.
Guida per i contributori
Nessuna guida per i contributori indicizzata per questo repository
Valutazione
Questa issue non è ancora stata valutata.