Corrupted database / Trouble with the DB Repair Tool
Beginning this afternoon, I received the following error message: "The Zotero database 'zotero.sqlite' appears to have become corrupted. Your data was restored from the last automatic backup made on 12/12/2013 at 12:03:54. The damaged file was saved in your Zotero directory."
The "Check Database Integrity" tool shows errors in the database, and directs me to the Database Repair Tool. However, my troubleshooting attempts stall here, as I am unable to upload the 'zotero.sqlite' file. I have tried uploading the original file and a zipped file, and for each I get an error saying that the file "does not appear to be an SQLite database." Neither of the files exceed the 100 MB upload limit.
I get the errors in Zotero Standalone and in Firefox alike. I use a Mac with OS X 10.7.5.
Thanks in advance for your help!
The "Check Database Integrity" tool shows errors in the database, and directs me to the Database Repair Tool. However, my troubleshooting attempts stall here, as I am unable to upload the 'zotero.sqlite' file. I have tried uploading the original file and a zipped file, and for each I get an error saying that the file "does not appear to be an SQLite database." Neither of the files exceed the 100 MB upload limit.
I get the errors in Zotero Standalone and in Firefox alike. I use a Mac with OS X 10.7.5.
Thanks in advance for your help!
BTW: I've also had trouble for the past few days with citations going to the version that sits in Firefox instead of the Standalone that has all my stuff in it. Is there any way to get rid of the one in the browser?
Thanks again.
I get an alert that zotero.squlite appears to have been corrupted and that my data was restored from the last automatic backup.
I click okay to that but then get an error, that the database is corrupted and that I should attempt an automatic restore from the last backup.
I click "restart now" and get the alert about zotero.squlite again, at which point I also get the spinning ball and have to "force quit" the program.
Thanks for anything you can offer on this!
I can't start Zotero standalone at all. The Firefox plugin opens and I could save a resource but then again the plugin crashed. So I need to repair the sqlite file.
I have troubles since a long time - Zotero crashed regularly as plugin, but then was working properly with the standalone version - until I've updated to Firefox 25.0.1.
Thanks for hints and help.
Zotero standalone starts with the repaired file. I hope everything will work now properly again.
Many thanks
Petra
If this is a laptop, can you try from a different network? Alternatively, if you're able to upload the file to something like Dropbox, you could ask a friend to try the upload from another computer.
How big is the file zipped? Is that 36MB, or is it smaller?
Please can you help me?
Thank you so much in advance!
How can I get it back?
I am in desperate need of help for my PhD thesis.
Thank you!
In it you will see several files that contain zotero.sqlite in their filename (one should just be called that, others will be something like zotero.sqlite.bak1 etc.)
Which files do you have and what are their respective sizes?
I really hope you can help me on this, two years of references is not something I like to loose over a day...
I have these files: profiles.ini
zotero.sqlite 1MB
zotero.sqlite kopia 3,4 MB
zotero.sqlite kopia 2 3,9MB
zotero.sqlite.bak 1MB
First, make a back-up of your Zotero folder:
http://www.zotero.org/support/zotero_data#backing_up_your_zotero_library
Then, follow the instructions on restoring from an automated back-up using the zotero.sqlite kopia 2 file (i.e. rename it to zotero.sqlite and replace the existing zotero.sqlite file with it). See if that helps.
http://www.zotero.org/support/zotero_data#restoring_from_the_last_automatic_backup
Would anyone have any advice regarding how to use the database repair tool for databases larger than 100MB? I have started getting "database corrupted" messages every time I use Zotero. However, my database is currently 238MB with about 5300 entries and so is too large for the repair tool. I have also been unable to compress it a file less than 100MB (the file size limit).
Any thoughts or tips? I am running Zotero on OSX 10.10.5, and just started to have this problem several months ago.
(Rather than start a new discussion, I thought it best to post here, but let me know if this should be directed elsewhere)
Thanks!
Thanks again!