Database upgrade error

jrameshwar
I don't know why this occurred.
I usually run winget upgrade --all --source winget monthly with no issues
This time after it updated a few apps I tried to open Zotero and got this message
handleCompletion@resource://gre/modules/Sqlite.sys.mjs:1093:25
I checked for update and it stated no updates available and when I clicked Ok it just closed

Not sure what to do

Any advice is greatly appreciated
  • dstillman Zotero Team
    Can you provide a Debug ID for a Zotero startup that shows this? See Reporting Startup Errors. See the section at the bottom about logging to a terminal window if that doesn’t work.
  • dstillman Zotero Team
    edited 16 days ago
    But did you resolve the previous issue you were having? Have you checked your database for errors? If you haven't resolved that, please continue posting to that thread (or following up with the BBT developer).

    We can only help if this happens in Troubleshooting Mode (-safe-mode on the command line, as on the linked page).
  • jrameshwar
    Hi dstillman

    Thanks so much for the suggestions.

    Ended up having to use the -jsconsole as the error message prevented access to the help menu and clicking submit in the debug window.

    Messages from jsconsole are:
    1788647540965 addons.xpi WARN Force scan SCOPE_ALL locations on empty XPIStates locations data
    Missing resource in locale en-AU: branding/brand.ftl
    Missing resource in locale en-CA: branding/brand.ftl
    Missing resource in locale en-NZ: branding/brand.ftl
    Missing resource in locale en-AU: branding/brand.ftl
    Missing resource in locale en-CA: branding/brand.ftl
    Missing resource in locale en-NZ: branding/brand.ftl
    Missing resource in locale en-AU: devtools/client/toolbox.ftl
    Missing resource in locale en-CA: devtools/client/toolbox.ftl
    Missing resource in locale en-NZ: devtools/client/toolbox.ftl
    SQLite JSM (Connection zotero.sqlite#0): Error: Error(s) encountered during statement execution: database disk image is malformed
    handleCompletion resource://gre/modules/Sqlite.sys.mjs:1093
    Sqlite.sys.mjs:915:20
    Error(s) encountered during statement execution: database disk image is malformed 2 Sqlite.sys.mjs
    Missing resource in locale en-GB: toolkit/global/commonDialog.ftl

    Not sure if screenshots from the debug window are useful but took them anyway and attached
    https://s3.amazonaws.com/zotero.org/images/forums/u13962295/bz0pioi7w0b37j5aziy5.png
    https://s3.amazonaws.com/zotero.org/images/forums/u13962295/s8a1ud63wh4qajdqc289.png
    https://s3.amazonaws.com/zotero.org/images/forums/u13962295/2km7ofo881o79thzppft.png
    https://s3.amazonaws.com/zotero.org/images/forums/u13962295/69cjplrjr2x9vx3vwf0w.png

    Regarding the other issue with BBT, I have not gotten a chance as this new issue is preventing me from accessing anything

    If I left anything out please let me know.
  • dstillman Zotero Team
    That’s still a corrupted database.

    https://www.zotero.org/support/kb/corrupted_database
  • jrameshwar
    I am going through the various steps and not sure if I found the issue but this is what I have:

    I have 2 sets of zotero.sqlite
    One is in C:\Users\usrname\Zotero (this only has folders locate, styles, translators and the zotero.sqlite)
    One is in my data folder in a separate Zotero folder where I have my documents (this has many different sqlite files as shown

    https://s3.amazonaws.com/zotero.org/images/forums/u13962295/q73gmiy482q3kkr064ij.png

    :Plus there are others that are zotero(PC name conflicted copy Date).sqlite; .sqlite-journal; etc

    I can give a redacted image if you need

    How do I correct my problem?
  • dstillman Zotero Team
    If you have a conflicted copy, this is (or has been) a cloud storage folder. You can’t do that, and I’m afraid you’re on your own.

    https://www.zotero.org/support/kb/data_directory_in_cloud_storage_folder
  • jrameshwar
    I was hoping you would not abandon me.

    Based on the article I can see that is what happened and did not realise it.

    I had the file on one computer and had IDrive which was backing up the entire data folder and had access to that IDrive folder on another computer, not really thinking about Zotero, it was for my other files. Based on the different computer names I realise now that I did access Zotero on those machines. I don't recall any issues which is why it never crossed my mind.

    Really am in a bind here and any way forward would be a great help
  • jrameshwar
    Good news!

    I was lucky this time and used Gemini to guide me. Hopefully it was correct in the advice as Zotero is working. I took your point and using the Zotero sync to maintain the database and deselected the pdfs. I will add an exclusion to Idrive to not sync sqlite. All this based on Gemini, so hoping this will not create new issues.

    Still in the process of these steps.

    Thanks again for the help and suggestions.

    Tonight was a mini panic attack.
Sign In or Register to comment.