reader

Upgrade to reader 3.25 or newer, which fixes the schema v43 to v44 migration:

python -m pip install --upgrade 'reader>=3.25'

Stop the app and back up the SQLite database before upgrading. Version 3.25 handles author strings with multiple parenthesized groups, source JSON objects missing author, and removal of the stale author key after adding authors.

If you must use 3.24, apply these emergency workarounds with sqlite3 your-database.db after making a backup:

1. Before starting 3.24 for the first time, clear authors containing two parenthesized groups:
UPDATE entries SET author = NULL WHERE author LIKE '%(%)%(%)%';

2. Add a null author key to legacy source JSON that lacks it:
UPDATE entries SET source = json_set(source, '$.author', json('null')) WHERE source IS NOT NULL AND json_type(source) = 'object' AND json_type(source, '$.author') IS NULL;

3. Start reader 3.24 and let the migration run.

4. If endpoints then fail with TypeError: EntrySource.__init__() got an unexpected keyword argument 'author', remove the stale key:
UPDATE entries SET source = json_remove(source, '$.author') WHERE source IS NOT NULL AND json_type(source, '$.author') IS NOT NULL;

Prefer upgrading to 3.25 rather than modifying the database manually.

Use the .dedupe.once.title plugin feature after verifying: 1) old entries have no duplicate titles, 2) most new entries share exact titles with old ones. Apply .dedupe.once.title to deduplicate based on title matching. Note: The plugin does not yet automate these checks; manual verification is required.