SQLite Error 1: 'unknown tokenizer: collating'

Plex Media Server
1

Server Version#: 1.22.1.4228
Player Version#:

When trying to update metadata_items table through SQLite client, the following error occurs: SQLite Error 1: ‘unknown tokenizer: collating’. This started happening after a recent upgrade. What is causing it?

2

Show log please ?

3

I am not interacting with the database though PMS but rather through a sqlite3 client on linux. For example

xxxxx@xxxxxx ~ $ sqlite3 "$PLEX_DB"
SQLite version 3.34.1 2021-01-20 14:10:07
Enter ".help" for usage hints.
sqlite> .mode columns
sqlite> select id, title from metadata_items where title <> '' limit 5;
id      title                    
------  -------------------------
611033  	A Family Emergency      
540062  	Bother-in-Law           
558567  	Ep. #8353 - Sep 09, 2020
399603  	Episode 19              
399604  	Episode 20              
sqlite> update metadata_items SET title = 'Bother-in-Law' WHERE id = 540062;
Error: unknown tokenizer: collating
sqlite>
4

Thanks.

What you’re seeing is 100% expected and normal.

The PMS DB has extra features in it which are not part of distributed sqlite

In order to remedy this:

Plex\ Media\ Server --sqlite <pathname.db>

5

Thank you! This works on Linux OK. Is there something similar for windows?

6

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