Database disk image is malformed

friedsoap

Hi,

I checked the database integrity through zotero. It said there were some errors. I "repaired" manually the database as explained in https://zotero.org/utils/dbfix/manual. I then checked manually for the integrity of the database, the output was:
sqlite> PRAGMA integrity_check;
* in database main *
On tree page 59552 cell 42: Rowid 1322008 out of order (previous was 1584151)
Multiple uses for byte 642 of page 59552
Multiple uses for byte 296 of page 63399
On tree page 275767 cell 25: Rowid 6089409 out of order (previous was 31255232)
On tree page 275767 cell 28: Rowid 18672324 out of order (previous was 31255235)
On tree page 275767 cell 29: Rowid 6089413 out of order (previous was 18672324)
Multiple uses for byte 565 of page 275767
Corruption detected in cell 23 on page 295121
Corruption detected in cell 28 on page 295121
Multiple uses for byte 952 of page 295121
Fragmentation of 32 bytes reported as 0 on page 295121
On tree page 317002 cell 18: Rowid 566800 out of order (previous was 566815)
On tree page 11906 cell 21: Failed to read ptrmap key=1634299493
On tree page 11906 cell 21: invalid page number 1634299493
Corruption detected in cell 3 on page 11906
Multiple uses for byte 472 of page 11906
Fragmentation of 30 bytes reported as 0 on page 11906
Error: database disk image is malformed

Instead of trying to repair the database (I am not db expert), is there a method to build the db from scratch again? Would the zotero option "restore from zotero server" do the job? (I was trying to avoid that as I have about 5400 entries adding 14Gb of data)

Thank a lot,

Aleix

dstillman

The manual steps rebuild the DB from scratch. If you're still getting errors after that, you likely missed a step or are checking the wrong file.

Restore from Zotero Server likely wouldn't be a problem with 5,400 items, though. It doesn't touch stored files, so the 14GB doesn't matter.

gabrielmckee

My solution to this problem was to uninstall and reinstall the plugin. My entire database was restored from the server. (If I had my attachments saved locally and not on the server, this would not have worked so well...)