zotero/resource/schema
Dan Stillman a9691f0a32 Fix partially applied upgrades after a transaction timeout
A userdata upgrade that took more than 5 minutes (e.g., dropping a large
legacy word index) was rolled back by Sqlite.sys.mjs, while its remaining
statements autocommitted and marked the database as upgraded, leaving
steps 126 and 127 missing.

Disable the transaction timeout and replace steps 122-129 (added in
Zotero 7, 9, and 10) with step 130, which checks for each change before
making it. To speed up the upgrade, drop the legacy word index without
overwriting the freed pages, since the full text already exists on disk
and we're just rewriting it in fulltext.sqlite.

https://forums.zotero.org/discussion/133859/zotero-connector-in-chrome-not-working
https://forums.zotero.org/discussion/133965/citation-saving-does-not-work-with-zotero-connector-firefox
(cherry picked from commit 34000fb29f)
2026-09-29 11:15:44 -04:00
..
global@70c3aa9862 Update global schema (locales) 2026-07-16 12:29:53 -04:00
abbreviations.json Add accented stop-words to abbreviations word list 2026-07-20 22:52:51 -04:00
dateFormats.json What's all this, then? A British English locale? I say! 2019-04-16 03:33:30 -04:00
engines.json Update default locate engines (#4125) 2024-05-15 05:45:38 -04:00
renamed-styles.json Update translators, styles, CSL locales, and renamed-styles.json 2026-04-02 15:51:43 -04:00
repotime.txt Update translators 2026-09-09 14:36:29 -04:00
system-107.sql Fixed double-quoted string literals in SQL files (#2892) 2022-11-21 01:14:07 -05:00
system.sql Add EPUB to Attachment File Type in Advanced Search (#3360) 2023-08-24 03:06:33 -04:00
triggers.sql Type/field handling overhaul 2019-09-16 02:27:22 -04:00
userdata.sql Fix partially applied upgrades after a transaction timeout 2026-09-29 11:15:44 -04:00