Invalid Mediainfo XML-File in releaseextrafull.mediainfo`

[Gawall]

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 (&apos;Six Voices&apos;) 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>