Upgrade StorageError message when opening Zotero
Hello,
The following error comes up when I try to open Zotero as the desktop app. I tried restarting my computer, but the error message is still there. I also tried checking for updates, but it says there are no updates available. I have a Dell laptop with Microsoft Windows 11 Home.
"There was an error starting Zotero.
You can report this problem in the Zotero Forums.
Error(s) encountered during statement execution: no such column: L.clientVersion [QUERY: SELECT L.libraryID, L.type AS _libraryType, L.editable AS _libraryEditable, L.filesEditable AS _libraryFilesEditable, L.version AS _libraryVersion, L.clientVersion AS _libraryClientVersion, L.storageVersion AS _libraryStorageVersion, L.lastSync AS _libraryLastSync, L.archived AS _libraryArchived, L.isAdmin AS _libraryIsAdmin, (SELECT COUNT(*)>0 FROM collections C WHERE C.libraryID=L.libraryID) AS hasCollections, (SELECT COUNT(*)>0 FROM savedSearches S WHERE S.libraryID=L.libraryID) AS hasSearches FROM libraries L WHERE type NOT IN (?,?)] [PARAMS: "feed", "group"] [ERROR: no such column: L.clientVersion]
Zotero.DBConnection.prototype.queryAsync@chrome://zotero/content/xpcom/db.js:715:22"
Any ideas? Thanks!
Erin
The following error comes up when I try to open Zotero as the desktop app. I tried restarting my computer, but the error message is still there. I also tried checking for updates, but it says there are no updates available. I have a Dell laptop with Microsoft Windows 11 Home.
"There was an error starting Zotero.
You can report this problem in the Zotero Forums.
Error(s) encountered during statement execution: no such column: L.clientVersion [QUERY: SELECT L.libraryID, L.type AS _libraryType, L.editable AS _libraryEditable, L.filesEditable AS _libraryFilesEditable, L.version AS _libraryVersion, L.clientVersion AS _libraryClientVersion, L.storageVersion AS _libraryStorageVersion, L.lastSync AS _libraryLastSync, L.archived AS _libraryArchived, L.isAdmin AS _libraryIsAdmin, (SELECT COUNT(*)>0 FROM collections C WHERE C.libraryID=L.libraryID) AS hasCollections, (SELECT COUNT(*)>0 FROM savedSearches S WHERE S.libraryID=L.libraryID) AS hasSearches FROM libraries L WHERE type NOT IN (?,?)] [PARAMS: "feed", "group"] [ERROR: no such column: L.clientVersion]
Zotero.DBConnection.prototype.queryAsync@chrome://zotero/content/xpcom/db.js:715:22"
Any ideas? Thanks!
Erin
Can you go to your Zotero data directory and email a screenshot of the files in the data directory, along with logs/upgrade.log, to support@zotero.org with a link to this thread?
Is your data directory in the default location ("Zotero" in your home folder)?
- I'm not totally sure which Zotero version I have since I can't access the Help menu as it says to do in the link provided. But I'm guessing Zotero 5.0 since that version history comes up when I click on the 'changelog' link. Also if I right click on the Zotero icon in my taskbar, it says Zotero (5).
- I've emailed two screenshots to the support email.
- I believe the data directory is in the default location (C:/Users/JSGS Research/Zotero, where JSGS Research is the User Name).
It looks like your Zotero 9 → 10 update didn't install cleanly — you somehow ended up with some files from Zotero 9 and some from Zotero 10, which certainly should never happen. We're looking into how that could've been possible. Is there anything unusual about this system? Is this a personal computer? Any third-party security software or other non-standard configuration?
But to fix now, you have two options:
1) Run a command against the database to let it perform the necessary upgrade, which would require downloading DB Browser for SQLite or sqlite3.exe.
2) Close Zotero, move all the zotero.sqlite (and .wal/.shm) files to a temporary folder on your desktop, restart Zotero, and let it pull down your data from the online library via sync.
If you think you have everything online, the second is much easier. You can keep the zotero.sqlite files until you've confirmed that all your data is available.
My computer is owned by my University, so that might have had an impact? I can ask the IT staff if there is third-party security software, if that is helpful.
I will try the second option since it looks like everything is online. Just to clarify, should I just save the files indicated in red (see attached screenshot) on my desktop? I don't need to keep the other folders in the screenshot?
https://s3.amazonaws.com/zotero.org/images/forums/u8493531/vibd9d1al6eukx2befbq.png
Thanks!