Upgrade StorageSync Failing with "column index out of range" SQL Error; Local DB Corrupt & Cloud Data Incomplete
I'm experiencing a sync failure between my desktop Zotero (Windows) and Nutstore (WebDAV). The sync process stops and displays the following error:
Error(s) encountered during statement execution: column index out of range [QUERY: SELECT DISTINCT itemID...] [PARAMS: ...]
The full, lengthy SQL query and parameters from the error log can be provided if needed.
Here's the complication: My local Zotero database appears to be corrupt, but my cloud library on Zotero.org also does not have all my entries. The local library has more items than the cloud.
What I've Tried & My Current Situation:
1. I identified the likely corrupt local database files (zotero.sqlite and its .bak files).
2. However, I have not deleted them yet because a simple re-sync from the cloud would result in permanent data loss, given the cloud is not up-to-date.
3. I have a file named zoplicate.sqlite in my data directory, which seems to be a manual backup, but I'm unsure how to use it safely.
4. My primary goal is to recover the full library from my local machine and then ensure it syncs correctly to the cloud.
My Key Questions:
1. What is the safest way to repair my local database without losing the entries that only exist locally?
2. How can I leverage the zoplicate.sqlite file? Can I simply replace the corrupt zotero.sqlite with it?
3. What is the recommended step-by-step recovery process when facing both local corruption and an incomplete cloud sync?
I have already created a backup of my entire Zotero data directory. Thank you in advance for your guidance and expertise.
Error(s) encountered during statement execution: column index out of range [QUERY: SELECT DISTINCT itemID...] [PARAMS: ...]
The full, lengthy SQL query and parameters from the error log can be provided if needed.
Here's the complication: My local Zotero database appears to be corrupt, but my cloud library on Zotero.org also does not have all my entries. The local library has more items than the cloud.
What I've Tried & My Current Situation:
1. I identified the likely corrupt local database files (zotero.sqlite and its .bak files).
2. However, I have not deleted them yet because a simple re-sync from the cloud would result in permanent data loss, given the cloud is not up-to-date.
3. I have a file named zoplicate.sqlite in my data directory, which seems to be a manual backup, but I'm unsure how to use it safely.
4. My primary goal is to recover the full library from my local machine and then ensure it syncs correctly to the cloud.
My Key Questions:
1. What is the safest way to repair my local database without losing the entries that only exist locally?
2. How can I leverage the zoplicate.sqlite file? Can I simply replace the corrupt zotero.sqlite with it?
3. What is the recommended step-by-step recovery process when facing both local corruption and an incomplete cloud sync?
I have already created a backup of my entire Zotero data directory. Thank you in advance for your guidance and expertise.