Possible bug in core Plex database content?

Dev Community Dev/API Corner
1

I’m just stumpling over a problem in the Plex database. There seems to be wrong content. It’s about stream_types:

Table: stream_types

rowid id name
1 1 audio
2 2 video
3 3 subtitle

Table: media_streams
stream_type_id == 1 --> video
stream_type_id == 2 --> audio
stream_type_id == 3 --> subtitle
–> audio and video content is swapped.

It seems that the table stream_types is a documentational table that’s no longer in use. In fact it’s wrong content confuses developers.

BTW, there are more than three stream_type_ids in media_streams.

2

That table is not used anymore. You can ignore it. The stream_types are hard coded in PMS.

3

Thanks. I would remove that table then … or at least correct these two wrong values.

It’s not for us external developers alone, it’s for you guys too. At one point in the future you could stumble over it.

Just my USD 0.02 after 20 years of DB2 administration.

4

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