Update database: "Result: unknown tokenizer: collating"

Plex Media Server
1

Server Version#: 1.23.6.4881
Server-Terramaster
I just wanted to adjust a few fields in the database. Was never a problem “before”. The day before yesterday, the Plex was completely rebuilt and all metadata was read in. I made a copy of the database and called it in DB Browser, made a SQL statement and got the error “Result: unknown tokenizer: collating”. Ok, first I searched and tried a “PRAGMA integrity_check” with sqlite3. Here came the error “Error: no such collation sequence: icu_root”. And while searching for the error I stumbled across the note “Hoping for help with DB corruption - #8 by ChuckPa”. When I try to use this sqlite version, I only get:

Error relocating /lib/libcrypto.so.1.1: makecontext: symbol not found
Error relocating /lib/libcrypto.so.1.1: setcontext: symbol not found
Error relocating /lib/libatomic.so.1: __atomic_exchange_16: symbol not found
Error relocating /lib/libatomic.so.1: __atomic_compare_exchange_16: symbol not found
Error relocating /lib/libatomic.so.1: __atomic_load_16: symbol not found
Error relocating /lib/libatomic.so.1: __atomic_store_16: symbol not found
Error relocating /usr/lib/plexmediaserver/Plex Media Server: curl_url: symbol not found
Error relocating /usr/lib/plexmediaserver/Plex Media Server: curl_url_set: symbol not found
Error relocating /usr/lib/plexmediaserver/Plex Media Server: curl_url_get: symbol not found
Error relocating /usr/lib/plexmediaserver/Plex Media Server: curl_url_cleanup: symbol not found
Error relocating /usr/lib/plexmediaserver/Plex Media Server: sqlite3_create_window_function: symbol not found
Error relocating /usr/lib/plexmediaserver/Plex Media Server: sqlite3_txn_state: symbol not found
Error relocating /usr/lib/plexmediaserver/Plex Media Server: sqlite3_stmt_isexplain: symbol not found
Error relocating /usr/lib/plexmediaserver/Plex Media Server: sqlite3_keyword_count: symbol not found
Error relocating /usr/lib/plexmediaserver/Plex Media Server: sqlite3_keyword_name: symbol not found
Error relocating /usr/lib/plexmediaserver/Plex Media Server: sqlite3_vtab_collation: symbol not found
Error relocating /usr/lib/plexmediaserver/Plex Media Server: sqlite3_keyword_check: symbol not found

Apparently on the TerraMaster Nas F5-420 this version is not available. Does anyone have any ideas for me on how to customize the database?
I will be happy for any help and thank you in advance …

2

You will have to use the SQLite which is embedded in Plex server. Repair a Corrupted Database | Plex Support

3

Plex Media Server]# ls -l
total 8
drwxr-xr-x 1 plex plex 388 Jul 31 17:34 Cache
drwxr-xr-x 1 plex plex 138 Jul 31 16:18 Codecs
drwxr-xr-x 1 plex plex 84 Jul 31 16:18 ‘Crash Reports’
drwxr-xr-x 1 plex plex 0 Jul 29 02:38 Diagnostics
drwxr-xr-x 1 plex plex 1784 Jul 31 17:33 Logs
drwxr-xr-x 1 plex plex 18 Jul 27 18:39 Media
drwxr-xr-x 1 plex plex 66 Jul 30 13:24 Metadata
-rw-r–r-- 1 plex plex 5 Jul 31 17:33 plexmediaserver.pid
drwxr-xr-x 1 plex plex 22 Jul 28 01:47 Plug-ins
drwxr-xr-x 1 plex plex 100 Jul 27 18:23 ‘Plug-in Support’
-rw-r–r-- 1 plex plex 785 Jul 31 17:34 Preferences.xml

On my Nas no SQLite exists in this directory… I find on the Nas only under usr/bin the executable file and then again a directory under /usr/lib/python2.7/sqlite3 …

The command :
sqlite3 com.plexapp.plugins.library.db “PRAGMA integrity_check”
but the result is:
“Error: no such collation sequence: icu_root”.
And when I want to update this database in DB Browser, the message “Result: unknown tokenizer: collating” appears. But via the Plex server the database runs error-free and is also updated. But I want to change some entries manually and that went without problems a few months ago :frowning:

4

This is the Plex data folder.
You need the folder where the Plex program files have been installed.
If you can’t get to that folder on your NAS, you might have to install PMS on your computer and use this version to perform the database repair.

5

thanks for the tip… that itself was probably not the direct solution to my problem. But after I did a dump with the Windows Plex Server, I got different error messages in the DB Browser. This made me update the browser and finally this link https://forums.plex.tv/t/can-no-longer-update-library-database-with-sqlite3/701405/43 helped me!!! … :smiley:

the only problem i have now is that the old viewstats are no longer recognized. Is it possible that something has changed here too?

1 Like
6

Sorry, I don’t know that. I can only tell you to only ever import viewing stats into an otherwise empty database – i.e. a completely new one.

7

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