Corrupted database recover problem
Hello,
My Zotero database is marked as corrupted. I have followed the recovery instructions https://www.zotero.org/utils/dbfix/manual. The first step results in an error, i.e,: Typing
sqlite3 zotero.sqlite .recover > temp.sql
Returns an error message
sql error: no such table: sqlite_dbpage (1)
and the temp.sql file contains only:
```
BEGIN;
PRAGMA writable_schema = on;
PRAGMA encoding = 'UTF-8';
PRAGMA page_size = '32768';
PRAGMA auto_vacuum = '1';
PRAGMA user_version = '0';
PRAGMA application_id = '0';
```
I use sqlite version 3.45.1 and zotero version 7.0.10-beta.1+913c50073.
I will be grateful to hear any advice.
Thank you
Pawel
My Zotero database is marked as corrupted. I have followed the recovery instructions https://www.zotero.org/utils/dbfix/manual. The first step results in an error, i.e,: Typing
sqlite3 zotero.sqlite .recover > temp.sql
Returns an error message
sql error: no such table: sqlite_dbpage (1)
and the temp.sql file contains only:
```
BEGIN;
PRAGMA writable_schema = on;
PRAGMA encoding = 'UTF-8';
PRAGMA page_size = '32768';
PRAGMA auto_vacuum = '1';
PRAGMA user_version = '0';
PRAGMA application_id = '0';
```
I use sqlite version 3.45.1 and zotero version 7.0.10-beta.1+913c50073.
I will be grateful to hear any advice.
Thank you
Pawel
-
dstillmanIf your online library is up to date, you should just delete zotero.sqlite and let it sync to pull down your data.
-
pawelwojcikProblem solved. Thanks