Shows not being marked as watched.

General Discussions
1

I have just noticed, since the last update, that none of my media is marked as watched after viewing them. Neither can I mark media as been watched form web, iOS or Xbox clients - I get a “There was a problem marking…” error using the web interface and “Connection to server…” error from Xbox and iOS clients.
When I checked the log immediately afterwards it mentions ;-
“SQLITE3:3D3F09CB, 11, database corruption at line 68549 of [8a8ffc862e]
Mar 30, 2016 22:58:39:596 [19628] ERROR - SQLITE3:3D3F09CB, 11, statement aborts at 51: [update metadata_item_settings set account_id=:metadata_item_settings_account_id,guid=:metadata_item_settings_guid,rating=:metadata_item_settings_rating,view_offset=:metadata_item_setti
Mar 30, 2016 22:58:39:596 [19628] ERROR - Exception inside transaction (inside=1) (Library\MetadataItem.cpp:6795): sqlite3_statement_backend::loadOne: database disk image is malformed
Mar 30, 2016 22:58:39:596 [19628] ERROR - Soci Exception handled: sqlite3_statement_backend::loadOne: database disk image is malformed
Mar 30, 2016 22:58:39:599 [22496] DEBUG - Completed: [192.168.0.10:57246] GET /:/scrobble?identifier=com.plexapp.plugins.library&key=4864 (20 live) TLS GZIP 5ms 441 bytes 500 (pipelined: 3)”

Any help - much appreciated,

Richie

2

Database corruption is never good.
Make absolutely sure that you did not move your plex data folder onto a networked drive (like a NAS or a file server).
If you did, move it back onto a local drive. (Because moving it onto a network folder is a recipe for corrupting the database.)

Then perform a database repair or restore an earlier backup of your database.

3

Thanks for the info. Rolling back to an earlier database was the least painful option. Sqlite commands on windows aren’t quite the same as the OSX ones in the ‘how-to’ so I couldn’t figure out how to do a repair…

Thanks again,
Richie :)>-

4

@richieoshea said:
Thanks for the info. Rolling back to an earlier database was the least painful option. Sqlite commands on windows aren’t quite the same as the OSX ones in the ‘how-to’ so I couldn’t figure out how to do a repair…

There is a SQLite extension for the Firefox web browser which is also usable for the repair operation. I used it myself twice already.
Basically it is just:

  1. export database as a csv text dump
  2. import the database back from the dumpfile

all of which can be equally achieved with a mouse instead of commands in a text console.