So what happens, exactly? It may appear to freeze for a while while the upgrade is proceeding.

Thanks for responding. It asks me to download the repair kit again and the process starts all over. It doesn't give me any other indication that my database is corrupt besides beginning the process all over when Firefox restarts. I have followed the directions for replacing my database several times: I upload my folder, copy the new file, replace the old file, and reopen Firefox. The only two slight differences between my sequence and the directions are that there is no corrupt file to erase--but I don't think there has to be--and that the new database files do not appear to be zipped when I copy them.

If you know of any way I can get any form of Zotero back, I will really appreciate it.

1. Click red download. Click install now.

Restart firefox to complete changes

2. Zotero Upgrade Wizard says “This is a major upgrade. Be sure you have reviewed upgrade instructions. Press continue to upgrade now”

“Error, your database must be repaired. Load database repair tool. “

”Z o t e r o D a t a b a s e R e p a i r T o o l

T h i s i s a n a u t o m a t e d s e r v i c e t o r e b u i l d Z o t e r o d a t a b a s e s t h a t h a v e b e c o m e d a m a g e d o r t h a t c a n n o t b e u p g r a d e d b y Z o t e r o .

P l e a s e n o t e : Y o u s h o u l d c l o s e F i r e f o x a n d m a k e a b a c k u p c o p y o f y o u r e n t i r e Z o t e r o d a t a d i r e c t o r y b e f o r e p r o c e e d i n g . Y o u c a n l o c a t e y o u r Z o t e r o d a t a d i r e c t o r y b y o p e n i n g t h e Z o t e r o p r e f e r e n c e s f r o m t h e g e a r m e n u i n t h e Z o t e r o t o o l b a r o r v i a T o o l s !í A d d - o n s !í E x t e n s i o n s !í Z o t e r o !í O p t i o n s / P r e f e r e n c e s a n d c l i c k i n g " S h o w D a t a D i r e c t o r y " i n t h e A d v a n c e d p a n e .

T o u s e t h i s t o o l , f i r s t l o c a t e t h e z o t e r o . s q l i t e f i l e i n y o u r Z o t e r o d a t a d i r e c t o r y , c l o s e F i r e f o x , a n d m a k e a c o p y o f t h e f i l e . T h e n u p l o a d t h e c o p y u s i n g t h e f o r m b e l o w .

H i n t : T o g r e a t l y r e d u c e u p l o a d t i m e , c o m p r e s s y o u r d a t a b a s e t o a Z I P f i l e b e f o r e u p l o a d i n g . O n a M a c , c o n t r o l - c l i c k t h e z o t e r o . s q l i t e f i l e a n d s e l e c t " C r e a t e A r c h i v e o f z o t e r o . s q l i t e " f r o m t h e d r o p - d o w n m e n u . O n W i n d o w s , r i g h t - c l i c k z o t e r o . s q l i t e a n d c h o o s e " S e n d T o > C o m p r e s s e d ( z i p p e d ) F o l d e r " . I n e i t h e r c a s e , y o u s h o u l d s e e a n e w f i l e , z o t e r o . s q l i t e . z i p , t h a t y o u c a n u p l o a d b e l o w .

I f y o u h a v e t r o u b l e u p l o a d i n g , t r y a d i f f e r e n t b r o w s e r .”

* I follow these directions to the letter every time *


3. Zotero says

“Your database has been rebuilt.

The new file is available here:

https://api.zotero.org/utils/dbfix/files/xxxxxxxx/zotero.sqlite.zip (3382KB)

After downloading this file, unzip it, close Firefox, and place the extracted zotero.sqlite in your Zotero data directory, replacing the existing file. If there is a zotero.sqlite.is.corrupt file in the directory, delete it. (Be sure you've made a backup of the entire 'zotero' folder before performing these steps!)

When you're done, start Firefox, and the upgrade process should proceed smoothly. Note that it may take a while to complete.

Please reference Upload ID 88888888 in any correspondence with the Zotero team regarding this repair. Do not post your Upload ID publicly.”


• At this point I am not sure what my zotero data directory is, or where to find it. I have replaced the file in my zotero folder. I cannot even access zotero on the web browser; it has disappeared*


4. When I restart Firefox, it tells me “You have installed a new version of Zotero. This is a major upgrade” etc. (see above). Then, when I click the installation wizard, it tells me again that the database needs to be repaired. In other words, the whole process starts all over.

At this point I am not sure what my zotero data directory is, or where to find it. I have replaced the file in my zotero folder.

You had to have found your data directory to upload your database in the first place. A "directory" and a "folder" are the same thing.

http://www.zotero.org/support/zotero_data

I have replaced the file in my zotero folder.

This is the part for which you have to tell us exactly what you're doing, because this is where you're doing something wrong.

I have replaced the file in my zotero folder.


"This is the part for which you have to tell us exactly what you're doing, because this is where you're doing something wrong. "

I open the new repaired file from the download manager, which takes me to my download folder where the repaired file is, unzipped. Then I drag that file to the zotero "directory" and drop it in. I am asked if I want to replace the file; I click replace.

Well, if you're double-clicking the zotero.sqlite.zip from the Download Manager it would unzip it for you, which might be what you mean.

What's the size and timestamp of the zotero.sqlite file? What's the size and timestamp of the zotero.sqlite file in your Zotero data directory?

I am sorry. I deleted all the .sqlite files and then downloaded the zip again and opened it, and dragged it to my zotero directory. When I reopen firefox, I still do not get the wizard, only a prompt to load the repair tool--again.

Within the Zotero directory, there are 2 .bak.sqlite files in the zotero directory. Could these be causing problems?

What are the names, sizes, and timestamps of all zotero.sqlite files in your Zotero data directory?

Provide a Debug ID for the upgrade attempt using the "Enable after restart" option.

There's no need to continue using the DB Repair Tool. The database you're uploading is no longer corrupted.

The DB Repair Tool pops up when I try to use the Upgrade Wizard. I cannot bypass the Repair Tool.

I'm not saying to bypass it—I'm saying there's no need to keep repeating the repair process. The problem is that either you're getting a spurious corruption message during upgrade or you're not properly replacing the file with the repaired version. No one else has reported this problem, so the former is fairly unlikely.

It looks like you're using OS X. If that's the case, follow the manual repair instructions (using the zotero.sqlite file from your data directory), except instead of the last four steps, use this command in Terminal:

./sqlite3 zotero.sqlite "PRAGMA integrity_check"
Does it say something other than "ok"?

"The problem is that either you're getting a spurious corruption message during upgrade or you're not properly replacing the file with the repaired version."

How do I replace it properly with the repaired version, if it is not by dragging the repaired file to the Zotero directory?

How do I replace it properly with the repaired version, if it is not by dragging the repaired file to the Zotero directory?

That's how, but Zotero shouldn't display the corruption message if the repaired file is actually in place.

Out of curiosity, if you cancel the upgrade and click "Check database integrity" from the Advanced pane of the preferences (via Tools->Add-ons->Extensions->Zotero), what does it say?

I will try that and let you know.

(I haven't gotten a corruption message except the one asking me to load the repair tool; would there be another one?)

(I haven't gotten a corruption message except the one asking me to load the repair tool; would there be another one?)

No, not necessarily. But you can run the same database check that the upgrade wizard does at any time from the Advanced pane of the preferences, even in Zotero 1.0.

Okay. I guess that's what I will have to do. Thanks again.