problem after update

Seonju
After Zotero update yesterday, I keep getting warning says: "The Zotero Data base "Zotero.sqlite" appears to have become corrupted." and it saved the file as "zotero.sqlite-1.damaged"
when I click ok, an error message appears, showing the option "restore from automatic backup". When I click that option, program ends and then starts again with the same warning.

I use mac and I did not change any setting, just did the zotero update yesterday. Anybody has the same problem?
I have a deadline coming and I cannot lose the reference lists now...
  • dstillman
    edited June 18, 2020
    Your database was already corrupted — the latest version is just better at detecting and notifying you of database corruption (hopefully before you become at risk of losing more data).

    It sounds like your automatic backup is corrupted as well. See Corrupted Database (which is linked from that dialog) for steps you can take to repair or restore your database.
  • Seonju
    thank you dstillman for answering my question. I don't see any reason why my database is suddenly corrupted but I read your link and followed the suggestion- since I don't have my database on cloud, I tried using Zotero Database Repair Tool. I copied the new sqlite file into data directory and restart zotero, and now it saids "Error: there was an error starting zotero"

    Error: Error(s) encountered during statement execution: table retractedItems already exists [QUERY: CREATE TABLE retractedItems ( itemID INTEGER PRIMARY KEY, data TEXT, flag INT DEFAULT 0, FOREIGN KEY (itemID) REFERENCES items(itemID) ON DELETE CASCADE)] [PARAMS: ] [ERROR: table retractedItems already exists]
    Zotero.DBConnection.prototype.queryAsync<@chrome://zotero/content/xpcom/db.js:666:13
    From previous event:
    _initializeSchema/</<@chrome://zotero/content/xpcom/schema.js:2017:16


    I tried to import sqlite into mendeley, just to see if loads, it loads normal on mendeley...

    I don't know how to fix it...
  • dstillman
    Again, it's not suddenly corrupted — it was corrupted before (perhaps from previously being in a cloud storage folder or some other reason) and it's just detecting that better now.

    Can you provide an Upload ID from the repair tool?
  • Seonju
    thanks.
    it's 5eeb4638e8db8
  • dstillman
    Sorry, try the Database Repair Tool again now. Be sure to use the original file you uploaded, not the one that was already processed.
  • Seonju
    Thank you. it worked and everything is there:)
Sign In or Register to comment.