Move an Install to Another System

[PlexPassMiola]

Hi, I’ve followed the instructions in the link Move an Install to Another System as I moved from MacOS 10.3.16 High Sierra on a standard disk to MacOS 10.3.16 High Sierra on a SSD disk, the pc is the same iMac. The media is on a QNAP Nas.
I can see everything of my libraries: names, metadata, etc. but when I play a movie I receive the following:

I attach also the Plex and Database Logs:
Plex Media Server Logs_2019-08-31_23-27-13.zip (309.3 KB) Plex Media Server Databases_2018-07-11_15-15-16.zip (22 Bytes)

I’m not understanding what’s wrong.

The same movie are playable when run directly from the Gas (through VLC app).

Thanks, best regards.

[tom80H]

The Plex Media Server.log is showing quite a number of database corruption errors.
You can check that out and attempt to repair using the instructions of this support article:
https://support.plex.tv/articles/201100678-repair-a-corrupt-database/

[nibbles]

If I was only changing the hard drive on my Mac to an SSD, I would use SuperDuper to clone the drive to the new SSD and boot off the SSD to test it. For me this works without flaw every time.

I hope Tom’s method works for you to fix your database though. If your db had problems before the move to SSD, maybe that should be addressed before trying to restore it?

[PlexPassMiola]

Hi, Plex Media Server was running fine before the reinstall of the MacOS on a new SSD drive.

Tom, I’ve followed the instructions in the link and now the Plex Media Server doesn’t open anymore. What should I check ?

[PlexPassMiola]

This is the Plex Media Server.log file:
ep 01, 2019 13:50:41.315 [0x70000e0bd000] INFO - Plex Media Server v1.16.6.1592-b9d49bdb7 - Apple Mac x86_64 - build: darwin-x86_64 macos - GMT 02:00

Sep 01, 2019 13:50:41.316 [0x70000e0bd000] INFO - MacOSX version: 10.13.6, language: it-IT

Sep 01, 2019 13:50:41.316 [0x70000e0bd000] INFO - Processor Intel® Core™2 Duo CPU E7600 @ 3.06GHz

Sep 01, 2019 13:50:41.316 [0x70000e0bd000] INFO - /Applications/Plex Media Server.app/Contents/MacOS/Plex Media Server

Sep 01, 2019 13:50:41.633 [0x70000e3cf000] ERROR - SQLITE3:0x101, 1, no such table: schema_migrations in “select version from schema_migrations order by version”

Sep 01, 2019 13:50:41.637 [0x70000e3cf000] ERROR - Database corruption: sqlite3_statement_backend::prepare: no such table: schema_migrations for SQL: select version from schema_migrations order by version

Further attempts to run Plex Media Server app produces the following:

Sep 01, 2019 13:55:53.052 [0x7000091f7000] INFO - Plex Media Server v1.16.6.1592-b9d49bdb7 - Apple Mac x86_64 - build: darwin-x86_64 macos - GMT 02:00

Sep 01, 2019 13:55:53.052 [0x7000091f7000] INFO - MacOSX version: 10.13.6, language: it-IT

Sep 01, 2019 13:55:53.052 [0x7000091f7000] INFO - Processor Intel® Core™2 Duo CPU E7600 @ 3.06GHz

Sep 01, 2019 13:55:53.052 [0x7000091f7000] INFO - /Applications/Plex Media Server.app/Contents/MacOS/Plex Media Server

[PlexPassMiola]

HI, I’m again fighting with this, when I play a movie in the “Plex Media Server.log” this is what I see:

Sep 03, 2019 21:48:43.235 [0x70000d194000] ERROR - SQLITE3:0x101, 11, database corruption at line 68841 of [bf8c1b2b7a]
Sep 03, 2019 21:48:43.235 [0x70000d194000] ERROR - SQLITE3:0x101, 11, statement aborts at 45: [insert into play_queue_generators (playlist_id,metadata_item_id,uri,‘limit’,continuous,recursive,‘order’,created_at,updated_at,changed_at,type,extra_data) values (:play_queue_generator
Sep 03, 2019 21:48:43.235 [0x70000d194000] ERROR - Exception inside transaction (inside=1) (…/Playlists/PlayQueueRequestHandler.cpp:123): sqlite3_statement_backend::loadOne: database disk image is malformed
Sep 03, 2019 21:48:43.235 [0x70000d194000] ERROR - Soci Exception handled: sqlite3_statement_backend::loadOne: database disk image is malformed

Can you help me to fix this ?

Thx. Best regards.