Manual Repair tool cannot fix a problem in my Zotero database
Dear, all I have a zotero database with around 8 thousand papers. I was experiencing some problems when using it (it was asking me to use the last backup automatically done by Zotero). And I lost everything I have edited (added new pdf, editing title names, etc)
So, I decided to check the integrity of my DB and it suggested me to repair it (see picture below ). So, I copied my zotero DB (zotero.sqlite) to another folder (called apagou) and tried manually repair my DB, using the windows command tool, as described in https://www.zotero.org/utils/dbfix/manual. Note my DB is larger than 150 MB. So, I had to do the manual process.
I tried this not only with my current zotero.sqlite, but also with some older backups (6 months older), without success, as you can see below. Probably the problem was already there, but was all normal for me (I could edit, add files,and there was no automatic use of backups as now)
For your information:
All my data, including the Zotero DB is saved in an external HD-SSD that I carry everywhere. Several times a day, all my files (including Zotero DB) are syncronized with the PC I am working on (home or work). I do not use cloud storage, because I do not have access to internet large part of the time. So I carry only the external HD-SSD from home to work and vice-versa.
This approach has worked for me for many years, without any problem. But now I cannot repair a problem in my DB. See details of the problem below.
Could anybody help me, please?
https://s3.amazonaws.com/zotero.org/images/forums/u1902886/jpz1hexesswxqp4dfuzo.jpg
https://s3.amazonaws.com/zotero.org/images/forums/u1902886/pulxg21miq98zcql16rs.jpg
So, I decided to check the integrity of my DB and it suggested me to repair it (see picture below ). So, I copied my zotero DB (zotero.sqlite) to another folder (called apagou) and tried manually repair my DB, using the windows command tool, as described in https://www.zotero.org/utils/dbfix/manual. Note my DB is larger than 150 MB. So, I had to do the manual process.
I tried this not only with my current zotero.sqlite, but also with some older backups (6 months older), without success, as you can see below. Probably the problem was already there, but was all normal for me (I could edit, add files,and there was no automatic use of backups as now)
For your information:
All my data, including the Zotero DB is saved in an external HD-SSD that I carry everywhere. Several times a day, all my files (including Zotero DB) are syncronized with the PC I am working on (home or work). I do not use cloud storage, because I do not have access to internet large part of the time. So I carry only the external HD-SSD from home to work and vice-versa.
This approach has worked for me for many years, without any problem. But now I cannot repair a problem in my DB. See details of the problem below.
Could anybody help me, please?
https://s3.amazonaws.com/zotero.org/images/forums/u1902886/jpz1hexesswxqp4dfuzo.jpg
https://s3.amazonaws.com/zotero.org/images/forums/u1902886/pulxg21miq98zcql16rs.jpg
-
dstillmanYour best bet would be to find the most recent version that you can still open, sync, and then delete the local database and let it repopulate it from the online version.
-
dstillmanwhat a cloud storage folder would do.I'm not totally sure what you mean by this, but if you're saying Zotero is pointing to the local disk and an external process is copying files from the external disk, potentially while Zotero is open, that would certainly be an easy way to corrupt your database. That's effectively