Upgrade StorageZotero 10 stuck on “Loading items” after database repair — missing database col
I’m using Zotero 10 on macOS.
Zotero initially failed to start with:
no such column: L.isAdmin
I backed up my Zotero data directory and used the official Zotero Database Repair Tool.
Database Repair Upload ID: 6ab509619cf12
The rebuilt database still had the same L.isAdmin error. The libraries table did not contain the isAdmin column even though the database reported userdata schema version 129.
After adding the missing isAdmin field, PRAGMA integrity_check returned ok, and Zotero could start.
However, Zotero is now stuck indefinitely on “Loading items…”.
Help → Report Errors shows:
no such column: IA.lastRead
Report ID: 57086647
My web library is not fully up to date, so I cannot simply replace the local database with a fresh copy from Zotero Sync without risking loss of unsynced items.
Could you advise on the safest way to repair or rerun the missing database migrations without losing local unsynced data?
Zotero initially failed to start with:
no such column: L.isAdmin
I backed up my Zotero data directory and used the official Zotero Database Repair Tool.
Database Repair Upload ID: 6ab509619cf12
The rebuilt database still had the same L.isAdmin error. The libraries table did not contain the isAdmin column even though the database reported userdata schema version 129.
After adding the missing isAdmin field, PRAGMA integrity_check returned ok, and Zotero could start.
However, Zotero is now stuck indefinitely on “Loading items…”.
Help → Report Errors shows:
no such column: IA.lastRead
Report ID: 57086647
My web library is not fully up to date, so I cannot simply replace the local database with a fresh copy from Zotero Sync without risking loss of unsynced items.
Could you advise on the safest way to repair or rerun the missing database migrations without losing local unsynced data?
Can you provide a screenshot of all the files at the root of your data directory?
Have you used any third-party tools to write to this database?