Thought I’d try out mariaDB. Re-indexing went fine, and according to my eyesight and phpmyadmin it populated the “missing” tables below, however, apparently not. What can cause this?
Log:
2020-09-16 15:22:30.995 T:3924792192 NOTICE: MYSQL: Connected to version 10.5.5-MariaDB
2020-09-16 15:22:31.003 T:3924792192 NOTICE: Running database version MyMusic72
2020-09-16 15:22:31.012 T:3924792192 NOTICE: Running database version MyVideos116
2020-09-16 15:22:31.015 T:3924792192 NOTICE: Running database version TV32
2020-09-16 15:22:31.017 T:3924792192 NOTICE: Running database version Epg12
2020-09-16 15:22:31.018 T:4062290512 NOTICE: start dvd mediatype detection
2020-09-16 15:22:31.080 T:4062290512 NOTICE: load skin from: /usr/share/kodi/addons/skin.estuary (version: 2.0.27)
2020-09-16 15:22:31.578 T:4062290512 ERROR: SQL: [MyMusic72] The table does not exist
Query: select count(idSong) as NumSongs from songview
2020-09-16 15:22:31.578 T:4062290512 ERROR: GetSongsCount() failed
2020-09-16 15:22:31.761 T:3916399488 ERROR: SQL: [MyVideos116] The table does not exist
Query: select * from movie_view WHERE (movie_view.idFile IN (SELECT DISTINCT idFile FROM bookmark WHERE type = 1))
my.cnf:
[mysqld]
port=3306
bind-address=0.0.0.0
# general stuff
# skip_name_resolve=1
key_buffer_size=16k
skip_name_resolve=1
query_cache_size=32M
query_cache_limit=2M
optimizer_search_depth=1
character-set-server=utf8
innodb_compression_default=OFF
innodb_log_buffer_size=32M
[client]
port=3306