2 issues Date Added is not working and CANNOT update data with SQLLite

Plex Media Server
1

Server Version#: 4.87.2
Player Version#: ?

I am having this issue where I rebuilt my Plex server (using Windows), I have a bunch of TV Shows that appear as most recently on “Recently Added in TV Shows”, the thing is, I’ve added many more since then but cannot get these few to go away.

I researched and found out that I need to download SQLLite and update the the metadata_items table, update the added_at since they are null for these specific shows.

That leads to my next issue, when I try to update the records, it throws an error:
– Result: unknown tokenizer: collating

Searching as to why this occurs I found this link:

Now the issue with this, it appears to fix it for Linux server command line, but nothing is mentioned how to fix this in Windows or with SQL Lite (DB Browser). Does anyone know how to fix this?

2

On Windows, the path to the executable is:
C:\Program Files\Plex\Plex Media Server\Plex SQLite.exe (for 64-bit PMS)
Or:
C:\Program Files (x86)\Plex\Plex Media Server\Plex SQLite.exe (for 32-bit PMS)

3

ah, so I cannot go to the one under App Data? I have to use the command line then?

4

so I am trying this command line tool and I keep getting “Error: no such table: metadata_items” Is there something else I have to do? I’ve never used this tool before today so not sure if I need to point to the .db file or not

5

GRRRRR!!! Ok, this is freaking terrible!! How do I open the freaking database??? The data is in a completely different directory, the file path has spaces on it… which Plex creates it that way, and command line doesn’t allow me to open this file from a different directory that has spaces…

Does anyone know how to get around this?!?! Why in Gods name cannot I not just use DB Browser for SQL lite in the data folder??

6

I’m trying this, is there any good reason why this won’t work??? How can I do this and not get the error “Result: unknown tokenizer: collating”

7

Change directories to where the database is stored. Something like (include the quotes):

cd "%LOCALAPPDATA%\Plex Media Server\Plug-in Support\Databases"

Then, run Plex SQLite.exe using the full path (again, include the quotes):

"C:\Program Files (x86)\Plex\Plex Media Server\Plex SQLite.exe" com.plexapp.plugins.library.db

This all assumes you’re running the 32-bit version of PMS and that you haven’t moved your Plex data directory.

Please back up your existing database first. And ensure Plex Media Server isn’t running when you do any of this.

8

That appears to work, thank you. Now when I run this, I get a different prompt, is there something wrong with this? the …> I don’t know what that means

sqlite> update metadata_items set added_at = created_at where added_at = 910692730085 AND and metadata_type = 4
…>
…>

9

Ok, the “…>” means I didn’t end the query with a semi colon. I added that and now it work.

Thanks for the help!!

10

No problem, glad you got it working.

2 Likes
11

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.