Server Version#: plexmediaserver_1.24.2.4973-2b1b51db9_amd64
Player Version#:
Linux#: Ubuntu 20.04.3 LTS x86_64
syslog contains “localhost Plex Media Server[14644]: Error: Unable to set up server: sqlite3_statement_backend::prepare: no such table: activities for SQL: update activities set finished_at=started_at where finished_at is null (N4soci10soci_errorE)”
I have tried the sequence:
“sudo apt purge plexmediaserver”
“sudo dpkg -i Downloads/plexmediaserver_1.24.2.4973-2b1b51db9_amd64.deb”
multiple times.
But wouldn’t my apt purge have got rid of any plex-related database?
Where do I find the logs you want?
lscpu:
Architecture: x86_64
CPU op-mode(s): 32-bit, 64-bit
Byte Order: Little Endian
Address sizes: 48 bits physical, 48 bits virtual
CPU(s): 2
On-line CPU(s) list: 0,1
Thread(s) per core: 1
Core(s) per socket: 2
Socket(s): 1
NUMA node(s): 1
Vendor ID: AuthenticAMD
CPU family: 16
Model: 6
Model name: AMD Athlon™ II X2 255 Processor
Stepping: 3
CPU MHz: 800.000
CPU max MHz: 3100.0000
CPU min MHz: 800.0000
BogoMIPS: 6227.47
Virtualization: AMD-V
L1d cache: 128 KiB
L1i cache: 128 KiB
L2 cache: 2 MiB
There’s a section on how to collect the server logs manually in the linked support article – if the database has been corrupted you should see a respective message in those logs… otherwise feel free to post them (zip the entire logs folder and upload the resulting file).
apt commands won’t get rid of the server data directory under /var/lib/plexmediaserver. If you want to skip the logs and go to nuke your server immediately you can delete that directory, following the instructions to manually uninstall the server.
