Manual database repair error "no such table: sqlite_dbpage (1)"

maakujonson
I followed the directions on the webpage: https://www.zotero.org/utils/dbfix/manual
I'm using linux mint. I adjusted for the location of my zotero library.

When I run "sqlite3 zotero.sqlite .recover > dump.sql"
I get: "sql error: no such table: sqlite_dbpage (1)"

I know almost nothing about sql databases, so I have no clue what this means.
  • maakujonson
    I found this similar problem: https://forums.zotero.org/discussion/119556/corrupted-database-recover-problem

    I followed the directions therein and it seems to have mostly solved the problem. The database is no longer corrupt. However I am a little worried because of the size of my library. I have about 15,000 items stored and I'm not sure if the Zotero web sync data limit accommodates the entirety of my database. The sqlite file that was corrupt was about 2 GB in size, where the one downloaded from the web sync is only a few hundred MB.

    I'm trying to find discrepancies in the library, but with so many items it is a little difficult. My main concern is whether all of the entries properly link to the attachments stored in my Zotero library folder, as I'm using it for article storage.
  • dstillman
    Don't worry about the size. Various things can cause the size to be different from before, including database fragmentation and the full-text content index not yet being rebuilt in the background. All data you had online would be available locally.

    Attachments wouldn't have anything to do with the database size.

    (And I assume you realize this, but all your posts here going back to last December have been related to your corrupting your database by storing it on an SD card. I would strongly recommend not doing that.)
  • maakujonson
    That's good to know. It seems to be resolved then. As far as I can tell there are no discrepancies after checking a sample of the library. Thanks for your response.

    I have come to realize the problems with using an SD card. Unfortunately at the time I had no alternative. I have now moved everything to a local hard drive on a new device so it should help to avoid future problems.
Sign In or Register to comment.