I can see the movie collections but not the Library?

[Bichub2]

Server Version#: 1.25.3.5448
Player Version#:

Hello there,
I hope you can help me with this please; I was trying to fix some movies that couldnt see nor delete from the library but lost all of them in the library, and I can see the collections and play them from the plex web player and the shield plex player. Tried to scan all movies again without success, it just says unexpected error.

I include the screenshots showing this and the log that I think may help; never happened before and I wouldn’t want to build another server (I did after the last plex server update in January).

Thanks a lot in advance

com.plexapp.system.log (44.1 KB)

[OttoKerner]

1. disable your ad blocker for the domain plex.tv
2. disable other web browser add-ons as well, to see if this makes any difference
3. Did you perhaps add each movie into a collection? And if you did, did you tell plex to hide all movies which are part of a collection? Check the selector “Collections” (at the bottom of the “Advanced” tab, in the properties of your movie library)
4. If you are posting logs, please post the whole zip file.

[Bichub2]

Thank you for your answer, I disabled the ad blocker without any change, I see the same issue in the shield plex client, not only with the browser.

I’m including the whole zip file if it helps, Thanks a lot again.

Plex Media Server Logs_2022-03-11_08-38-53.zip (3.7 MB)

[OttoKerner]

What about item 3) in my list?

[OttoKerner]

Your log files indicate that your database is damaged. Thanks, @BigWheel !

Mar 11, 2022 08:30:49.021 [21432] ERROR - [DatabaseFixups] SQLITE3:0x1, 11, statement aborts at 19: [delete from media_items where id=?] database disk image is malformed
Mar 11, 2022 08:30:49.022 [21432] ERROR - [DatabaseFixups] Exception inside transaction (inside=1) (/data/jenkins/server/1263670044/Library/MediaItem.cpp:880): sqlite3_statement_backend::loadOne: database disk image is malformed
Mar 11, 2022 08:30:49.022 [21432] ERROR - [DatabaseFixups] Exception inside transaction (inside=1) (/data/jenkins/server/1263670044/Library/DatabaseFixups.cpp:194): sqlite3_statement_backend::loadOne: database disk image is malformed
Mar 11, 2022 08:30:49.022 [21432] ERROR - [DatabaseFixups] Fixup 42DatabaseFixupsGarbageCollectTransientItems threw an exception: sqlite3_statement_backend::loadOne: database disk image is malformed

Did you move the Plex server data away from their default location, onto a user-accessible external drive?
If so, you can copy the database file over to a computer and try to repair it, using a Plex server installation on a PC or Mac. Repair a Corrupted Database | Plex Support

If the Plex server data are still located on the internal memory of the Shield, I’m afraid your database needs to be erased and re-created.

Database damage usually occurs when
a) the free storage space is running low,
b) if the Server device is suddenly unplugged without issuing the command for safe shutdown

[Bichub2]

Yes sorry, collections where created by the library, not myself

[Bichub2]

Thanks a lot again @OttoKerner & @BigWheel , server data is in a usb disk fixed to the shield, did it months ago. May be I moved it while working and damaged it.

Will try to repair it; if not possible will create a new one:

Update: I had automatic backups and restored a recent one: it works perfectly now!!

Thank you, you have been very helpful.

[OttoKerner]

Glad you got it working again!