Add detection and automatic repair for FTS4 (Full-Text Search) index
corruption, which can occur even when PRAGMA integrity_check passes.
New functions:
- CheckFTS(): Validates FTS4 index integrity using SQLite's integrity-check command
- DoFTSRebuild(): Rebuilds corrupted FTS4 indexes using SQLite's rebuild command
Enhanced existing commands:
- 'check' (option 3): Now includes FTS integrity checking
- 'reindex' (option 6): Now checks FTS indexes and rebuilds if corruption detected
- 'automatic' (option 2): Checks FTS after repair/reindex and automatically rebuilds if damaged
Refactored FTS table query into reusable FTS_TABLE_QUERY constant for maintainability.
Fixes: https://github.com/ChuckPa/DBRepair/issues/269
Deflate
- Create new bandwidth_statistics table with proper schema.
- Transfer only valid data from existing bandwidth statistics into new.
- Drop old table.
- Vacuum into new database.
Merge Prune & Purge as one proper command
Update ASUSTOR documentation error.
Finalize Deflate integration & reporting.
Update Release Notes
See closed PR "Freebsd compat #224" for discussion.
Updated version.
Uses FreeBSD Ports (pkg command) to determine which plexmediaserver package is installed and sets paths.
v1.11.03
1. Add DEFLATE command to provide fast database cleanup while Plex engineering fixes the root problems.
2. Handle Databases not on same storage as AppSuppDir
3. Calculate SpaceNeeded based on $DBDIR
4. Fix menu items
5. Fix reporting of SpaceNeeded when unable to process.
6. Add summary logging for DEFLATE actions in case disk full.
1. Handle Databases not on same storage as AppSuppDir
2. Calculate SpaceNeeded based on $DBDIR
3. Fix menu items
4. Fix reporting of SpaceNeeded when unable to process.
v1.11.02
Add DEFLATE command to provide fast database cleanup while Plex engineering fixes the root problems.
PlexDBRepair - release v01.03.00
1. Purge command ('piurge') - Remove old image files from Transcode cache
2. Environment variables support to tailor operation
- DBREPAIR_CACHEAGE - Set max age of files to retain
- DBREPAIR_PAGESIZE - Set Plex SQLite database page_size
ChuckPa
Max Allison
Christopher Fernando
Mark Honeychurch
2bits
causefx