'no such column: metadata_items.slug' errors in console after upgrade to

Plex Media Server
1

Server Version#: 1.40.0.7998
Player Version#: Web client 4.125.1 (but all clients affected iOS / Android / Samsung TV etc)

I’m seeing a bunch of ‘no such column: metadata_items.slug’ errors in the console when I try to view the homepage or a particular library after upgrading my server to the latest version.

Here’s a full example of the error messages I’m getting from the logs:


[Req#17a6] SQLITE3:0x7fa8086bd0, 1, no such column: metadata_items.slug in "select media_items.id as 'media_items_id', media_items.library_section_id as 'media_items_library_section_id', media_items.section_location_id as 'media_items_section_location_id', media_items.metadata_item_id as 'media_items_metadata_item_id', media_items.type_id as 'media_items_type_id', media_items.width as 'media_items_width', media_items.height as 'media_items_height', media_items.size as 'media_items_size', media_items.duration as 'media_items_duration', media_items.bitrate as 'media_items_bitrate', media_items.container as 'media_items_container', media_items.video_codec as 'media_items_video_codec', media_items.audio_codec as 'media_items_audio_codec', media_items.display_aspect_ratio as 'media_items_display_a

And the UI displays this error message:

image
image644×777 27.1 KB

I’ve tried refreshing metadata for libraries and also adding in new libraries pointed at the same directory without any luck.

And I’ve also checked the database for errors with ChuckPa’s db repair tools: GitHub - ChuckPa/DBRepair: Database repair utility for Plex Media Server databases which found no issues.

It seems like maybe a migration didn’t run as expected during the upgrade and now a column’s not there that should be.

Does anyone know how to fix this?

Here’s a full copy of the server logs as well:

Plex Media Server Logs_2024-03-02_13-00-49.zip (1.2 MB)

2

UPDATE:

Rolling back to the previous version got everything working again. Not sure what’s up with 1.40 but definitely caused some issues for me so I will hold off on upgrading for the time being.

In my case, the previous version was cached in /var/cache/apt/archives/ and a simple sudo dpkg -i /path-to-previous-version-of-plexmedia-server-package got everything working again

3

ALL:

  1. Back down to previous version
  2. Stop Plex
  3. Using SQLITE3 com.plexapp.plugins.library.db
DELETE from external_metadata_items;
  1. Now update as you deem appropriate
4

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