Kodi Community Forum

Hi,

I'm trying to move my database to a MySQL server. I believe I succeded so far but when my library updates, there is no movie at all!

Here's what I've done so far;

I did follow this wiki to setup everything: http://wiki.xbmc.org/index.php?title=HOW...ab=Windows

I installed MySQL on a Server 2012 VM. I did open the correct firewall ports (Tried with firewall off as well)

I did setup my advancedsettings.xml file properly and my library even seems to update when I startup XBMC. (My Database was populated with all my movies and shows)

Obviously, I did something wrong since I had the following messages in my log file (posted below).

I'd like to know if anyone has an Idea of what could have went wrong?

Which path format should I use? (Both seem to work fine but who knows..)
SMB://server/share
\\server\share

PS; I'm using 12.2 on Windows 8.

Thanks!!!




CVideoDatabase::HasContent failed
17:39:19 T:4716 ERROR: SQL: The table does not exist
Query: SELECT movieview.idSet,COUNT(1) AS c FROM movieview JOIN sets ON sets.idSet = movieview.idSet GROUP BY movieview.idSet HAVING c>1
17:39:19 T:4716 ERROR: CVideoDatabase::HasSets failed
17:39:19 T:1128 DEBUG: CRecentlyAddedJob::UpdateMusic() - Running RecentlyAdded home screen update
17:39:19 T:4716 DEBUG: XBPython:rocess - no profile autoexec.py (C:\Users\ced.CK\AppData\Roaming\XBMC\userdata\autoexec.py) found, skipping
17:39:19 T:4716 DEBUG: CNetwork::NetworkMessage - Starting network services
17:39:19 T:4716 NOTICE: Webserver: Starting...
17:39:19 T:1128 DEBUG: GetRecentlyAddedAlbumSongs() query: SELECT songview.* FROM (SELECT idAlbum FROM albumview ORDER BY idAlbum DESC LIMIT 10) AS recentalbums JOIN songview ON songview.idAlbum=recentalbums.idAlbum
17:39:19 T:1128 ERROR: SQL: The table does not exist
Query: SELECT songview.* FROM (SELECT idAlbum FROM albumview ORDER BY idAlbum DESC LIMIT 10) AS recentalbums JOIN songview ON songview.idAlbum=recentalbums.idAlbum
17:39:19 T:1128 ERROR: CMusicDatabase::GetRecentlyAddedAlbumSongs failed
17:39:19 T:1128 DEBUG: CMusicDatabase::GetRecentlyAddedAlbums query: select * from albumview where strAlbum != '' order by idAlbum desc limit 10
17:39:19 T:1128 ERROR: SQL: The table does not exist
Query: select * from albumview where strAlbum != '' order by idAlbum desc limit 10
17:39:19 T:1128 ERROR: CMusicDatabase::GetRecentlyAddedAlbums failed
17:39:19 T:1128 DEBUG: CRecentlyAddedJob::UpdateVideos() - Running RecentlyAdded home screen update
17:39:19 T:1128 ERROR: SQL: The table does not exist
Query: select * from movieview ORDER BY dateAdded desc, idMovie desc LIMIT 10
17:39:19 T:1128 ERROR: CVideoDatabase::GetMoviesByWhere failed
17:39:19 T:1128 ERROR: SQL: The table does not exist
Query: select * from episodeview ORDER BY dateAdded desc, idEpisode desc LIMIT 10
17:39:19 T:1128 ERROR: CVideoDatabase::GetEpisodesByWhere failed
17:39:19 T:1128 ERROR: SQL: The table does not exist
Query: select * from musicvideoview ORDER BY dateAdded desc, idMVideo desc LIMIT 10
17:39:19 T:1128 ERROR: CVideoDatabase::GetMusicVideosByWhere failed

Full debug log (wiki) needed, and as the wiki notes, use smb://IP.ADDRESS.GOES.HERE/ and not \\server\etc

Hi there,

The thread can be closed.

I did delete all the database tables, I deleted my advancedsettings.xml and rebuilt it and everything worked out but I'm not sure what the error was..

Thanks