So it turned out to be that this is NOT valid even though it works:
GRANT ALL ON `kodi_video%`.* TO 'kodi';
GRANT ALL ON `kodi_music%`.* TO 'kodi';
FLUSH PRIVILEGES;This however fixes the problem:
GRANT ALL ON *.* TO 'kodi';
FLUSH PRIVILEGES;Just sharing in case someone else stumbles across the same issue
I basically just want to load a fresh instance of Kodi leveraging a local MySQL database. The fresh loading of a v10.0.2 seems to be bugged. It seems to detect what it needs to do correctly but when it starts running the inserts, create tables, create triggers, etc, it eventually just fails.
If i power of the Pi and drop the SQL tables; then restart the PI again, the same errors occur. So the bug appears to be in the database schema.
Just a little system details:
Cleared the database and set up permissions okay (verified i could log in as the kodi user and manage tables etc). Started up the PI and here are the logs in ~/.kodi/temp/kodi.log (i highlighted the errors in red)
...2022-09-21 01:43:43.022 T:726 INFO <general>: -----------------------------------------------------------------------
2022-09-21 01:43:43.022 T:726 INFO <general>: Starting Kodi (19.4 (19.4.0) Git:19.4-Matrix). Platform: Linux ARM 32-bit
2022-09-21 01:43:43.022 T:726 INFO <general>: Using Release Kodi x32
2022-09-21 01:43:43.022 T:726 INFO <general>: Kodi compiled 2022-03-05 by GCC 10.2.0 for Linux ARM 32-bit version 5.10.95 (330335)
2022-09-21 01:43:43.022 T:726 INFO <general>: Running on BCM2835 with LibreELEC (official): 10.0.2, kernel: Linux ARM 32-bit version 5.10.95
2022-09-21 01:43:43.022 T:726 INFO <general>: FFmpeg version/source: 4.3.2-Kodi
2022-09-21 01:43:43.022 T:726 INFO <general>: Host CPU: ARMv7 Processor rev 4 (v7l), 4 cores available
2022-09-21 01:43:43.022 T:726 INFO <general>: ARM Features: Neon enabled
# normal startup here... except the line below... i wonder if this is my problem?
2022-09-21 01:43:43.080 T:726 WARNING <CSettingsManager>: missing version attribute
2022-09-21 01:43:45.918 T:726 INFO <general>: Loading special://xbmc/system/keymaps/keyboard.xml
2022-09-21 01:43:45.932 T:726 INFO <general>: Loading special://xbmc/system/keymaps/mouse.xml
2022-09-21 01:43:45.933 T:726 INFO <general>: Loading special://xbmc/system/keymaps/remote.xml
2022-09-21 01:43:45.941 T:726 INFO <general>: Loading special://xbmc/system/keymaps/touchscreen.xml
2022-09-21 01:43:45.947 T:726 INFO <general>: GUI format 1920x1080, Display 1920x1080 @ 60.000000 Hz
2022-09-21 01:43:45.947 T:726 INFO <general>: CLangInfo: loading resource.language.en_gb language information...
2022-09-21 01:43:45.963 T:726 INFO <general>: global locale set to C
2022-09-21 01:43:45.963 T:726 INFO <general>: CLangInfo: loading resource.language.en_gb language strings...
2022-09-21 01:43:46.141 T:747 INFO <general>: Running database version Addons33
2022-09-21 01:43:46.146 T:747 INFO <general>: Running database version ViewModes6
2022-09-21 01:43:47.699 T:747 INFO <general>: Running database version Textures13
2022-09-21 01:43:48.130 T:747 INFO <general>: MYSQL: Connected to version 8.0.28
2022-09-21 01:43:48.136 T:747 ERROR <general>: Unable to open database: kodi_music82 [1049](Unknown database 'kodi_music82')
2022-09-21 01:43:48.194 T:747 ERROR <general>: Unable to open database: kodi_music81 [1049](Unknown database 'kodi_music81')
# ... <truncated - several versions checked; i presume this is normal and part of the migration process>
2022-09-21 01:43:51.023 T:747 ERROR <general>: Unable to open database: kodi_music32 [1049](Unknown database 'kodi_music32')
2022-09-21 01:43:51.084 T:747 INFO <general>: creating version table
2022-09-21 01:43:51.089 T:747 INFO <general>: create artist table
2022-09-21 01:43:51.096 T:747 INFO <general>: create album table
2022-09-21 01:43:51.102 T:747 INFO <general>: create audiobook table
2022-09-21 01:43:51.106 T:747 INFO <general>: create album_artist table
2022-09-21 01:43:51.109 T:747 INFO <general>: create album_source table
2022-09-21 01:43:51.113 T:747 INFO <general>: create genre table
2022-09-21 01:43:51.116 T:747 INFO <general>: create path table
2022-09-21 01:43:51.120 T:747 INFO <general>: create source table
2022-09-21 01:43:51.124 T:747 INFO <general>: create source_path table
2022-09-21 01:43:51.127 T:747 INFO <general>: create song table
2022-09-21 01:43:51.133 T:747 INFO <general>: create song_artist table
2022-09-21 01:43:51.137 T:747 INFO <general>: create song_genre table
2022-09-21 01:43:51.140 T:747 INFO <general>: create role table
2022-09-21 01:43:51.145 T:747 INFO <general>: create infosetting table
2022-09-21 01:43:51.148 T:747 INFO <general>: create discography table
2022-09-21 01:43:51.152 T:747 INFO <general>: create art table
2022-09-21 01:43:51.156 T:747 INFO <general>: create versiontagscan table
2022-09-21 01:43:51.161 T:747 INFO <general>: create removed_link table
2022-09-21 01:43:51.165 T:747 INFO <general>: CreateAnalytics - creating indices
2022-09-21 01:43:51.352 T:747 INFO <general>: create triggers
2022-09-21 01:43:51.353 T:747 ERROR <general>: SQL: [kodi_music82] Undefined MySQL error: Code (1419)
Query: CREATE TRIGGER tgrDeleteAlbum AFTER delete ON album FOR EACH ROW BEGIN DELETE FROM song WHERE song.idAlbum = old.idAlbum; DELETE FROM album_artist WHERE album_artist.idAlbum = old.idAlbum; DELETE FROM album_source WHERE album_source.idAlbum = old.idAlbum; DELETE FROM art WHERE media_id=old.idAlbum AND media_type='album'; END
2022-09-21 01:43:51.353 T:747 ERROR <general>: CreateDatabase unable to create database:0
2022-09-21 01:43:51.411 T:747 ERROR <general>: Unable to open database: kodi_video119 [1049](Unknown database 'kodi_video119')
# ... <truncated - several versions checked; i presume this is normal and part of the migration process>
2022-09-21 01:43:53.927 T:747 ERROR <general>: Unable to open database: kodi_video75 [1049](Unknown database 'kodi_video75')
2022-09-21 01:43:53.989 T:747 INFO <general>: creating version table
2022-09-21 01:43:53.994 T:747 INFO <general>: create bookmark table
2022-09-21 01:43:53.998 T:747 INFO <general>: create settings table
2022-09-21 01:43:54.004 T:747 INFO <general>: create stacktimes table
2022-09-21 01:43:54.007 T:747 INFO <general>: create genre table
2022-09-21 01:43:54.014 T:747 INFO <general>: create country table
2022-09-21 01:43:54.022 T:747 INFO <general>: create movie table
2022-09-21 01:43:54.027 T:747 INFO <general>: create actor table
2022-09-21 01:43:54.042 T:747 INFO <general>: create path table
2022-09-21 01:43:54.046 T:747 INFO <general>: create files table
2022-09-21 01:43:54.050 T:747 INFO <general>: create tvshow table
2022-09-21 01:43:54.055 T:747 INFO <general>: create episode table
2022-09-21 01:43:54.060 T:747 INFO <general>: create tvshowlinkpath table
2022-09-21 01:43:54.064 T:747 INFO <general>: create movielinktvshow table
2022-09-21 01:43:54.067 T:747 INFO <general>: create studio table
2022-09-21 01:43:54.075 T:747 INFO <general>: create musicvideo table
2022-09-21 01:43:54.080 T:747 INFO <general>: create streaminfo table
2022-09-21 01:43:54.085 T:747 INFO <general>: create sets table
2022-09-21 01:43:54.089 T:747 INFO <general>: create seasons table
2022-09-21 01:43:54.093 T:747 INFO <general>: create art table
2022-09-21 01:43:54.097 T:747 INFO <general>: create tag table
2022-09-21 01:43:54.104 T:747 INFO <general>: create rating table
2022-09-21 01:43:54.108 T:747 INFO <general>: create uniqueid table
2022-09-21 01:43:54.112 T:747 INFO <general>: CreateAnalytics - creating indices
2022-09-21 01:43:54.400 T:747 INFO <general>: CreateAnalytics - creating triggers
2022-09-21 01:43:54.401 T:747 ERROR <general>: SQL: [kodi_video119] Undefined MySQL error: Code (1419)
Query: CREATE TRIGGER delete_movie AFTER DELETE ON movie FOR EACH ROW BEGIN DELETE FROM genre_link WHERE media_id=old.idMovie AND media_type='movie'; DELETE FROM actor_link WHERE media_id=old.idMovie AND media_type='movie'; DELETE FROM director_link WHERE media_id=old.idMovie AND media_type='movie'; DELETE FROM studio_link WHERE media_id=old.idMovie AND media_type='movie'; DELETE FROM country_link WHERE media_id=old.idMovie AND media_type='movie'; DELETE FROM writer_link WHERE media_id=old.idMovie AND media_type='movie'; DELETE FROM movielinktvshow WHERE idMovie=old.idMovie; DELETE FROM art WHERE media_id=old.idMovie AND media_type='movie'; DELETE FROM tag_link WHERE media_id=old.idMovie AND media_type='movie'; DELETE FROM rating WHERE media_id=old.idMovie AND media_type='movie'; DELETE FROM uniqueid WHERE media_id=old.idMovie AND media_type='movie'; END
2022-09-21 01:43:54.402 T:747 ERROR <general>: CreateDatabase unable to create database:0
2022-09-21 01:43:54.418 T:747 INFO <general>: Running database version TV38
2022-09-21 01:43:54.424 T:747 INFO <general>: Running database version Epg13
2022-09-21 01:43:54.452 T:726 INFO <general>: start dvd mediatype detection
2022-09-21 01:43:54.569 T:726 INFO <general>: Unloaded skin
2022-09-21 01:43:54.573 T:726 INFO <general>: load skin from: /usr/share/kodi/addons/skin.estuary/ (version: 3.0.5)
2022-09-21 01:43:54.573 T:726 INFO <general>: load fonts for skin...
2022-09-21 01:43:54.617 T:726 INFO <general>: Loading skin includes from /usr/share/kodi/addons/skin.estuary/xml/Includes.xml
2022-09-21 01:43:54.827 T:726 INFO <general>: Loading fonts from /usr/share/kodi/addons/skin.estuary/xml/Font.xml
2022-09-21 01:43:54.969 T:726 INFO <general>: load new skin...
2022-09-21 01:43:54.970 T:726 INFO <general>: Loading custom window XMLs from skin path /usr/share/kodi/addons/skin.estuary/xml
2022-09-21 01:43:54.998 T:726 INFO <general>: initialize new skin...
2022-09-21 01:43:54.999 T:726 INFO <general>: Loading skin file: Custom_1109_TopBarOverlay.xml, load type: LOAD_ON_GUI_INIT
2022-09-21 01:43:55.062 T:726 INFO <general>: Loading skin file: DialogVolumeBar.xml, load type: LOAD_ON_GUI_INIT
2022-09-21 01:43:55.065 T:726 INFO <general>: Loading skin file: DialogBusy.xml, load type: LOAD_ON_GUI_INIT
2022-09-21 01:43:55.069 T:726 INFO <general>: Loading skin file: Pointer.xml, load type: LOAD_ON_GUI_INIT
2022-09-21 01:43:55.081 T:726 INFO <general>: Loading skin file: DialogExtendedProgressBar.xml, load type: LOAD_ON_GUI_INIT
2022-09-21 01:43:55.085 T:726 INFO <general>: Loading skin file: DialogSeekBar.xml, load type: LOAD_ON_GUI_INIT
2022-09-21 01:43:55.123 T:726 INFO <general>: Loading skin file: DialogNotification.xml, load type: LOAD_ON_GUI_INIT
2022-09-21 01:43:55.126 T:726 INFO <general>: Loading skin file: DialogBusy.xml, load type: LOAD_ON_GUI_INIT
2022-09-21 01:43:55.131 T:726 INFO <general>: Loading resource://resource.uisounds.kodi/sounds.xml
2022-09-21 01:43:55.264 T:726 INFO <general>: skin loaded...
2022-09-21 01:43:55.264 T:726 INFO <general>: Loading skin file: Startup.xml, load type: LOAD_EVERY_TIME
2022-09-21 01:43:55.265 T:726 INFO <general>: Loading skin file: Home.xml, load type: KEEP_IN_MEMORY
2022-09-21 01:43:55.477 T:726 ERROR <general>: SQL: [kodi_music82] The table does not exist
Query: select count(idSong) as NumSongs from songview
2022-09-21 01:43:55.478 T:726 ERROR <general>: GetSongsCount() failed
2022-09-21 01:43:56.421 T:726 WARNING <general>: JSONRPC: Could not parse type "Setting.Details.SettingList"
2022-09-21 01:43:56.422 T:726 INFO <general>: JSONRPC: Adding type "Setting.Details.SettingList" to list of incomplete definitions (waiting for "Setting.Details.Setting")
2022-09-21 01:43:56.425 T:726 INFO <general>: JSONRPC: Resolving incomplete types/methods referencing Setting.Details.Setting
2022-09-21 01:43:56.510 T:726 INFO <general>: JSONRPC v12.4.0: Successfully initialized
2022-09-21 01:43:56.530 T:726 INFO <general>: Register - new keyboard device registered on application->keyboard: Keyboard (0000:0000)
2022-09-21 01:43:56.532 T:726 INFO <general>: Register - new mouse device registered on application->mouse: Mouse (0000:0000)
2022-09-21 01:43:56.545 T:726 INFO <general>: Loading player core factory settings from special://xbmc/system/playercorefactory.xml.
2022-09-21 01:43:56.546 T:726 INFO <general>: Loaded playercorefactory configuration
2022-09-21 01:43:56.547 T:726 INFO <general>: Loading player core factory settings from special://masterprofile/playercorefactory.xml.
2022-09-21 01:43:56.547 T:726 INFO <general>: special://masterprofile/playercorefactory.xml does not exist. Skipping.
2022-09-21 01:43:56.547 T:726 INFO <general>: removing tempfiles
2022-09-21 01:43:56.559 T:726 INFO <general>: initialize done
2022-09-21 01:43:56.560 T:726 INFO <general>: Running the application...
2022-09-21 01:43:56.561 T:761 INFO <general>: initializing python engine.
2022-09-21 01:43:56.573 T:726 INFO <general>: starting zeroconf publishing
2022-09-21 01:43:56.573 T:726 INFO <general>: starting upnp client
2022-09-21 01:43:56.585 T:726 INFO <general>: starting upnp server
2022-09-21 01:43:56.593 T:726 INFO <general>: starting upnp renderer
2022-09-21 01:43:56.607 T:772 INFO <general>: ES: Starting UDP Event server on port 9777
2022-09-21 01:43:56.607 T:772 INFO <general>: UDP: Listening on port 9777 (ipv6 : true)
2022-09-21 01:43:56.607 T:726 INFO <general>: JSONRPC Server: Successfully initialized
2022-09-21 01:43:56.609 T:726 INFO <CWebserver[80]>: Started
2022-09-21 01:43:56.623 T:757 INFO <general>: Register - new cec device registered on cec->Linux: CEC Adapter (0000:0000)
2022-09-21 01:43:56.732 T:752 ERROR <general>: SQL: [kodi_music82] The table does not exist
Query: SELECT songview.*, songartistview.* FROM (SELECT idAlbum, dateAdded FROM album ORDER BY dateAdded DESC LIMIT 10) AS recentalbums JOIN songview ON songview.idAlbum = recentalbums.idAlbum JOIN songartistview ON songview.idSong = songartistview.idSong ORDER BY recentalbums.dateAdded DESC, songview.idAlbum DESC, songview.idSong, songartistview.idRole, songartistview.iOrder
2022-09-21 01:43:56.732 T:752 ERROR <general>: GetRecentlyAddedAlbumSongs failed
2022-09-21 01:43:56.734 T:752 ERROR <general>: SQL: [kodi_music82] The table does not exist
Query: SELECT albumview.*, albumartistview.* FROM (SELECT idAlbum FROM album WHERE strAlbum != '' ORDER BY dateAdded DESC LIMIT 10) AS recentalbums JOIN albumview ON albumview.idAlbum = recentalbums.idAlbum JOIN albumartistview ON albumview.idAlbum = albumartistview.idAlbum ORDER BY dateAdded DESC, albumview.idAlbum desc, albumartistview.iOrder
2022-09-21 01:43:56.734 T:752 ERROR <general>: GetRecentlyAddedAlbums failed
2022-09-21 01:43:57.316 T:752 ERROR <general>: SQL: [kodi_video119] The table does not exist
Query: select * from movie_view ORDER BY dateAdded desc, idMovie desc LIMIT 10
2022-09-21 01:43:57.317 T:752 ERROR <general>: GetMoviesByWhere failed
2022-09-21 01:43:57.319 T:752 ERROR <general>: SQL: [kodi_video119] The table does not exist
Query: select * from episode_view ORDER BY dateAdded desc, idEpisode desc LIMIT 10
2022-09-21 01:43:57.319 T:752 ERROR <general>: GetEpisodesByWhere failed
2022-09-21 01:43:57.322 T:752 ERROR <general>: SQL: [kodi_video119] The table does not exist
Query: select * from musicvideo_view ORDER BY dateAdded desc, idMVideo desc LIMIT 10
2022-09-21 01:43:57.322 T:752 ERROR <general>: GetMusicVideosByWhere failed
2022-09-21 01:43:57.413 T:752 ERROR <general>: SQL: [kodi_music82] The table does not exist
Query: SELECT COUNT(1) FROM artistview WHERE (EXISTS (SELECT 1 FROM song_artist WHERE song_artist.idArtist = artistview.idArtist AND song_artist.idRole = 1) OR EXISTS (SELECT 1 FROM album_artist WHERE album_artist.idArtist = artistview.idArtist)) AND (artistview.strArtist != '')
2022-09-21 01:43:57.413 T:752 ERROR <general>: GetSingleValueInt - failed on query 'SELECT COUNT(1) FROM artistview WHERE (EXISTS (SELECT 1 FROM song_artist WHERE song_artist.idArtist = artistview.idArtist AND song_artist.idRole = 1) OR EXISTS (SELECT 1 FROM album_artist WHERE album_artist.idArtist = artistview.idArtist)) AND (artistview.strArtist != '')'
2022-09-21 01:43:57.414 T:752 ERROR <general>: SQL: [kodi_music82] The table does not exist
Query: SELECT count(1) FROM songview LIMIT 1
2022-09-21 01:43:57.415 T:752 ERROR <general>: GetSingleValue - failed on query 'SELECT count(1) FROM songview LIMIT 1'
2022-09-21 01:43:57.416 T:752 ERROR <general>: SQL: [kodi_music82] The table does not exist
Query: SELECT count(distinct strAlbum) FROM songview LIMIT 1
2022-09-21 01:43:57.416 T:752 ERROR <general>: GetSingleValue - failed on query 'SELECT count(distinct strAlbum) FROM songview LIMIT 1'
2022-09-21 01:43:57.493 T:752 ERROR <general>: SQL: [kodi_video119] The table does not exist
Query: SELECT count(1) FROM tvshow_view LIMIT 1
2022-09-21 01:43:57.494 T:752 ERROR <general>: GetSingleValue - failed on query 'SELECT count(1) FROM tvshow_view LIMIT 1'
2022-09-21 01:43:57.495 T:752 ERROR <general>: SQL: [kodi_video119] The table does not exist
Query: SELECT count(1) FROM movie_view LIMIT 1
2022-09-21 01:43:57.495 T:752 ERROR <general>: GetSingleValue - failed on query 'SELECT count(1) FROM movie_view LIMIT 1'
2022-09-21 01:43:57.496 T:752 ERROR <general>: SQL: [kodi_video119] The table does not exist
Query: SELECT count(playCount) FROM movie_view LIMIT 1
2022-09-21 01:43:57.496 T:752 ERROR <general>: GetSingleValue - failed on query 'SELECT count(playCount) FROM movie_view LIMIT 1'
2022-09-21 01:43:57.497 T:752 ERROR <general>: SQL: [kodi_video119] The table does not exist
Query: SELECT count(1) FROM musicvideo_view LIMIT 1
2022-09-21 01:43:57.498 T:752 ERROR <general>: GetSingleValue - failed on query 'SELECT count(1) FROM musicvideo_view LIMIT 1'
2022-09-21 01:43:57.499 T:752 ERROR <general>: SQL: [kodi_video119] The table does not exist
Query: SELECT count(playCount) FROM musicvideo_view LIMIT 1
2022-09-21 01:43:57.499 T:752 ERROR <general>: GetSingleValue - failed on query 'SELECT count(playCount) FROM musicvideo_view LIMIT 1'
2022-09-21 01:43:57.500 T:752 ERROR <general>: SQL: [kodi_video119] The table does not exist
Query: SELECT sum(watchedcount) FROM tvshow_view LIMIT 1
2022-09-21 01:43:57.500 T:752 ERROR <general>: GetSingleValue - failed on query 'SELECT sum(watchedcount) FROM tvshow_view LIMIT 1'
2022-09-21 01:43:57.501 T:752 ERROR <general>: SQL: [kodi_video119] The table does not exist
Query: SELECT sum(totalcount) FROM tvshow_view LIMIT 1
2022-09-21 01:43:57.501 T:752 ERROR <general>: GetSingleValue - failed on query 'SELECT sum(totalcount) FROM tvshow_view LIMIT 1'
2022-09-21 01:43:57.502 T:752 ERROR <general>: SQL: [kodi_video119] The table does not exist
Query: SELECT sum(watchedcount = totalcount) FROM tvshow_view LIMIT 1
2022-09-21 01:43:57.502 T:752 ERROR <general>: GetSingleValue - failed on query 'SELECT sum(watchedcount = totalcount) FROM tvshow_view LIMIT 1'
2022-09-21 01:43:59.300 T:773 INFO <general>: JSONRPC Server: New connection added
2022-09-21 01:43:59.884 T:761 INFO <general>: SETTINGS: set_keyboard_layout # us
2022-09-21 01:43:59.884 T:761 INFO <general>: SETTINGS: set_keyboard_layout # loadkmap < `ls -1 /usr/lib/keymaps/*/us.bmap`
2022-09-21 01:44:02.257 T:761 INFO <general>: ## LibreELEC Addon ## updates::updateThread ## Started
2022-09-21 01:44:02.260 T:761 INFO <general>: ## LibreELEC Addon ## updates::set_auto_update ## manual
2022-09-21 01:44:02.448 T:832 INFO <general>: SETTINGS: run # Waiting
2022-09-21 01:45:28.405 T:726 INFO <general>: Samba is idle. Closing the remaining connectionsWhen i start scanning the library it produces a lot of errors about missing tables, and when it's all done there is nothing to list...
2022-09-21 02:13:52.196 T:726 ERROR <general>: SQL: [kodi_video119] The table does not exist
Query: select * from movie_view WHERE c23=1
# ... then tryign to populate it, tons of errors like this appear
2022-09-21 13:00:58.551 T:7998 ERROR <general>: GetEpisodesByWhere failed
2022-09-21 13:01:20.833 T:8008 ERROR <general>: SQL: [kodi_video119] The table does not exist
Query: SELECT COUNT(1) FROM tvshow_view
2022-09-21 13:01:20.833 T:8008 ERROR <general>: GetSingleValue - failed on query 'SELECT COUNT(1) FROM tvshow_view '
2022-09-21 13:01:20.835 T:8008 ERROR <general>: SQL: [kodi_video119] The table does not exist
Query: SELECT * FROM tvshow_view LIMIT 157
2022-09-21 13:01:20.835 T:8008 ERROR <general>: GetTvShowsByWhere failed
2022-09-21 13:01:20.923 T:8008 ERROR <general>: SQL: [kodi_video119] The table does not exist
Query: select COUNT(1) from episode_view
2022-09-21 13:01:20.923 T:8008 ERROR <general>: GetSingleValue - failed on query 'select COUNT(1) from episode_view '
2022-09-21 13:01:20.924 T:8008 ERROR <general>: SQL: [kodi_video119] The table does not exist
Query: select * from episode_view LIMIT 814
2022-09-21 13:01:20.924 T:8008 ERROR <general>: GetEpisodesByWhere failed
2022-09-21 13:01:26.358 T:8008 ERROR <general>: SQL: [kodi_video119] The table does not exist
Query: select * from movie_view
2022-09-21 13:01:26.358 T:8008 ERROR <general>: GetMoviesByWhere failed
2022-09-21 13:01:28.168 T:8030 ERROR <general>: SQL: [kodi_video119] The table does not exist
Query: select * from movie_view JOIN sets ON movie_view.idSet = sets.idSet ORDER BY sets.idSet
2022-09-21 13:01:28.168 T:8030 ERROR <general>: GetMoviesByWhere failed
2022-09-21 13:01:28.301 T:8030 ERROR <general>: SQL: [kodi_video119] The table does not exist
Query: select COUNT(1) from movie_view
2022-09-21 13:01:28.301 T:8030 ERROR <general>: GetSingleValue - failed on query 'select COUNT(1) from movie_view '
2022-09-21 13:01:28.303 T:8030 ERROR <general>: SQL: [kodi_video119] The table does not exist
Query: select * from movie_view LIMIT 472I can't populate the database (from scratch at all). I've tried droping all databases several times and powering back up the Kodi instance (LibrELEC) and it consistently produces the same results.
Before i fall back to an ealier working version, i don't mind working with devs to help debug... Also it could very well be the user 
; Perhaps you can spot something obvious i'm missing other then having just the DB ready to be written to? Is there another step i need to do first? Or is there a spot i could load the schema manually and jsut run from then?