1.18.2.2058 and table media_items has no column named color_trc error

Server Version#: 1.18.2.2058-e67a4e892
Player Version#: 3.108.2

Upgraded from a full working and stable 1.16.5.1488-deeb86e7f to 1.18.2.2058-e67a4e892 via the web interface.
After the upgrading, scanning library and updating when adding a new entry causes the below error (table media_items has no column named color_trc).

Rolling back to 1.16.5.1488-deeb86e7f and everything is working again.

Nov 26, 2019 19:03:10.192 [6452] DEBUG - Added new metadata item () with ID 11373
Nov 26, 2019 19:03:10.207 [6452] ERROR - SQLITE3:0x10ccc04f, 1, table media_items has no column named color_trc in "insert into media_items (library_section_id,section_location_id,metadata_item_id,type_id,width,height,size,duration,bitrate,container,video_codec,audio_codec
Nov 26, 2019 19:03:10.207 [6452] ERROR - Exception inside transaction (inside=1) (…\Library\MetadataItem.cpp:3519): sqlite3_statement_backend::prepare: table media_items has no column named color_trc for SQL: insert into media_items (library_section_id,section_location_id,metadata_item_id,type_id,width,height,size,duration,bitrate,container,video_codec,audio_codec,display_aspect_ratio,frames_per_second,audio_channels,interlaced,source,hints,display_offset,settings,created_at,updated_at,optimized_for_streaming,deleted_at,media_analysis_version,sample_aspect_ratio,proxy_type,extra_data,channel_id,begins_at,ends_at,color_trc) values (:media_items_library_section_id,:media_items_section_location_id,:media_items_metadata_item_id,:media_items_type_id,:media_items_width,:media_items_height,:media_items_size,:media_items_duration,:media_items_bitrate,:media_items_container,:media_items_video_codec,:media_items_audio_codec,:media_items_display_aspect_ratio,:media_items_frames_per_second,:media_items_audio_channels,:media_items_interlaced,:media_items_source,:media_items_hints,:media_items_display_offset,:media_items_settings,:media_items_created_at,:media_items_updated_at,:media_items_optimized_for_streaming,:media_items_deleted_at,:media_items_media_analysis_version,:media_items_sample_aspect_ratio,:media_items_proxy_type,:media_items_extra_data,:media_items_channel_id,:media_items_begins_at,:media_items_ends_at,:media_items_color_trc)
Nov 26, 2019 19:03:10.207 [6452] ERROR - Exception assimilating media item in : sqlite3_statement_backend::prepare: table media_items has no column named color_trc for SQL: insert into media_items (library_section_id,section_location_id,metadata_item_id,type_id,width,height,size,duration,bitrate,container,video_codec,audio_codec,display_aspect_ratio,frames_per_second,audio_channels,interlaced,source,hints,display_offset,settings,created_at,updated_at,optimized_for_streaming,deleted_at,media_analysis_version,sample_aspect_ratio,proxy_type,extra_data,channel_id,begins_at,ends_at,color_trc) values (:media_items_library_section_id,:media_items_section_location_id,:media_items_metadata_item_id,:media_items_type_id,:media_items_width,:media_items_height,:media_items_size,:media_items_duration,:media_items_bitrate,:media_items_container,:media_items_video_codec,:media_items_audio_codec,:media_items_display_aspect_ratio,:media_items_frames_per_second,:media_items_audio_channels,:media_items_interlaced,:media_items_source,:media_items_hints,:media_items_display_offset,:media_items_settings,:media_items_created_at,:media_items_updated_at,:media_items_optimized_for_streaming,:media_items_deleted_at,:media_items_media_analysis_version,:media_items_sample_aspect_ratio,:media_items_proxy_type,:media_items_extra_data,:media_items_channel_id,:media_items_begins_at,:media_items_ends_at,:media_items_color_trc)

Hi, when you used the 1.18 version, did it also fail to add new media? I’m seeing the same error for every 1.18 version I’ve tested, reverting back to 1.17 works.

see Plex not adding new media after update

Correct. I seem to have forgotten that bit in the post.
The reason I found the error was I noticed new media was no longer being added to the database/plex. I then started investigating why media wasn’t showing up, and saw this error.

Same problem here (1.18.2.2058)… any chance you guys have made any progress diagnosing the problem?

Bump… hoping someone from Plex can comment please.

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