Kodi Community Forum

Full Version: SPMC 16.4.1 uses wrong database
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
I have an issue with my MySQL database. Please have a look into this part of the log.
Code:
00:31:12 T:1398569264  NOTICE: special://profile/ is mapped to: special://masterprofile/
00:31:12 T:1398569264  NOTICE: -----------------------------------------------------------------------
00:31:12 T:1398569264  NOTICE: Starting SPMC (16.4-1 Git:2016-07-28-eed5ecd-dirty). Platform: Android ARM 32-bit
00:31:12 T:1398569264  NOTICE: Using Release SPMC x32 build
00:31:12 T:1398569264  NOTICE: SPMC compiled Jul 28 2016 by GCC 4.8.0 for Android ARM 32-bit API level 17 (API level 17)
00:31:12 T:1398569264  NOTICE: Running on NVIDIA SHIELD Android TV with Android 6.0.0 API level 23, kernel: Linux ARM 32-bit version 3.10.67+
00:31:12 T:1398569264  NOTICE: FFmpeg version: 2.8.6-kodi-2.8.6-Jarvis-16.0-spmc
00:31:12 T:1398569264  NOTICE: Host CPU: Cortex A57 Processor rev 1 (aarch64), 4 cores available
00:31:12 T:1398569264  NOTICE: Product: foster_e, Device: foster, Board: unknown - Manufacturer: NVIDIA, Brand: NVIDIA, Model: SHIELD Android TV, Hardware: foster_e
00:31:12 T:1398569264  NOTICE: External storage path = /storage/emulated/0; status = ok
00:31:12 T:1398569264  NOTICE: HasTouchScreen = no
00:31:12 T:1398569264  NOTICE: ARM Features: Neon enabled
00:31:12 T:1398569264  NOTICE: special://xbmc/ is mapped to: /data/user/0/com.semperpax.spmc16/cache/apk/assets
00:31:12 T:1398569264  NOTICE: special://xbmcbin/ is mapped to: /data/user/0/com.semperpax.spmc16/cache/apk/assets
00:31:12 T:1398569264  NOTICE: special://masterprofile/ is mapped to: /storage/emulated/0/Android/data/com.semperpax.spmc16/files/.spmc/userdata
00:31:12 T:1398569264  NOTICE: special://home/ is mapped to: /storage/emulated/0/Android/data/com.semperpax.spmc16/files/.spmc
00:31:12 T:1398569264  NOTICE: special://temp/ is mapped to: /storage/emulated/0/Android/data/com.semperpax.spmc16/files/.spmc/temp
00:31:12 T:1398569264  NOTICE: The executable running is:
00:31:12 T:1398569264  NOTICE: Local hostname: localhost
00:31:12 T:1398569264  NOTICE: Log File is located: /storage/emulated/0/Android/data/com.semperpax.spmc16/files/.spmc/temp/spmc.log
00:31:12 T:1398569264  NOTICE: -----------------------------------------------------------------------
00:31:12 T:1398569264  NOTICE: load settings...
00:31:12 T:1398569264   DEBUG: CSettings: loaded settings definition from special://xbmc/system/settings/settings.xml
00:31:12 T:1398569264 WARNING: CSettingInt: unknown options filler "audiocdactions" of "audiocds.autoaction"
00:31:12 T:1398569264   DEBUG: CSettings: loaded settings definition from special://xbmc/system/settings/android.xml
00:31:12 T:1398569264   DEBUG: --- Found device: SHIELD Android TV
00:31:12 T:1398569264   DEBUG:     id: 1, type: 2, isSink: true, isSource: false
00:31:12 T:1398569264   DEBUG:     channel counts:
00:31:12 T:1398569264   DEBUG:     channel index masks:
00:31:12 T:1398569264   DEBUG:     channel masks:
00:31:12 T:1398569264   DEBUG:     encodings:
00:31:12 T:1398569264   DEBUG:     sample rates:
00:31:12 T:1398569264   DEBUG: --- Found device: SHIELD Android TV
00:31:12 T:1398569264   DEBUG:     id: 4, type: 9, isSink: true, isSource: false
00:31:12 T:1398569264   DEBUG:     channel counts: 1 / 2 / 4 / 6 / 8 /
00:31:12 T:1398569264   DEBUG:     channel index masks:
00:31:12 T:1398569264   DEBUG:     channel masks: 4 / 12 / 204 / 252 / 6396 /
00:31:12 T:1398569264   DEBUG:     encodings: 5 / 2 /
00:31:12 T:1398569264   DEBUG:     sample rates: 32000 / 44100 / 48000 /
00:31:12 T:1398569264   DEBUG: AESinkAUDIOTRACK - 32000 supported
00:31:12 T:1398569264   DEBUG: AESinkAUDIOTRACK - 44100 supported
00:31:12 T:1398569264   DEBUG: AESinkAUDIOTRACK - 48000 supported
00:31:12 T:1398569264   DEBUG: AESinkAUDIOTRACK - 96000 supported
00:31:12 T:1398569264   DEBUG: AESinkAUDIOTRACK - 192000 supported
00:31:12 T:1398569264  NOTICE: Found 1 Lists of Devices
00:31:12 T:1398569264  NOTICE: Enumerated AUDIOTRACK devices:
00:31:12 T:1398569264  NOTICE:     Device 1
00:31:12 T:1398569264  NOTICE:         m_deviceName      : AudioTrackPCM
00:31:12 T:1398569264  NOTICE:         m_displayName     : Android
00:31:12 T:1398569264  NOTICE:         m_displayNameExtra: PCM
00:31:12 T:1398569264  NOTICE:         m_deviceType      : AE_DEVTYPE_PCM
00:31:12 T:1398569264  NOTICE:         m_channels        : FL,FR,FC,LFE,BL,BR,SL,SR
00:31:12 T:1398569264  NOTICE:         m_sampleRates     : 32000,44100,48000,96000,192000
00:31:12 T:1398569264  NOTICE:         m_dataFormats     : AE_FMT_S16LE,AE_FMT_FLOAT
00:31:12 T:1398569264  NOTICE:     Device 2
00:31:12 T:1398569264  NOTICE:         m_deviceName      : AudioTrackPTRAW
00:31:12 T:1398569264  NOTICE:         m_displayName     : Android
00:31:12 T:1398569264  NOTICE:         m_displayNameExtra: RAW Passthrough
00:31:12 T:1398569264  NOTICE:         m_deviceType      : AE_DEVTYPE_HDMI
00:31:12 T:1398569264  NOTICE:         m_channels        : FL,FR,FC,LFE,BL,BR,SL,SR
00:31:12 T:1398569264  NOTICE:         m_sampleRates     : 32000,44100,48000,96000,192000
00:31:12 T:1398569264  NOTICE:         m_dataFormats     : AE_FMT_AC3_RAW,AE_FMT_EAC3_RAW,AE_FMT_DTS_RAW,AE_FMT_DTSHD_RAW,AE_FMT_TRUEHD_RAW
00:31:12 T:1398569264  NOTICE:     Device 3
00:31:12 T:1398569264  NOTICE:         m_deviceName      : AudioTrackPT
00:31:12 T:1398569264  NOTICE:         m_displayName     : Android
00:31:12 T:1398569264  NOTICE:         m_displayNameExtra: IEC Passthrough
00:31:12 T:1398569264  NOTICE:         m_deviceType      : AE_DEVTYPE_HDMI
00:31:12 T:1398569264  NOTICE:         m_channels        : FL,FR,FC,LFE,BL,BR,SL,SR
00:31:12 T:1398569264  NOTICE:         m_sampleRates     : 32000,44100,48000,96000,192000
00:31:12 T:1398569264  NOTICE:         m_dataFormats     : AE_FMT_AC3,AE_FMT_DTS
00:31:12 T:1398569264   DEBUG: CSkinSettings: no <skinsettings> tag found
00:31:12 T:1398569264  NOTICE: No settings file to load (special://xbmc/system/advancedsettings.xml)
00:31:12 T:1398569264  NOTICE: Loaded settings file from special://profile/advancedsettings.xml
00:31:12 T:1398569264  NOTICE: Contents of special://profile/advancedsettings.xml are...
                                            <?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
                                            <advancedsettings>
                                              <jsonrpc>
                                                <compactoutput>true</compactoutput>
                                              </jsonrpc>
                                              <videodatabase>
                                                <type>mysql</type>
                                                <host>192.168.1.40</host>
                                                <port>3306</port>
                                                <user>root</user>
                                                <name>KodiVideoDatabase_</name>

                                              </videodatabase>
                                              <musicdatabase>
                                                <type>mysql</type>
                                                <host>192.168.1.40</host>
                                                <port>3306</port>
                                                <user>root</user>
                                                <name>KodiMusicDatabase_</name>

                                              </musicdatabase>
                                              <pathsubstitution>
                                                <substitute>
                                                  <from>special://masterprofile/Thumbnails/</from>
                                                  <to>smb://GINA/xbmcpicturecache/</to>
                                                </substitute>
                                              </pathsubstitution>
                                              <tvshowmatching action="append">
                                                <regexp>[Ss]([0-9]+)[ ._-]*[Ee]([0-9]+)([^\\/]*)(?:(?:[\\/]video_ts)?[\\/]video_ts\.ifo)$</regexp>
                                              </tvshowmatching>
                                              <video>
                                                <!-- Filename triggers for 3D (stereoscopic) mode. -->
                                                <stereoscopicflagssbs>3dbd|3DSBS|3D.SBS|HSBS|H.SBS|H-SBS| SBS |FULL-SBS|FULL.SBS|FULLSBS|FSBS|HALF-SBS</stereoscopicflagssbs>
                                                <stereoscopicflagstab>3DTAB|3D.TAB|HTAB|H.TAB|3DOU|3D.OU|3D.HOU| HOU | OU |HALF-TAB</stereoscopicflagstab>
                                                <enablehighqualityhwscalers>true</enablehighqualityhwscalers>
                                              </video>
                                              <network>
                                                <buffermode>1</buffermode>
                                                <!-- Buffer all filesystems (including local)  -->
                                                <cachemembuffersize>419430400</cachemembuffersize>
                                                 --&gt;
                                                <!-- 400MB buffer  -->
                                                <readbufferfactor>30</readbufferfactor>
                                              </network>
                                              <videolibrary>
                                                <dateadded>0</dateadded>
                                                <recentlyaddeditems>50</recentlyaddeditems>
                                                <importwatchedstate>true</importwatchedstate>
                                                <importresumepoint>true</importresumepoint>
                                              </videolibrary>
                                            </advancedsettings>
00:31:12 T:1398569264   DEBUG: Configuring path substitutions
00:31:12 T:1398569264   DEBUG:   Registering substition pair:
00:31:12 T:1398569264   DEBUG:     From: [/storage/emulated/0/Android/data/com.semperpax.spmc16/files/.spmc/userdata/Thumbnails/]
00:31:12 T:1398569264   DEBUG:     To:   [smb://GINA/xbmcpicturecache/]
00:31:12 T:1398569264  NOTICE: Default DVD Player: dvdplayer
00:31:12 T:1398569264  NOTICE: Default Video Player: dvdplayer
00:31:12 T:1398569264  NOTICE: Default Audio Player: paplayer
00:31:12 T:1398569264  NOTICE: Disabled debug logging due to GUI setting. Level 0.
00:31:12 T:1398569264  NOTICE: Log level changed to "LOG_LEVEL_NORMAL"
00:31:12 T:1398569264  NOTICE: CMediaSourceSettings: loading media sources from special://masterprofile/sources.xml
00:31:12 T:1398569264  NOTICE: Loading player core factory settings from special://xbmc/system/playercorefactory.xml.
00:31:12 T:1398569264  NOTICE: Loaded playercorefactory configuration
00:31:12 T:1398569264  NOTICE: Loading player core factory settings from special://masterprofile/playercorefactory.xml.
00:31:12 T:1398569264  NOTICE: special://masterprofile/playercorefactory.xml does not exist. Skipping.
00:31:12 T:1398569264  NOTICE: Running database version Addons20
00:31:12 T:1398569264  NOTICE: ADDONS: Using repository repository.xbmc.org
00:31:12 T:1398569264  NOTICE: ADDONS: Using repository repository.regss
00:31:12 T:1398569264  NOTICE: ADDONS: Using repository repository.whitecream
00:31:12 T:1398569264  NOTICE: virtual bool CWinSystemEGL::InitWindowSystem(): Using EGL Implementation: android
00:31:12 T:1398569264  NOTICE: CEGLNativeTypeAndroid: Current resolution: 1920x1080 @ 60.000000 - Full Screen
00:31:12 T:1398569264  NOTICE: Previous line repeats 1 times.
00:31:12 T:1398569264  NOTICE: Found resolution 1920 x 1080 for display 0 with 1920 x 1080 @ 23.976025 Hz
00:31:12 T:1398569264  NOTICE: Found resolution 1920 x 1080 for display 0 with 1920 x 1080 @ 24.000000 Hz
00:31:12 T:1398569264  NOTICE: Found resolution 1920 x 1080 for display 0 with 1920 x 1080 @ 25.000000 Hz
00:31:12 T:1398569264  NOTICE: Found resolution 1920 x 1080 for display 0 with 1920 x 1080 @ 29.970030 Hz
00:31:12 T:1398569264  NOTICE: Found resolution 1920 x 1080 for display 0 with 1920 x 1080 @ 30.000000 Hz
00:31:12 T:1398569264  NOTICE: Found resolution 1920 x 1080 for display 0 with 1920 x 1080 @ 50.000000 Hz
00:31:12 T:1398569264  NOTICE: Found resolution 1920 x 1080 for display 0 with 1920 x 1080 @ 59.940060 Hz
00:31:12 T:1398569264  NOTICE: Found resolution 1920 x 1080 for display 0 with 1920 x 1080 @ 60.000000 Hz
00:31:12 T:1398569264  NOTICE: Found ([email protected]) at 23, setting to RES_DESKTOP at 16
00:31:12 T:1398569264  NOTICE: Checking resolution 16
00:31:12 T:1398569264  NOTICE: CEGLNativeTypeAndroid: Current resolution: 1920x1080 @ 60.000000 - Full Screen
00:31:12 T:1398569264  NOTICE: GL_VENDOR = NVIDIA Corporation
00:31:12 T:1398569264  NOTICE: GL_RENDERER = NVIDIA Tegra
00:31:12 T:1398569264  NOTICE: GL_VERSION = OpenGL ES 3.2 NVIDIA 361.00
00:31:12 T:1398569264  NOTICE: GL_SHADING_LANGUAGE_VERSION = OpenGL ES GLSL ES 3.20
00:31:12 T:1398569264  NOTICE: GL_EXTENSIONS = GL_EXT_debug_marker GL_EXT_base_instance GL_EXT_blend_func_extended GL_EXT_blend_minmax GL_EXT_buffer_storage GL_EXT_color_buffer_float GL_EXT_color_buffer_half_float GL_EXT_copy_image GL_EXT_debug_label GL_EXT_discard_framebuffer GL_EXT_disjoint_timer_query GL_EXT_draw_buffers_indexed GL_EXT_draw_elements_base_vertex GL_EXT_float_blend GL_EXT_frag_depth GL_EXT_geometry_point_size GL_EXT_geometry_shader GL_EXT_gpu_shader5 GL_EXT_map_buffer_range GL_EXT_multi_draw_indirect GL_EXT_multisample_compatibility GL_EXT_occlusion_query_boolean GL_EXT_post_depth_coverage GL_EXT_primitive_bounding_box GL_EXT_raster_multisample GL_EXT_render_snorm GL_EXT_robustness GL_EXT_separate_shader_objects GL_EXT_shader_implicit_conversions GL_EXT_shader_integer_mix GL_EXT_shader_io_blocks GL_EXT_shader_texture_lod GL_EXT_shadow_samplers GL_EXT_sparse_texture GL_EXT_sparse_texture2 GL_EXT_sRGB GL_EXT_sRGB_write_control GL_EXT_tessellation_point_size GL_EXT_tessellation_shader GL_EXT_texture_border_clamp GL_EXT_texture_buffer GL_EXT_texture_compression_dxt1 GL_EXT_texture_compression_s3tc GL_EXT_texture_cube_map_array GL_EXT_texture_filter_anisotropic GL_EXT_texture_filter_minmax GL_EXT_texture_format_BGRA8888 GL_EXT_texture_norm16 GL_EXT_texture_rg GL_EXT_texture_sRGB_decode GL_EXT_texture_storage GL_EXT_texture_view GL_EXT_unpack_subimage GL_KHR_context_flush_control GL_KHR_debug GL_KHR_no_error GL_KHR_robust_buffer_access_behavior GL_KHR_robustness GL_KHR_texture_compression_astc_ldr GL_KHR_texture_compression_astc_sliced_3d GL_NV_bgr GL_NV_bindless_texture GL_NV_blend_equation_advanced GL_NV_blend_equation_advanced_coherent GL_NV_conditional_render GL_NV_conservative_raster GL_NV_copy_buffer GL_NV_copy_image GL_NV_draw_buffers GL_NV_draw_instanced GL_NV_draw_texture GL_NV_draw_vulkan_image GL_NV_EGL_stream_consumer_external GL_NV_explicit_attrib_location GL_NV_fbo_color_attachments GL_NV_fill_rectangle GL_NV_fragment_coverage_to_color GL_NV_fragment_shader_interlock GL_NV_framebuffer_blit GL_NV_framebuffer_mixed_samples GL_NV_framebuffer_multisample GL_NV_generate_mipmap_sRGB GL_NV_geometry_shader_passthrough GL_NV_instanced_arrays GL_NV_internalformat_sample_query GL_NV_gpu_shader5 GL_NV_image_formats GL_NV_occlusion_query_samples GL_NV_non_square_matrices GL_NV_pack_subimage GL_NV_packed_float GL_NV_packed_float_linear GL_NV_path_rendering GL_NV_path_rendering_shared_edge GL_NV_pixel_buffer_object GL_NV_polygon_mode GL_NV_read_buffer GL_NV_read_depth GL_NV_read_depth_stencil GL_NV_read_stencil GL_NV_sample_locations GL_NV_sample_mask_override_coverage GL_NV_secure_context GL_NV_shader_atomic_fp16_vector GL_NV_shader_noperspective_interpolation GL_NV_shadow_samplers_array GL_NV_shadow_samplers_cube GL_NV_sRGB_formats GL_NV_texture_array GL_NV_texture_border_clamp GL_NV_texture_compression_latc GL_NV_texture_compression_s3tc GL_NV_texture_compression_s3tc_update GL_NV_timer_query GL_NV_viewport_array GL_NV_viewport_array2 GL_KHR_blend_equation_advanced GL_KHR_blend_equation_advanced_coherent GL_OES_compressed_ETC1_RGB8_texture GL_OES_depth24 GL_OES_depth32 GL_OES_depth_texture GL_OES_depth_texture_cube_map GL_OES_copy_image GL_OES_draw_buffers_indexed GL_OES_draw_elements_base_vertex GL_OES_texture_border_clamp GL_OES_tessellation_point_size GL_OES_tessellation_shader GL_OES_texture_buffer GL_OES_geometry_point_size GL_OES_geometry_shader GL_OES_gpu_shader5 GL_OES_shader_io_blocks GL_OES_texture_view GL_OES_primitive_bounding_box GL_OES_EGL_image GL_OES_EGL_image_external GL_OES_EGL_image_external_essl3 GL_OES_EGL_sync GL_OES_element_index_uint GL_OES_fbo_render_mipmap GL_OES_get_program_binary GL_OES_mapbuffer GL_OES_packed_depth_stencil GL_OES_rgb8_rgba8 GL_OES_sample_shading GL_OES_sample_variables GL_OES_shader_image_atomic GL_OES_shader_multisample_interpolation GL_OES_standard_derivatives GL_OES_surfaceless_context GL_OES_texture_cube_map_array GL_OES_texture_npot GL_OES_texture_float GL_OES_texture_float_linear GL_OES_texture_half_float GL_OES_texture_half_float_linear GL_OES_texture_stencil8 GL_OES_texture_storage_multisample_2d_array GL_OES_vertex_array_object GL_OES_vertex_half_float GL_ANDROID_extension_pack_es31a
00:31:12 T:1398569264  NOTICE: CEGLNativeTypeAndroid: Current resolution: 1920x1080 @ 60.000000 - Full Screen
00:31:12 T:1398569264   ERROR: Window Translator: Can't find window tv
00:31:12 T:1398569264   ERROR: Window Translator: Can't find window pvrosddirector
00:31:12 T:1398569264   ERROR: Window Translator: Can't find window pvrosdcutter
00:31:13 T:1398569264   ERROR: Window Translator: Can't find window tv
00:31:13 T:1398569264   ERROR: Window Translator: Can't find window pvrosddirector
00:31:13 T:1398569264   ERROR: Window Translator: Can't find window pvrosdcutter
00:31:13 T:1398569264  NOTICE: Running database version Addons20
00:31:13 T:1398569264  NOTICE: Running database version ViewModes6
00:31:13 T:1398569264  NOTICE: Running database version Textures13
00:31:13 T:1398569264   ERROR: Unable to open database: kodivideooffline_99 [1049](Unknown database 'kodivideooffline_99')
00:31:14 T:1398569264  NOTICE: Running database version TV29
00:31:14 T:1398569264  NOTICE: Running database version Epg11
00:31:16 T:1398569264 WARNING: JSONRPC: Could not parse type "Setting.Details.SettingList"

As you can see in the advancedsetting.xml i choose the database name 'KodiVideoDatabase_' In the log SPMC tried to find 'kodivideooffline_99'
This was a testdatabase a time ago. But why tries SPMC to connect to this database? As you can see in the advancesettings.xml i have a different name.
I have cleared the cache and did a reboot of my shield but the error is the same.

Do you have any idea?
Spmc has GUI settings for mysql.
Once migrated, the advanced settings are ignored.
Thank you. I guess this is the explanation. I'll take a look deeper into the configuration of SPMC.