Database upgrade error

This discussion was created from comments split from: Database upgrade error.
  • Hey @kerrypettingrew, I got the same problem with my files and even deinstalling everything doesn't work. I am using a Mac. Do you know how I can fix the problem on here? I am not sure how DISM and SFC work and haven't done the before.
  • edited August 25, 2023
    Please start new threads for new issues — the thread you posted to was from someone on Windows, and it wouldn't have anything to do with your situation. I've moved this to a new thread.

    Can you step back and explain, in your own words, the exact problem you're experiencing? We'd also want a Report ID. If you're not able to provide one, see Reporting Startup Errors.
  • Thanks @dstillman, I will do this.

    So my problem is: I had Zotero on my pCloud, than Zotero told me to move it away from a Cloud and so I did. The file for Zotero is now stored on my computer locally. I now wanted to open the application an Zotero told me this:

    Error: Errors) encountered during statement execution: database disk image is malformed [QUERY: SELECT item TypelD FROM itemTypes WHERE typeName='attachment'] [PARAMS: ] [ERROR:
    database disk image is malformed]
    From brevious event:
    ZoteroService@rile:/Applications Contents
    achrome gotero content/ 4 4

    I already deinstalled everything and even deleted all files but I still can't even start the application. I have a backup on, so it would be no problem for me to delete everything and start again with the backup. Can somebody help me to start the app again?

    Thank you!
  • edited August 25, 2023
    Right, so you have a corrupted database — exactly why we say never to do this, and why the app made you move it.

    You can try closing Zotero and copying one of the zotero.sqlite.bak automatic backup files in the folder to zotero.sqlite. Zotero will use whatever file is named zotero.sqlite when it starts up. But it doesn't really matter — if your data is all online, you could also just delete zotero.sqlite and start up with an empty database. Using a recent backup will prevent Zotero from having to download all your data again, though.

    If you do use a backup, be sure to check the database integrity from the Advanced → Files and Folders pane of the Zotero preferences, since the backup might be corrupted as well. And if it is, you should just delete it and sync to pull down your data.
  • Thank you very much, @dstillman! I got everything back. Since I only started to work with Zotero last week there wasn't much to download from the backup. Thanks for your help.
Sign In or Register to comment.