Corrupt database HELP!

[pbirke]

Plex stopped recognizing new files, so I rebooted and now it will not start at all. Tried reinstalling and that did not help. I see this in the log:

Jun 19, 2023 08:57:34.336 [0x70000bb98000] DEBUG - ChangestampAllocator: initialized to 46298079
Jun 19, 2023 08:57:34.348 [0x70000bb98000] ERROR - SQLITE3:(nil), 11, database corruption at line 69165 of [a29f994989]
Jun 19, 2023 08:57:34.348 [0x70000bb98000] ERROR - SQLITE3:(nil), 11, statement aborts at 21: [update activities set finished_at=started_at where finished_at is null] database disk image is malformed
Jun 19, 2023 08:57:34.348 [0x70000bb98000] ERROR - Database corruption: sqlite3_statement_backend::loadOne: database disk image is malformed
Jun 19, 2023 08:57:34.348 [0x70000bb98000] ERROR - Error: Unable to set up server: sqlite3_statement_backend::loadOne: database disk image is malformed (N4soci10soci_errorE)

How do I fix this? Can I remove that corrupted entry? Is there a backup of the database? Any help would be great appreciated. Freaking out over here. Thank you

Server Version#: PMS 1.32.4 on Mac OS 12.6.6

[OttoKerner]

https://support.plex.tv/articles/repair-a-corrupted-database/

as well as GitHub - ChuckPa/PlexDBRepair: Database repair utility for Plex Media Server databases

[pbirke]

Thank you!

It is better to try to repair it or replace with a recent backup?

[OttoKerner]

It is possible that the issue was already present in older versions of the database.
So even if you can successfully restore an older backup of the database, I recommend to use the repair script from the second link anyway.

[pbirke]

Noted, thank you!

[pbirke]

PlexDBRepair-1.0.8 utility worked perfectly!!! Thank you so much for the info and quick response