New media is not been added anymore, the consol shows below:
SQLITE3:0x1, 11, database corruption at line 69165 of [a29f994989]
SQLITE3:0x1, 11, statement aborts at 16: [SELECT sttb.id,sttb.account_id,sttb.device_id,sttb.timespan,sttb.at,sttb.lan,sttb.bytes FROM statistics_bandwidth sttb WHERE (sttb.account_id=:C1 AND sttb.device_id=:C2 AND sttb.timespan=:C3 AND sttb.at=:C4 AND sttb.lan=:C5) LIMIT :C6] database disk image is malformed
Thread: Uncaught exception running async task which was spawned by thread 216968568000: std::exception
Unfortunately I have no backup, so only way I think I can solve it is to repair the database?
I found above link, but it doesnt seems to explain when the server is installed on nvidia shield.
Can somebody please help me how to fix this? I am a real noob requarding PC and stuff
There will probably be some backups on the shield already, assuming the corruption just happened recently, you may be able to restore one of them. Stop the Plex server service on the shield, rename/copy the live DB (I would not delete it until everything is back up and running), copy one of the backups across (renaming it at the same time, as it will probably have a date and time stamp in the filename of when the backup took place), then start up the Plex server service on the shield.
If that does not work it could, it be worth a shot trying to use this guide, once you copy the db files over from the shield.
you will probably need to install the server on to the computer just to get access to the Plex SQLite tool (I’m not sure if these can be downloaded from the Plex website separately). You won’t need to claim/register the server after installation, you are just looking to get the exe that is installed by the server installation.
I manage to do everything in the links but unfortunatly it didnt solve the problem.
I just created a new database, it took some time but al working well again. I will turn on the back for future restores :-).
Just to be sure, you’re talking about Plex’s built-in auto backup feature right? Because if you try to backup a live sqlite database using other software, you’re going to corrupt it.
