I’ve been using sqlite3.exe with PowerShell on Windows to update my Plex DB for a while now and it stopped working after a recent update.
I found this post and based on @Volts comment I was able to figure out how to get it working again using the Plex EXE.
Here is a basic command format I use on Windows and with PowerShell in case anyone is interested:
$PlexDB = “C:\Users\PLEX\AppData\Local\Plex Media Server\Plug-in Support\Databases\com.plexapp.plugins.library.db”
$PlexEXE = “C:\Program Files (x86)\Plex\Plex Media Server\Plex Media Server.exe”
$SQL = “SQLITE STATEMENT HERE”& “$PlexEXE” “-sqlite” $PlexDB $SQL
