Invalid Mediainfo XML-File in releaseextrafull.mediainfo` #2656
Open
Description
Hi,
I recently set up a new nZEDb instance on Ubuntu 20.04 using the following guide https://github.com/nZEDb/nZEDb/wiki/Install-Guide:-Ubuntu-18.04 (was using a pretty old version on Ubuntu 14.10 before). Everything is working fine.
I am also using some cronjobs to extract metadata from the nZEDb-Database. I recognized, that the xml in table releaseextrafull
row mediainfo
is containing invalid xml in the latest nZEDb Version. Some node names start with numbers which is not allowed. Here an example:
<writing_application>
<0>mkvmerge v7.1.0 ('Good Love') 64bit built on Jul 27 2014 13:06:55</0>
<1>mkvmerge v7.1.0 ('Good Love') 64bit built on Jul 27 2014 13:06:55</1>
</writing_application>
The xml looked fine in my old nZEDb build. I suspect this has something to do with the usage of the php-mediainfo wrapper. Below is a comparison of the old and new xml structure.
new mediainfo.xml structure:
<?xml version="1.0"?>
<MediaInfoContainer>
<version>20.09</version>
<general>
<count>332</count>
<count_of_stream_of_this_kind>1</count_of_stream_of_this_kind>
<kind_of_stream>
<shortName>General</shortName>
<fullName>General</fullName>
</kind_of_stream>
<stream_identifier>0</stream_identifier>
<unique_id>
<shortName>108074987768684943628017482245273018850</shortName>
<fullName>108074987768684943628017482245273018850 (0x514E7C4AED61C9099C0E5C03080FE1E2)</fullName>
</unique_id>
<count_of_video_streams>1</count_of_video_streams>
<count_of_audio_streams>1</count_of_audio_streams>
<video_format_list>AVC</video_format_list>
<video_format_withhint_list>AVC</video_format_withhint_list>
<codecs_video>AVC</codecs_video>
<audio_format_list>E-AC-3</audio_format_list>
<audio_format_withhint_list>E-AC-3</audio_format_withhint_list>
<audio_codecs>E-AC-3</audio_codecs>
<audio_language_list>English</audio_language_list>
<complete_name>/var/www/nZEDb/resources/tmp/unrar/f/f3fba7b3a05b8eb0a26b8b6423715fe384849e15/unrar/920210645457440ebc28a0c8f000f14e.mkv</complete_name>
<folder_name>/var/www/nZEDb/resources/tmp/unrar/f/f3fba7b3a05b8eb0a26b8b6423715fe384849e15/unrar</folder_name>
<file_name_extension>920210645457440ebc28a0c8f000f14e.mkv</file_name_extension>
<file_name>920210645457440ebc28a0c8f000f14e</file_name>
<file_extension>mkv</file_extension>
<format>
<shortName>Matroska</shortName>
<fullName>Matroska</fullName>
</format>
<format_url>https://matroska.org/downloads/windows.html</format_url>
<format_extensions_usually_used>mkv mk3d mka mks</format_extensions_usually_used>
<commercial_name>Matroska</commercial_name>
<format_version>Version 4</format_version>
<file_size>
<bit>2303904</bit>
</file_size>
<duration>
<milliseconds>2524768</milliseconds>
</duration>
<overall_bit_rate_mode>
<shortName>CBR</shortName>
<fullName>Constant</fullName>
</overall_bit_rate_mode>
<overall_bit_rate>
<shortName>7300</shortName>
<fullName>7 300 b/s</fullName>
</overall_bit_rate>
<frame_rate>
<absoluteValue>23</absoluteValue>
<textValue>23.976 FPS</textValue>
</frame_rate>
<isstreamable>Yes</isstreamable>
<file_last_modification_date>
<date>2020-12-09 07:08:38.000000</date>
<timezone_type>3</timezone_type>
<timezone>UTC</timezone>
</file_last_modification_date>
<file_last_modification_date_local>
<date>2020-12-09 07:08:38.000000</date>
<timezone_type>3</timezone_type>
<timezone>Europe/Berlin</timezone>
</file_last_modification_date_local>
<writing_application>
<0>mkvmerge v45.0.0 ('Heaven in Pennies') 64-bit</0>
<1>mkvmerge v45.0.0 ('Heaven in Pennies') 64-bit</1>
</writing_application>
<writing_library>
<shortName>libebml v1.3.10 + libmatroska v1.5.2</shortName>
<fullName>libebml v1.3.10 + libmatroska v1.5.2</fullName>
</writing_library>
<istruncated>Yes</istruncated>
</general>
<audios>
<item0>
<count>303</count>
<count_of_stream_of_this_kind>1</count_of_stream_of_this_kind>
<kind_of_stream>
<shortName>Audio</shortName>
<fullName>Audio</fullName>
</kind_of_stream>
<stream_identifier>0</stream_identifier>
<streamorder>1</streamorder>
<id>
<shortName>2</shortName>
<fullName>2</fullName>
</id>
<unique_id>
<shortName>14362528904126077192</shortName>
<fullName>14362528904126077192</fullName>
</unique_id>
<format>
<shortName>E-AC-3</shortName>
<fullName>E-AC-3</fullName>
</format>
<format_info>Enhanced AC-3</format_info>
<format_url>https://en.wikipedia.org/wiki/Dolby_Digital_Plus</format_url>
<commercial_name>
<0>Dolby Digital Plus</0>
<1>Dolby Digital Plus</1>
</commercial_name>
<format_settings_endianness>Big</format_settings_endianness>
<internet_media_type>audio/eac3</internet_media_type>
<codec_id>A_EAC3</codec_id>
<duration>
<milliseconds>2524768</milliseconds>
</duration>
<bit_rate_mode>
<shortName>CBR</shortName>
<fullName>Constant</fullName>
</bit_rate_mode>
<bit_rate>
<absoluteValue>640000</absoluteValue>
<textValue>640 kb/s</textValue>
</bit_rate>
<channel_s>
<absoluteValue>6</absoluteValue>
<textValue>6 channels</textValue>
</channel_s>
<channel_positions>
<shortName>Front: L C R, Side: L R, LFE</shortName>
<fullName>3/2/0.1</fullName>
</channel_positions>
<channel_layout>L R C LFE Ls Rs</channel_layout>
<samples_per_frame>1536</samples_per_frame>
<sampling_rate>
<absoluteValue>48000</absoluteValue>
<textValue>48.0 kHz</textValue>
</sampling_rate>
<samples_count>121188864</samples_count>
<frame_rate>
<absoluteValue>31</absoluteValue>
<textValue>31.250 FPS (1536 SPF)</textValue>
</frame_rate>
<compression_mode>
<shortName>Lossy</shortName>
<fullName>Lossy</fullName>
</compression_mode>
<delay>
<milliseconds>0</milliseconds>
</delay>
<delay_origin>
<shortName>Container</shortName>
<fullName>Container</fullName>
</delay_origin>
<delay_relative_to_video>
<milliseconds>0</milliseconds>
</delay_relative_to_video>
<stream_size>
<bit>201981440</bit>
</stream_size>
<language>
<0>en</0>
<1>English</1>
<2>English</2>
<3>en</3>
<4>eng</4>
<5>en</5>
</language>
<service_kind>
<0>CM</0>
<1>Complete Main</1>
</service_kind>
<default>
<shortName>Yes</shortName>
<fullName>Yes</fullName>
</default>
<forced>
<shortName>No</shortName>
<fullName>No</fullName>
</forced>
<bsid>16</bsid>
<dialog_normalization>
<0>-31</0>
<1>-31 dB</1>
</dialog_normalization>
<compr>
<0>-0.28</0>
<1>-0.28 dB</1>
</compr>
<acmod>7</acmod>
<lfeon>1</lfeon>
<dialnorm_average>
<0>-31</0>
<1>-31 dB</1>
</dialnorm_average>
<dialnorm_minimum>
<0>-31</0>
<1>-31 dB</1>
</dialnorm_minimum>
<dialnorm_maximum>
<0>-31</0>
<1>-31 dB</1>
</dialnorm_maximum>
<dialnorm_count>121</dialnorm_count>
<compr_average>
<0>-1.94</0>
<1>-1.94 dB</1>
</compr_average>
<compr_minimum>
<0>-2.50</0>
<1>-2.50 dB</1>
</compr_minimum>
<compr_maximum>
<0>-1.16</0>
<1>-1.16 dB</1>
</compr_maximum>
<compr_count>23</compr_count>
<samplingcount_source>General_Duration</samplingcount_source>
<duration_source>General_Duration</duration_source>
</item0>
</audios>
<videos>
<item0>
<count>379</count>
<count_of_stream_of_this_kind>1</count_of_stream_of_this_kind>
<kind_of_stream>
<shortName>Video</shortName>
<fullName>Video</fullName>
</kind_of_stream>
<stream_identifier>0</stream_identifier>
<streamorder>0</streamorder>
<id>
<shortName>1</shortName>
<fullName>1</fullName>
</id>
<unique_id>
<shortName>1935139021923131713</shortName>
<fullName>1935139021923131713</fullName>
</unique_id>
<format>
<shortName>AVC</shortName>
<fullName>AVC</fullName>
</format>
<format_info>Advanced Video Codec</format_info>
<format_url>http://developers.videolan.org/x264.html</format_url>
<commercial_name>AVC</commercial_name>
<format_profile>High@L4</format_profile>
<format_settings>CABAC / 4 Ref Frames</format_settings>
<format_settings_cabac>
<shortName>Yes</shortName>
<fullName>Yes</fullName>
</format_settings_cabac>
<format_settings_reference_frames>
<0>4</0>
<1>4 frames</1>
</format_settings_reference_frames>
<internet_media_type>video/H264</internet_media_type>
<codec_id>V_MPEG4/ISO/AVC</codec_id>
<codec_id_url>http://ffdshow-tryout.sourceforge.net/</codec_id_url>
<duration>
<milliseconds>2524775</milliseconds>
</duration>
<bit_rate_mode>
<shortName>CBR</shortName>
<fullName>Constant</fullName>
</bit_rate_mode>
<nominal_bit_rate>
<absoluteValue>10000000</absoluteValue>
<textValue>10 000 kb/s</textValue>
</nominal_bit_rate>
<width>
<absoluteValue>1920</absoluteValue>
<textValue>1 920 pixels</textValue>
</width>
<height>
<absoluteValue>1080</absoluteValue>
<textValue>1 080 pixels</textValue>
</height>
<stored_height>1088</stored_height>
<sampled_width>1920</sampled_width>
<sampled_height>1080</sampled_height>
<pixel_aspect_ratio>1.000</pixel_aspect_ratio>
<display_aspect_ratio>
<absoluteValue>1.778</absoluteValue>
<textValue>16:9</textValue>
</display_aspect_ratio>
<frame_rate_mode>
<shortName>CFR</shortName>
<fullName>Constant</fullName>
</frame_rate_mode>
<frame_rate>
<absoluteValue>23</absoluteValue>
<textValue>23.976 (24000/1001) FPS</textValue>
</frame_rate>
<framerate_num>24000</framerate_num>
<framerate_den>1001</framerate_den>
<frame_count>60534</frame_count>
<color_space>YUV</color_space>
<chroma_subsampling>
<0>4:2:0</0>
<1>4:2:0</1>
</chroma_subsampling>
<bit_depth>
<absoluteValue>8</absoluteValue>
<textValue>8 bits</textValue>
</bit_depth>
<scan_type>
<shortName>Progressive</shortName>
<fullName>Progressive</fullName>
</scan_type>
<bits_pixel_frame>0.201</bits_pixel_frame>
<delay>
<milliseconds>0</milliseconds>
</delay>
<delay_origin>
<shortName>Container</shortName>
<fullName>Container</fullName>
</delay_origin>
<default>
<shortName>Yes</shortName>
<fullName>Yes</fullName>
</default>
<forced>
<shortName>No</shortName>
<fullName>No</fullName>
</forced>
<buffer_size>31250000</buffer_size>
<colour_description_present>Yes</colour_description_present>
<colour_description_present_source>Stream</colour_description_present_source>
<color_range>Limited</color_range>
<colour_range_source>Stream</colour_range_source>
<color_primaries>BT.709</color_primaries>
<colour_primaries_source>Stream</colour_primaries_source>
<transfer_characteristics>BT.709</transfer_characteristics>
<transfer_characteristics_source>Stream</transfer_characteristics_source>
<matrix_coefficients>BT.709</matrix_coefficients>
<matrix_coefficients_source>Stream</matrix_coefficients_source>
<framecount_source>General_Duration</framecount_source>
<duration_source>General_Duration</duration_source>
</item0>
</videos>
<subtitles/>
<images/>
<menus/>
<others/>
</MediaInfoContainer>
Old mediainfo.xml structure:
<?xml version="1.0" encoding="UTF-8"?>
<Mediainfo version="0.7.88">
<File>
<track type="General">
<Unique_ID>250610783816984752489325662138285684306 (0xBC89E19C7AEFD7B6A6E4D4DA1153F652)</Unique_ID>
<Complete_name>/var/www/nZEDb/resources/tmp/unrar/2/2f6af4e4b5c625b2d6d4413ea92a66e6184a17d7/unrar/[project-gxs] Kampfer 01 [10bit BD 720p] [839D3755].mkv</Complete_name>
<Format>Matroska</Format>
<Format_version>Version 4 / Version 2</Format_version>
<File_size>1.10 MiB</File_size>
<Duration>21 min 9 s</Duration>
<Overall_bit_rate>7 246 b/s</Overall_bit_rate>
<Movie_name>Kampfer 01</Movie_name>
<Encoded_date>UTC 2017-01-18 02:49:14</Encoded_date>
<Writing_application>mkvmerge v7.7.0 ('Six Voices') 32bit built on Feb 28 2015 23:23:00</Writing_application>
<Writing_library>libebml v1.3.1 + libmatroska v1.4.2</Writing_library>
<IsTruncated>Yes</IsTruncated>
<Attachments>curswfte.ttf / impact.ttf / Jambono-Regular.ttf / MarkingPenPL.TTF / Mixage_Bold_BT.ttf</Attachments>
</track>
<track type="Video">
<ID>1</ID>
<Format>AVC</Format>
<Format_Info>Advanced Video Codec</Format_Info>
<Format_profile>High 10@L5</Format_profile>
<Format_settings__CABAC>Yes</Format_settings__CABAC>
<Format_settings__ReFrames>16 frames</Format_settings__ReFrames>
<Codec_ID>V_MPEG4/ISO/AVC</Codec_ID>
<Duration>21 min 9 s</Duration>
<Width>1 280 pixels</Width>
<Height>720 pixels</Height>
<Display_aspect_ratio>16:9</Display_aspect_ratio>
<Frame_rate_mode>Constant</Frame_rate_mode>
<Frame_rate>24.000 FPS</Frame_rate>
<Color_space>YUV</Color_space>
<Chroma_subsampling>4:2:0</Chroma_subsampling>
<Bit_depth>10 bits</Bit_depth>
<Scan_type>Progressive</Scan_type>
<Writing_library>x264 core 146 r2538 121396c</Writing_library>
<Encoding_settings>cabac=1 / ref=16 / deblock=1:1:2 / analyse=0x3:0x133 / me=umh / subme=10 / psy=1 / psy_rd=0.40:0.00 / mixed_ref=1 / me_range=24 / chroma_me=1 / trellis=2 / 8x8dct=1 / cqm=0 / deadzone=21,11 / fast_pskip=1 / chroma_qp_offset=-2 / threads=12 / lookahead_threads=2 / sliced_threads=0 / nr=0 / decimate=1 / interlaced=0 / bluray_compat=0 / constrained_intra=0 / bframes=8 / b_pyramid=2 / b_adapt=2 / b_bias=0 / direct=3 / weightb=1 / open_gop=0 / weightp=2 / keyint=250 / keyint_min=23 / scenecut=40 / intra_refresh=0 / rc_lookahead=40 / rc=crf / mbtree=1 / crf=22.0 / qcomp=0.60 / qpmin=0 / qpmax=81 / qpstep=4 / ip_ratio=1.40 / aq=1:0.60</Encoding_settings>
<Language>English</Language>
<Default>Yes</Default>
<Forced>No</Forced>
</track>
<track type="Audio">
<ID>2</ID>
<Format>AAC</Format>
<Format_Info>Advanced Audio Codec</Format_Info>
<Format_profile>LC</Format_profile>
<Codec_ID>A_AAC</Codec_ID>
<Duration>21 min 9 s</Duration>
<Channel_s_>2 channels</Channel_s_>
<Channel_positions>Front: L R</Channel_positions>
<Sampling_rate>48.0 kHz</Sampling_rate>
<Frame_rate>46.875 FPS (1024 spf)</Frame_rate>
<Compression_mode>Lossy</Compression_mode>
<Delay_relative_to_video>9 ms</Delay_relative_to_video>
<Language>Japanese</Language>
<Default>Yes</Default>
<Forced>No</Forced>
</track>
<track type="Text">
<ID>3</ID>
<Format>ASS</Format>
<Codec_ID>S_TEXT/ASS</Codec_ID>
<Codec_ID_Info>Advanced Sub Station Alpha</Codec_ID_Info>
<Compression_mode>Lossless</Compression_mode>
<Title>English</Title>
<Language>English</Language>
<Default>Yes</Default>
<Forced>No</Forced>
</track>
<track type="Menu">
<_00_00_00000>en:Prologue / en:Opening / en:Ending</_00_00_00000>
<_00_01_06983>en:Episode</_00_01_06983>
<_00_20_40021>en:Preview</_00_20_40021>
</track>
</File>
</Mediainfo>
Metadata
Assignees
Labels
No labels