Error(s) encountered during statement execution: disk I/O

Fanny Georges

Bonjour, / Hello,
j'ai un problème au démarrage de zotero:/I have a problem when starting zotero:


"
Erreur de mise à niveau de la base de données

Error: Error(s) encountered during statement execution: disk I/O error [QUERY: SELECT COUNT(*) > 0 FROM fulltextItemWords WHERE itemID NOT IN (SELECT itemID FROM items WHERE itemTypeID=14)] [PARAMS: ] [ERROR: disk I/O error]
Zotero.DBConnection.prototype.valueQueryAsync<@chrome://zotero/content/xpcom/db.js:714:13
From previous event:
Zotero.Schema</this.updateSchema/updated<@chrome://zotero/content/xpcom/schema.js:196:17

"

The program cannot be started: it displays this message and does not load the database.

I don't understand the source of the problem, could you help me please?

dstillman

Is your Zotero data directory in the default location, or have you moved it to an external drive, cloud storage folder, etc.?

This indicates a low-level problem with the disk, or potentially a conflict with some security software on the system, not a problem in Zotero itself.

Fanny Georges

Thank you for your reply!
I have a custom directory on another drive but I cannot locate the problem. It happened while I was copying text content to a note file. I don't have a new security tool installed, I don't understand the message ...

dstillman

It's the external drive, then. You should move your data directory back to your local disk. It has nothing to do with what you were doing in Zotero — this is just a question of the external drive not being treated by the system like a normal drive, causing Zotero not to be able to properly and safely access its database. Some external drives will work, but it depends on your exact computer setup.

Fanny Georges

Thank you for this advice

I just tried but "it fails to read the zotero.sqlite file on the source disk"! (error message) it is 350 MB

dstillman

Right, so this is just a general computing question that we can't help with here. Restarting your computer might allow you to move the file. Beyond that, I'm afraid you'll need to seek help elsewhere to move these files, since the problem has nothing whatsoever to do with Zotero.

Fanny Georges

Thank you
This is very bad because I am writing a document with about 1000 zotero references I think I will have to re-enter everything by hand! ^^ Science is hard work
Thanks a lot for your help

dstillman

You don't need to re-enter anything by hand.

You can try copying one of the .bak files in that directory, which are the automatic backups Zotero makes of the database. Zotero will read whatever file is named zotero.sqlite in the active data directory. It's extremely unlikely that you wouldn't be able to restore from one of those files.

Assuming you've been syncing, you can also just switch to an empty data directory in the default location (or with just the 'storage' folder copied so you have your attached files) and sync to pull down data from your online library.