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
CLARIFYING:
Your best bet would be...
I WILL TRY IT WITH LAST YEAR BACKUPS, BECAUSE THE OLDEST ONE FROM THIS YEAR (MAY2025) DID NOT WORK EITHER.
I'm not totally sure what you mean by this...
SORRY FOR THAT. I WAS JUST TRYING TO SAY THAT ALL MY FILES (Zotero database and all other files from my external disk) ARE SYNCRONIZED FROM MY EXTERNAL DRIVE (WHERE I ALWAYS WORK) TO THE PC I AM WORKING AT THAT MOMENT, SEVERAL TIMES A DAY (AS BACKUP). This was just to say, my zotero database is not stored either in the traditional C drive (internal) or in the cloud. Instead, it is stored in an external SSD. But this might be irrelevant.
ONE LAST QUESTION:
Do you think somebody with experience in SQL could open the zotero.sqlite and delete the problem around the line line 11945939 reported by the program sqlite3 OU my only alternative is using an old (<2024) backup)?
Thank you so much for your help.
Uilson