I am running Plex 0.9.8.4 on my Netgear ReadyNAS and wrote a Mac App to export yur movies to a textfile (for friends who ask for a list).
Today I tried to run it again and it did not return any Data.
I tried to check the com.plexapp.plugins.library.db in Library\Application Support\Plex Media Server\Plug-in Support\Databases\ with SQLite Database Browser and Mac SQL Studio but both were not able to open the database.
My Plex Clients work just fine and stream any media I want.
Has anything been changed in the structure that I can't open the .db?
I am running Plex 0.9.8.4 on my Netgear ReadyNAS and wrote a Mac App to export yur movies to a textfile (for friends who ask for a list).
Today I tried to run it again and it did not return any Data.
I tried to check the com.plexapp.plugins.library.db in Library\Application Support\Plex Media Server\Plug-in Support\Databases\ with SQLite Database Browser and Mac SQL Studio but both were not able to open the database.
My Plex Clients work just fine and stream any media I want.
Has anything been changed in the structure that I can't open the .db?
Hope you can help me!
Regards
Ti-Ta
Wouldn;t the problem me because the database is open by Plex Media Server and needs to be closed (PMS exited) before you open it?
Edit: just noticed this is being raised in the Developers forum. Sorry. So obviously it is not as simple as i thought !!!
I am running Plex 0.9.8.4 on my Netgear ReadyNAS and wrote a Mac App to export yur movies to a textfile (for friends who ask for a list).
Today I tried to run it again and it did not return any Data.
I tried to check the com.plexapp.plugins.library.db in Library\Application Support\Plex Media Server\Plug-in Support\Databases\ with SQLite Database Browser and Mac SQL Studio but both were not able to open the database.
My Plex Clients work just fine and stream any media I want.
Has anything been changed in the structure that I can't open the .db?
Hope you can help me!
Regards
Ti-Ta
Last time I ran into an issue like that, was due to the fact that I was using a wrong version of Python and the SQLite snapin, due to the use of wal
Also, do note that SQLite is not a multi user database, nor a C/S based database, so accessing it over the LAN is not recommended, while Plex is running.
What you could do instead, is using the PMS http interface to grap the needed info
Last time I ran into an issue like that, was due to the fact that I was using a wrong version of Python and the SQLite snapin, due to the use of wal
Also, do note that SQLite is not a multi user database, nor a C/S based database, so accessing it over the LAN is not recommended, while Plex is running.
What you could do instead, is using the PMS http interface to grap the needed info
Hi - found this very useful - accessing the advanced info though the web. I need now to translate the metadata thumbnail Id's into files !
I am investigating a problem with one of my media folder which has no thumbnail but PMS thinks there is one
Just discovered that Pawel Salawa SQLite studio actually opens the Plex database nicely and I can view the data with gui interface. I used this tool when I was playing with Android App Dev and now it appears it can be useful for looking into the PMS database ( a copy of it so I do not impact the operation)
I was used to copy the com.plexapp.plugins.library.db file onto my desktop. But somewhen Plex was updated to SQLite 3.7.
SQLite 3.7 got a new feature called Write Ahead Logging (or WAL) - basically a backup in case a transaction fails - which is the reason for the .wal and .shm files in the Database folder.
